I'm looking for assistance on how to perform an Except or Anti-Join using FetchXML. For instance:
ResourceTable: [1, 2, 3, 4, 5]
ResourceBookingTable: [3,4,3,3,5] (Filtered by time)
ResourceTable SubGrid Result: [1,2,4]
(essentially: Don't show records in Table1 that have a record in Table2)
Intent:
To display resources that aren't booked during a specific time period in a form subgrid. The subgrid is filtered by date values on the form.
The current approach involves using a link-entity filter with FetchXML.
I can filter both Resource Table and the Booking Table, however, I haven't spotted a way to exclude ID's present in the filtered Booking Table from the Resource Table.
