Retrieve OptionSet Label using Odata query

(0) Share

Report

Posted on by Community Member

Hi guys

Do you know how to retrieve the label of the selected value in an option set using Odata?

I have this query

var ODATA_Set = "?$select=pwc_AircraftStatus,pwc_EventDate,pwc_EventType,
pwc_HighVizReportReqmnt,pwc_HighVizTransmitted,pwc_NextActionDue,
pwc_RealTimestatusofAircraft,StateCode,TicketNumber,Title
&$filter=(pwc_HighVizReportReqmnt/Value eq 117280000 
and pwc_HighVizTransmitted eq true) or 
pwc_EventDate ge datetime'2014-12-02T12:00:00' 
and StateCode/Value ne 2 and not substringof('test',Title)";

retrieveMultiple("IncidentSet", ODATA_Set, 
                  SetHighVizReport_DescriptionCaseQuery, 
                  QueryError, false);

But I only get the numeric Value of the selected option
Do you know how to get the label?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

You can't get that using Odata, for that you need to write a query to return metadata so you have to use execute method using SOAP, Check this post: http://himbap.com/blog/?p=752

Thanks

Was this reply helpful? Yes No
gopi.royal999@gmail... 430 on at

Like (0)

Report
Copy link

Link copied!

Hi, Check the below.

http://mscrmtechie.blogspot.in/2015/11/retrieve-option-set-text-from-crm.html

You need to add SDK.Metadata.js as reference.

--

Gopinath

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks for your answer for I don't understand the code

In this part:

DK.Metadata.RetrieveAttribute(EntityLogicalName, AttributeLogicalName, "00000000-0000-0000-0000-000000000000", true,

what does the "0000000-0000....." means? is the id of the option set or the value I'm looking for?

Was this reply helpful? Yes No
Suggested answer

Sayhaitokumar 7,042 on at

Like (0)

Report
Copy link

Link copied!

Hi Alan,

Follow the below blog you may get some idea

365dynamicscrm.wordpress.com

Was this reply helpful? Yes No
gopi.royal999@gmail... 430 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can just pass the same 00000's. You will get the output.

Was this reply helpful? Yes No