Change of Option Set Values

All replies

• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  your best option would be to look for a SQL backup before your changes.

  regards

  Jithesh

  Tuesday, November 4, 2014 12:14 PM