Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

how to know the option set name using its value??

Posted on by 5,005

Hi, all

One of my collegue has removed the option set  

Note: He left the company now

and i want to know the value of it  how can i know that value??? is it possible?

for better understand i am giving exampe below

Option set =Washington DC

ITS VALUE = 100000020  similarly 

we have option set=select

Its value i need to know

*This post is locked for comments

  • Verified answer
    Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,397 on at
    RE: how to know the option set name using its value??

    ok.

    When an item is removed from the optionset, still the records would keep the originally set value.

    In the form it would show blank.

    When you add a new item with the same value (same or any other label), it would show the new label in the form.

    You can check the values in SQL.

    Alternatively.

    If you are not sure, then add few values (make sure that all the values are in sequence). find out the record with these values.

    Now you can find out from the record what could be the right label for the values used already. Modify the label again accordingly for those in question.

    Use Advanced find to do this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to know the option set name using its value??

    By default if you remove the items from option set in the solution that should also remove it from all records it was contained in,maybe when you open the record the optionset should be empty.

    You need to go to SQL and find those records,then on the records you will find the option set value Of that record even if the option set value is removed  in CRM GUI, anything written on the DB is never deleted even if deleted inside CRM unless you delete it manually within DB.

  • sandeepc Profile Picture
    sandeepc 5,005 on at
    RE: how to know the option set name using its value??

    the items are being used in records and he removed that item

  • Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,397 on at
    RE: how to know the option set name using its value??

    Do you mean he removed an item from the option set, but that item is being used in the records?

    Or

    You just want to know the value of each item in the option set?

  • Rajat Awasthi Profile Picture
    Rajat Awasthi 675 on at
    RE: how to know the option set name using its value??

    .

  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    Rajkumar Rajaraman 18,108 on at
    RE: how to know the option set name using its value??

    Refer this thread:

    community.dynamics.com/.../199892

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,104 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans