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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

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"]

Was this reply helpful? Yes No