Dataverse: How to use the condition operator or in multiple tables in FetchXML

Today we will learn how to use the conditional operator “Or” when applying addPresearch in Javascript (but you also can implement it from the backend too). The scenario that we will apply is, on the Contacttable, we have a lookup to Parent Contact/Account. In the below image, we can see that I prepare data where there is Contactthat have Parent Accountand Parent Contact:

Open full article

Dataverse: How to use the condition operator or in multiple tables in FetchXML – Temmy Wahyu Raharjo

More about FetchXML

The condition operator “or” in FetchXML allows you to join multiple tables in Dataverse and create a query that retrieves data from more than one table. Using the condition operator “or” allows you to join tables with the same or different entities and retrieve data from multiple tables.

To use the condition operator “or” in FetchXML, you need to use the element. Within the element, you can use the condition operator “or” to join multiple tables. For example, if you wanted to retrieve data from two accounts and two contacts, you could write the following:

In the example above, the element is used to join two accounts and two contacts. The condition operator “or” is used to join the two accounts and two contacts. The attribute and value of each account and contact are specified in the condition. This allows you to retrieve data from multiple tables in one query.

Using the condition operator “or” in FetchXML can be a powerful way to join multiple tables and retrieve data from more than one table in Dataverse.

More links on about Power Platform/Microsoft Dataverse

• Use FetchXML to construct a query - Power Apps

Mar 23, 2022 — Learn how you can use the query condition operators to query tables with explicit hierarchical relationships.

• Query MS Dataverse tables with FetchXML Builder ... - YouTube

8 key moments in this video

• FetchXML "OR" Condition using multiple link-entities

Not in this result: Dataverse: ‎| Must include: Dataverse:

• Fetch Xml vs Filter Queries in Power Automate

Mar 16, 2023 — You can filter the items that you want, select the columns but also collect data form multiple tables. Joining tables. To create a join between ...

• Perform complex Dataverse FetchXml queries using Power ...

Oct 9, 2022 — 2. Add a Dataverse List Rows action, and then in the Table