Sometimes we need to build a query which will return some data based on not lookup attributes, but on text attributes. You might need this when correct relationships between entities were not adequately defined during the implementation phase, but links between different objects can be determined by using data stored in the text fields. As an example, let’s check how to return data about the contact and related organization just using an email address.
Continue reading “Linking data in FetchXml using text fields”