Clase de FetchXmlToQueryExpressionRequest

Artigo
12/03/2014

Se aplica a: CRM 2015 on-prem, CRM Online

Contains the data that is needed to convert a query in FetchXML to a QueryExpression.

Espacio de nombres: Microsoft.Crm.Sdk.Messages
Ensamblado: Microsoft.Crm.Sdk.Proxy (en Microsoft.Crm.Sdk.Proxy.dll)

Sintaxis

'Declaración
<DataContractAttribute(Namespace:="https://schemas.microsoft.com/crm/2011/Contracts")> _
Public NotInheritable Class FetchXmlToQueryExpressionRequest
    Inherits OrganizationRequest

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

Ejemplo

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.

// Create a Fetch query that we will convert into a query expression.
var fetchXml =
    @"<fetch mapping='logical' version='1.0'>
     <entity name='opportunity'>
      <attribute name='name' />
      <filter>
       <condition attribute='estimatedclosedate' operator='next-x-fiscal-years' value='3' />
      </filter>
      <link-entity name='account' from='accountid' to='customerid'>
       <link-entity name='contact' from='parentcustomerid' to='accountid'>
        <attribute name='fullname' />
        <filter>
         <condition attribute='address1_city' operator='eq' value='Bellevue' />
         <condition attribute='address1_stateorprovince' operator='eq' value='WA' />
        </filter>
       </link-entity>
      </link-entity>
     </entity>
    </fetch>";

// Run the query with the FetchXML.
var fetchExpression = new FetchExpression(fetchXml);
EntityCollection fetchResult =
    _serviceProxy.RetrieveMultiple(fetchExpression);
Console.WriteLine("\nOutput for query as FetchXML:");
DisplayOpportunityQueryResults(fetchResult);

// Convert the FetchXML into a query expression.
var conversionRequest = new FetchXmlToQueryExpressionRequest
{
    FetchXml = fetchXml
};

var conversionResponse =
    (FetchXmlToQueryExpressionResponse)_serviceProxy.Execute(conversionRequest);

// Use the newly converted query expression to make a retrieve multiple
// request to Microsoft Dynamics CRM.
QueryExpression queryExpression = conversionResponse.Query;

EntityCollection result = _serviceProxy.RetrieveMultiple(queryExpression);

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

Comentarios

Message Availability

Este mensaje funciona independientemente de si el autor de la llamada está conectado al servidor o no.

Usage

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

Privileges and Access Rights

For a complete list of the required privileges, see FetchXmlToQueryExpression Privileges.

Notes for Callers

The use of the keyword Distinct in query expressions is different from the FetchXML query language. When mapping a query from Fetch to QueryExpression, results will not be consistent if the Distinct keyword is used in the FetchXML string.

Jerarquía heredada

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

Seguridad de hilo

Los miembros estáticos públicos (Shared en Visual Basic) de este tipo son seguros para el hilo. No se garantiza que los miembros de instancia sean seguros para el hilo.

Plataformas

Plataformas de desarrollo

Windows Vista, Windows Server 2003 y

Plataformas de destino

Windows Vista,Windows XP

Change History

Vea también

Referencia

Miembros de FetchXmlToQueryExpressionRequest
Espacio de nombres de Microsoft.Crm.Sdk.Messages
FetchXmlToQueryExpressionResponse

Otros recursos

Create Queries to Retrieve Data
FetchXML Schema
Sample: Convert Queries Between Fetch and Query Expression

Compartir por