Fetch all parents who does not have child

In one of scenario I was looking for all available Assets only, means show only those assets who are available for particular data range. Just like get all parents who does not have any child. So, after some googling i found below way, but i was showing all booked and non booked assets for given … Continue reading Fetch all parents who does not have child

Advertisements

FetchXML Query with NOT-IN

If you want to get all available Resources of specific Resource Category that don't have any booking for the particular period with FetchXML,  I tried NOT-IN clause and landed in following error, Microsoft.Crm.CrmException: Unknown Condition Operator: not- in at Microsoft.Crm.Platform.QuerySerializationUtil.ConditionOperatorFromString(String operatorText) But OUTER join worked for the scenario and it gave the correct result. With small … Continue reading FetchXML Query with NOT-IN