Hi folks,
Working in Dataverse here. I need to retrieve a list of Contacts that either have no case record associated, OR only case records with status Resolved or Canceled.
I'm struggling to build this query, in part because the filter options in Dynamics do not offer the Or functionality across multiple tables. Currently I'm trying my luck with the Dataverse REST builder and the Fetch XML builder within XRM Toolbox, but seem to be getting stuck. this is my latest FetchXML try:
</filter>
<link-entity name="incident" alias="ab" link-type="inner" from="customerid" to="contactid">
<filter type="or">
<condition attribute="statecode" operator="eq" value="0"/>
<condition attribute="customerid" operator="null" entityname="ab"/>
</filter>
</link-entity>
This is if course not the complete XML. When running this in the Builder, I get an error implicating that I should remove the "entityname="ab"" but that results in another error.
Not sure how to proceed here - any advice would be greatly appreciated!