Fetch xml query

(0) Share

Report

Posted on by Pete_N

1,703

CRM2016 on Premises

I have an xml query with an attribute new_service which is an option set. can I get that option set value within my fetch XML?

<fetch top="50" >
  <entity name="account" >
    <attribute name="new_servicename" alias="service" />
    <attribute name="new_companyname" alias="companyname" />
    <attribute name="address1_composite" alias="address" />
  </entity>
</fetch>

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Fetch xml query

Yes you can get option set value. Just use schema name "new_service". I have noticed that you are using "new_servicename". Please make sure correct name.

If you are looking to retrieve Option set label then you have to use below line of code:

string label=entity.FormattedValues["new_service"]
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Fetch xml query

Hello ,

Have a look below reference -

From JS -

mahadeomatre.blogspot.com/.../use-fetchxml-to-retrieve-data-from-ms.html

From C# code -

arunpotti.wordpress.com/.../fetch-xml
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

RE: Fetch xml query

Hi PeteN,

You can test your xml using using FetchXml builder or using CRM chrome extension. Please refer below url for reference:

pravinpawarweb.wordpress.com/.../dynamics-crm-extension-for-developers-dynamics-crm-hudcrm-0-1-3-2

http://fxb.xrmtoolbox.com/
Suggested answer

Guido Preite 54,077 Moderator on at

Like (0)

Report

RE: Fetch xml query

yes, you can query optionsets

if you want to build and test your fetchxml you can use this amazing tool FetchXML Builder for XrmToolBox

http://fxb.xrmtoolbox.com/