|Summary:||This articles walks you through converting Option Sets and how you can use them in Paribus Discovery.|
|Article Type:||How-To Guide, Technical Article|
|Related Product(s):||This article relates to the following products:
Custom fields – Converting Option Sets code to text values
Sometimes the field we need is only held as code which references an option set. If it is not possible to retrieve the field value then a SQL CASE statement can be used to convert the values. Example below.
When you click on “OK” button you will be prompted with an Dependency Check pane to advise of any associated objects that will be affected > Confirm by clicking on “Yes” button.