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.
All my customers are usually asking how to export members of the segments to excel or CSV. This feature is also requested by people at experience.dynamics.com, and so far is planned for April 2020. You can read more here: Ability to export Segment members to Excel. In this article, I would like to show you how you can build a fetchxml which will export members data from the segment.
In this article, I would like to review some fetch XML expressions for operator LIKE and ways you can use to improve your search capabilities. I will also explain how indexes work and what are the solutions you can use when Dynamics Customer Engagement uses scan instead of seeking operation.