Creating a Custom Query - trillium_quality - 2.7

Trillium Quality for Dynamics Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Version
2.7
Language
English
Product name
Trillium Quality
Title
Trillium Quality for Dynamics Guide
Topic type
Administration
Overview
Installation
Reference
How Do I
Configuration
First publish date
2008
ft:lastEdition
2023-05-25
ft:lastPublication
2023-05-25T13:35:56.864032

You can create custom queries to select specific records to be processed by a standard batch request. For example, you can create a custom query to select only records for accounts located in a certain city. To create a custom query, use CRM’s Advanced Find feature.

To create a custom query

  1. In CRM, click Advanced Find. The Advanced Find window opens.

    Advanced Find
  2. Create your query. See the Dynamics 365 help system for information about creating queries.

  3. When the query is complete, click Download Fetch XML  and save the file. By default, FetchXML files are saved inyour Downloads directory. To make it easier for users to locate the files, save the files to your Trillium Quality for Dynamics install directory.

  4. Open the saved FetchXML file using an XML editor and copy the XML.

    Note: Do not copy the XML statements from a browser window; extraneous characters will be copied.
  5. Paste the XML into the batch request, as described in Custom FetchXml Batch Type, and run the request.