Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Remove unused options from an option set RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a field that is an option set. At some point during take on of data, there was some real rubbish in the data. All the bad data was corrected and re-loaded, however all the mis-spelled rubbish seems to have found its way into the option set. I HAVE to remove it.

    All the data is 100% valid now but on input of new data, the user has the option to choose options which are not valid.

    I cannot see how its done.

    Any help much appreciated.

    Monday, December 5, 2011 3:40 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    You can remive the OptionSet values from the entity field customization properties i.e. Settings-> Customization->Customizaitons->Customize the System-> Entities-> <Entity Name> -> Fields , double click on the OptionSet field, select OptionSet value and click on delete ( - ) button. Publish entity customizations.

    You can also add JScript on your Form Onload event to remove the OptionSet value programtically. i.e.

    Xrm.Page.getControl("optionset_name").removeOption(907670000);

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Monday, December 5, 2011 4:22 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    You can remive the OptionSet values from the entity field customization properties i.e. Settings-> Customization->Customizaitons->Customize the System-> Entities-> <Entity Name> -> Fields , double click on the OptionSet field, select OptionSet value and click on delete ( - ) button. Publish entity customizations.

    You can also add JScript on your Form Onload event to remove the OptionSet value programtically. i.e.

    Xrm.Page.getControl("optionset_name").removeOption(907670000);

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Monday, December 5, 2011 4:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks!
    Wednesday, December 7, 2011 10:40 AM