QueryExpressionToFetchXmlRequest クラス

適用対象: CRM 2015 on-prem, CRM Online

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.

名前空間: Microsoft.Crm.Sdk.Messages
アセンブリ: Microsoft.Crm.Sdk.Proxy (Microsoft.Crm.Sdk.Proxy.dll に含まれる)

構文

'宣言
<DataContractAttribute(Namespace:="https://schemas.microsoft.com/crm/2011/Contracts")> _
Public NotInheritable Class QueryExpressionToFetchXmlRequest
    Inherits OrganizationRequest

[DataContractAttribute(Namespace="https://schemas.microsoft.com/crm/2011/Contracts")] 
public sealed class QueryExpressionToFetchXmlRequest : OrganizationRequest

例

The following example shows how to use this message. For this sample to work correctly, you must be connected to the server to get an IOrganizationService interface. For the complete sample, see the link later in this topic.

// 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 =
    _serviceProxy.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)_serviceProxy.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 = _serviceProxy.RetrieveMultiple(fetchQuery);

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

備考

Message Availability

このメッセージは、呼び出し元がサーバーに接続されているか、オフラインであるかに関係なく機能します。

Usage

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

Privileges and Access Rights

For a complete list of the required privileges, see QueryExpressionToFetchXml 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.

継承階層

System.Object
Microsoft.Xrm.Sdk.OrganizationRequest
Microsoft.Crm.Sdk.Messages.QueryExpressionToFetchXmlRequest

スレッドセーフ

この種類のパブリックな静的 (Visual Basic では Shared) メンバーはスレッドセーフです。インスタンスメンバーがスレッドセーフであることは保証されません。

次の方法で共有

QueryExpressionToFetchXmlRequest クラス

構文

例

備考

継承階層

スレッド セーフ

プラットフォーム

開発プラットフォーム

対象プラットフォーム

Change History

関連項目

参照

他のリソース

その他のリソース

スレッドセーフ