Forum Discussion

tanjum_shaikh_altegra_se's avatar
tanjum_shaikh_altegra_se
Ideator I
3 months ago

Can we add multiple reverse relations targeting a single relation?

Hi,

We have the following scenario: I have a custom itemtype which has relationships with different itemtypes like Part, Requirement, etc. Now I want to show the reverse relation on my custom item type pointing to Part and Requirement. On custom Itemtype we have one relationship that has the source itemtype as custom itemtype and related itemtype is null.  On this single relationship can we add reverse relation using a Relationship View for both Part and Requirement, and more? If yes, how to add more than one Relationship View?

Or if there is any other way that leads to showing the different itemtypes relation using a single relationship?

 

Thanks in advance.

Best regards
Tanjum

1 Reply

  • KevinF's avatar
    KevinF
    Ideator III
    3 months ago

    Not sure I'm following that you only have one relationship table I would have expected multiple as generally there would be one for each item you are relating to.  For myself when I have A related to B and A related to C that causes 2 relationships and I want to open B and see any A's I would use Query Builder and Tree Grid View.  If your data doesn't tie that cleanly (I think it should) you can create a SQL view and create a Federated Item for the view and use that item as the source for the Query Builder.   Not hard but more steps so hopefully you can use the already existing relationship records.