QueryExpressionToFetchXmlRequest QueryExpressionToFetchXmlRequest QueryExpressionToFetchXmlRequest QueryExpressionToFetchXmlRequest Class

Definition

Contains the data that is needed to convert a query, which is represented as a QueryExpression class, to its equivalent query, which is represented as FetchXML.

For the Web API use the QueryExpressionToFetchXml Action .

Web API support for this message was added with December 2016 update for Microsoft Dynamics 365 (online) and December 2016 Service Pack for Microsoft Dynamics 365 (on-premises) .

public ref class QueryExpressionToFetchXmlRequest sealed : Microsoft::Xrm::Sdk::OrganizationRequest
[System.Runtime.Serialization.DataContract(Namespace="http://schemas.microsoft.com/crm/2011/Contracts")]
public sealed class QueryExpressionToFetchXmlRequest : Microsoft.Xrm.Sdk.OrganizationRequest
type QueryExpressionToFetchXmlRequest = class
    inherit OrganizationRequest
Public NotInheritable Class QueryExpressionToFetchXmlRequest
Inherits OrganizationRequest
Inheritance
QueryExpressionToFetchXmlRequestQueryExpressionToFetchXmlRequestQueryExpressionToFetchXmlRequestQueryExpressionToFetchXmlRequest
Attributes

Examples


// Build a query expression that we will turn into FetchXML.
var queryExpression = new QueryExpression()
{
    Distinct = false,
    EntityName = Contact.EntityLogicalName,
    ColumnSet = new ColumnSet("fullname", "address1_telephone1"),
    LinkEntities = 
        {
            new LinkEntity 
            {
                JoinOperator = JoinOperator.LeftOuter,
                LinkFromAttributeName = "parentcustomerid",
                LinkFromEntityName = Contact.EntityLogicalName,
                LinkToAttributeName = "accountid",
                LinkToEntityName = Account.EntityLogicalName,
                LinkCriteria = 
                {
                    Conditions = 
                    {
                        new ConditionExpression("name", ConditionOperator.Equal, "Litware, Inc.")
                    }
                }
            }
        },
    Criteria =
    {
        Filters = 
            {
                new FilterExpression
                {
                    FilterOperator = LogicalOperator.And,
                    Conditions = 
                    {
                        new ConditionExpression("address1_stateorprovince", ConditionOperator.Equal, "WA"),
                        new ConditionExpression("address1_city", ConditionOperator.In, new String[] {"Redmond", "Bellevue" , "Kirkland", "Seattle"}),
                        new ConditionExpression("createdon", ConditionOperator.LastXDays, 30),
                        new ConditionExpression("emailaddress1", ConditionOperator.NotNull)
                    },
                },
                new FilterExpression
                {
                    FilterOperator = LogicalOperator.Or,
                    Conditions =
                    {
                        new ConditionExpression("address1_telephone1", ConditionOperator.Like, "(206)%"),
                        new ConditionExpression("address1_telephone1", ConditionOperator.Like, "(425)%")
                    }
                }
            }
    }
};

// Run the query as a query expression.
EntityCollection queryExpressionResult =
    svc.RetrieveMultiple(queryExpression);
Console.WriteLine("Output for query as QueryExpression:");
DisplayContactQueryResults(queryExpressionResult);

// Convert the query expression to FetchXML.
var conversionRequest = new QueryExpressionToFetchXmlRequest
{
    Query = queryExpression
};

var conversionResponse =
    (QueryExpressionToFetchXmlResponse)svc.Execute(conversionRequest);

// Use the converted query to make a retrieve multiple request to Microsoft Dynamics CRM.
String fetchXml = conversionResponse.FetchXml;
var fetchQuery = new FetchExpression(fetchXml);
EntityCollection result = svc.RetrieveMultiple(fetchQuery);

// Display the results.
Console.WriteLine("\nOutput for query after conversion to FetchXML:");
DisplayContactQueryResults(result);

Remarks

Message Availability

This message works regardless whether the caller is connected to the server or offline.

Usage

Pass an instance of this class to the Execute(OrganizationRequest) method, which returns an instance of the QueryExpressionToFetchXmlResponse class.

Privileges and Access Rights

For a complete list of the required privileges, see QueryExpressionToFetchXml message privileges.

Notes for Callers

Use of the keyword distinct in query expressions is different from the FetchXML query language. When you map a query from Fetch to QueryExpression, you receive inconsistent results if you use the Distinct keyword in the FetchXML string.

Constructors

QueryExpressionToFetchXmlRequest() QueryExpressionToFetchXmlRequest() QueryExpressionToFetchXmlRequest() QueryExpressionToFetchXmlRequest()

Initializes a new instance of the the QueryExpressionToFetchXmlRequest class.

Properties

ExtensionData ExtensionData ExtensionData ExtensionData

Gets or sets the structure that contains extra data. Optional.

(Inherited from OrganizationRequest)
Item[String] Item[String] Item[String] Item[String]

Gets or sets the indexer for the Parameters collection.

(Inherited from OrganizationRequest)
Parameters Parameters Parameters Parameters

Gets or sets the collection of parameters for the request. Required, but is supplied by derived classes.

(Inherited from OrganizationRequest)
Query Query Query Query

Gets or sets the query to convert.

RequestId RequestId RequestId RequestId

Gets or sets the ID of an asynchronous operation (system job). Optional.

(Inherited from OrganizationRequest)
RequestName RequestName RequestName RequestName

Gets or sets the name of the request. Required, but is supplied by derived classes.

(Inherited from OrganizationRequest)

Applies to

See also