Personalized Community is here!
Quickly customize your community to find the content you seek.
Learn about installation, licenses and upgradesGuides overview | FAQ
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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)
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,
Hi Manojmathe, for better visibility try the Power Apps community at Power Apps Community - Power Platform Community (microsoft.com). This forum is for Dynamics 365 Guides, a mixed reality training/guidance app.
Business Applications communities