locked
Change of Option Set Values RRS feed

  • Question

  • Hi all,

    I have changed the values in an option set on CRM.  I have just realised that this has removed all data that was previously saved under the old value.  Is it possible to recover this data?

    Thanks.

    Monday, November 3, 2014 3:21 PM

All replies

  • Hi Roar,

    What I did was:

    • Created a custom option set field in a custom entity;
    • Added a few options to it;
    • Created a new record, chose an option and saved;
    • Delete the option I chose above from the field;
    • Opened the record and the field was blank.

    So, I went to check the database and the integer value was still there:

    See if you can build a query to search for your affected records.

    Hope it helps.

     

    Monday, November 3, 2014 4:07 PM
  • The value that was changed will be present in the database. 

    Suppose your old value of optionset was 1 and new value of optionset is 2

    What you need to do is set all the optionsets with value 1 in the database to 2. Run the below sql update.

    Update tablename
    
    set optionsetname = 2
    
    where optionsetname =1



    Regards, Saad

    Tuesday, November 4, 2014 4:47 AM
  • your best option would be to look for a SQL backup before your changes.

    regards

    Jithesh

    Tuesday, November 4, 2014 12:14 PM