How to modify Available Relationships on CI Relationship Builder?

[gmorales]

Hi everyone, does anybody knows how to modify the default filters created on CI Relationship Builder (see attachments) I need to add another condition to a default filter, these are loaded when a user clicks on any of the available relationships.

[nishi8]

Hi Guillermo,

Did you get the solution for this.I am facing the same issue.

[danielbilling]

Please check your Suggested Relationships and verify if Base Class= Application have multiple relations to Dependent Class= database

//Daniel

[nishi8]

Hi Daniel,

The issue is that the filter that gets loaded first time is correct but it gets repeated for all other relationships. That means when i am selecting the other relationships for the same class the filter gives me same result inspite of different values in my Suggested relationships.

This filter gets created in a OOB script include"AddRelationshipQuery" . I added a log to check the filter query that gets returned from there and found that the sql query is absolutely correct for every relationship but dont understand why only the first query is getting reflected on Relationship builder.

I have created two custom fields on Suggested Relationship table for some customization but i dont think that could be the reason for this issue.

Thanks

Nishi Sharma