Share
Report
10HI
I have few questions when i am building my fetch xml to retrive the data , it would be great if someone can help me with suggestions or approach.
1. I have 3 entities ( entity1,entity2,entity3)
Entity1
E1C1 E1C2
1 user1
2 user2
Entity2 ( relationship to Entity1 is 1 (Entity1) : N (entity2) :E1c1 is the realtionsjip)
E2C1 E2C2 E1C1
1 State1 1
1 State1 2
2 Stae2 2
3 Stae3 2
Entity 3( relationship to Entity2 is 1 (Entity2) : N (entity3) :E2C1 is the realtionship)
E3C1 E3C2 E2C1
1 City1 1
1 City1 2
2 City2 1
3 City4 2
I want the data with this filtering conditions (E1C2=user1 and E2C2 = 1 and E3C2=City 2) OR (E1C2=user2 and E2C2=State2 and E3C2=City4)
The relationship between the tables are manditory there can be records in Entity1 but not related to any record in Entuty2 and same for Entity3
i am finding diffidulty to have these conditons of multiple entities which are related for these cases
1. The column filters are related and if i have to apply the and operator on individual table thats not possible
2. If i apply the filters at once using alias, as these record relationship are not manditory across entity some column may miss out for the joins.
Let me know if someone had these issues or some thoughts on this.
Thanks in advance,
Manoj.
All responses (
Answers (
