Tuesday 31 May 2016

CRM 2015 - Filtered View using a Lookup in the Criteria

Consider you want to use a lookup as part of your filter criteria.  You would presumably use "Where lookup Equals mylookup" however when doing this the following fetch XML is returned.



When exporting to another environment it appears that it is looking at the GUID and not the name.  The short term fix I'm using is to instead use Contains.