web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Global optionset not showing data when querying stringmap entity using fetchxml.

(0) ShareShare
ReportReport
Posted on by

Hi,

I am using global optionset containing list of counties for one of our requirements. I have created this global option set in dev environment and then I moved the solution to UAT. After moving the solution in UAT, the global optionset values are not displaying on the form. I have created the lookup field in one of the entities and when I look at the look up in the advance find in UAT I can see the data but while querying the global optionset fetchxml code in XRM tool Box i dont see the data. Here is the fetchxml for the global optionset that i have created.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
<entity name="stringmap" >
<attribute name="attributevalue" />
<attribute name="value" />
<filter type="and" >
<condition attribute="attributename" operator="eq" value="new_county" />
</filter>
</entity>
</fetch>

Can anyone tell me why I dont see the data of the global optionset in UAT?

I have the same question (0)
  • Johao Larios Profile Picture
    1,795 on at

    Try by creating a view from CRM containing the data needed.

    Then, export the fetch from that view an try again.

    Regards,

  • Community Member Profile Picture
    on at

    Yes, I am trying to see the data in global option set County. The fetch is right and also works for other Global option sets in my UAT environment, but it doesn't work for County Global Option set, for some reason it doesn't give any data to me.

  • Johao Larios Profile Picture
    1,795 on at

    Hello,

    If you check the global option set, do you see the values for all the options? 

    regards

  • Community Member Profile Picture
    on at

    I have three global option sets and I can see the values of the two of them but not of new_county, the one I am talking about here.

    Thanks,

    Ayush

  • Johao Larios Profile Picture
    1,795 on at

    Hello Ayush,

    what happens if you retrieve the values using webapi? do you see the values?

  • Suggested answer
    Nate7171 Profile Picture
    5 on at

    I found after adding a value to an option set it isn't in stringmap until doing a solution deploy with the optionset in the solution.  Unfortunate as I have to use webapi and parse to retrieve values.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans