Forum Discussion

inescosta's avatar
inescosta
Icon for Advocate II rankAdvocate II
9 years ago

Related problem

    I am trying to use data from table ProjetoSegmento(2) and ProjetoSegmentoOrcamento in table ProjectoSegmento using function Related. But it doesn't work. But I don't understand why since...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

That is going to depend on a whole raft of things like what specifically you are trying to accomplish. Some things that you can try, you can check out USERELATIONSHIP and perhaps you are running into a scenario where the cross-filtering is causing you issues, you could try to make the relationships filter in only one direction. If you could provide some data (text) and specifically what you are trying to achieve, that would help tremendously.

inescosta's avatar
inescosta
Icon for Advocate II rankAdvocate II
9 years ago

 

 

 

So tabele ProjetoSegmento(2) is a duplicate of ProjetoSegmento because I need to create a column  with all the dates between two sets of dates related to the beginning and end of a project. So I used Number.from[stardate]..Number.from[enddate] and created column [diasdeprojeto], since each project has several days I them had to expand the list and got a table with ProjetoSegmentoID repetead. and know I need to get the column [quant] in table ProjetoSegmento(2), using the relationship [id] in table projectoSegmento(2) (which is repeat) with [ProjectSegmentoId] in table ProjetoSegmentoOrcamento. Both tables are linked to ProjetosSegmento which has the primary informations.

 

Was I clear?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi inescosta,

    Thanks for your detail description. If there is one to many relation table A(one) and table B(many), you only use related function in table B which have multiple values. If you used related in table A direction, it will return error. Because it doesn’t verify which one should be return.

    >> So tabele ProjetoSegmento(2) is a duplicate of ProjetoSegmento because I need to create a column  with all the dates between two sets of dates related to the beginning and end of a project. So I used Number.from[stardate]..Number.from[enddate] and created column [diasdeprojeto], since each project has several days I them had to expand the list and got a table with ProjetoSegmentoID repetead.

    You should count the days in ‘ProjetoSegmentoOrcamento’ table for each ID. Then summarize it using appropriate function based on your requirement in ‘ProjetoSegmento(2)’ table. Finally, you can used related function in ‘ProjetoSegmento’ table to get the result.

    If this is not what you want, please share the sample data and expected result for further analysis.

    Best Regards,
    Angelia