PowerExchange for Microsoft Dynamics CRM User Guide

10.5.8
- 10.5.9
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

Query Properties

The Data Integration Service generates a default SQL query that it uses to read data from Microsoft Dynamics CRM. The default query is a SELECT statement for each column that it reads from the sources. You can override the default query through the simple or advanced query.

The following table describes the query properties that you configure for Microsoft Dynamics CRM entities:

Property	Description
Join	User-defined join in a data object. A user-defined join specifies the condition used to join data from multiple sources in the same data object.
Filter	Filter value in a read operation. The filter specifies the where clause of select statement. Use a filter to reduce the number of rows that the Data Integration Service reads from the source. When you enter a source filter, the Developer tool adds a WHERE clause to the default query.
Sort	Sorts the rows queried from the source. The Data Integration Service adds the ports to the ORDER BY clause in the default query.

Rename Saved Search

Table of Contents

PowerExchange for Microsoft Dynamics CRM User Guide

PowerExchange for Microsoft Dynamics CRM User Guide

Query Properties

Query Properties