25
if i have two options data type field on custom entity, with option values as below
0- Hide
1- Show
values saved into the entity/table is 0 or 1., if i like to get text Hide or Show what is the underlying table name.
Eg: for Option Set , StringMap table has all values.
Hi Dear,
Greetings of the day!
In regards to your concern, If f you want to get label of field value then try the below things on your end:
For c#: Use
string value=entityObj.FormattedValue["paymenttermscode"];
Instead of
string value=entityObj.Attributes["paymenttermscode"];
For js Use
var value=resObj["paymenttermscode@OData.Community.Display.V1.FormattedValue"];
Instead of
var value=resObj["paymenttermscode"];
Kindly try the above things on your end and let us know in case of any other concerns, I would be happy to assist you further for the same
Kind Regards,
CRMjetty
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Hi,
I strongly believe that two-option field option labels are stored in StringMap as well. However, pulling these data directly from the database would NOT be a good idea at all, since it would be wildly unsupported by Microsoft.
If you're doing this for reporting purposes, you might want to consider using the Filtered Views, which denormalize data and actually contain the labels you need.
If you're doing this from a custom application, you might want to use SDK or the WebAPI to query these labels: docs.microsoft.com/.../use-web-api-metadata
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
