Custom fields – Converting Option Sets

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:

  • Paribus Discovery
  • Microsoft Dynamics 365 / Dynamics CRM
  • Infor CRM / Saleslogix

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.

Converting Option Sets with SQL Case statement

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.

 Related Resources:
Further Information:


See the Paribus Help Center User Guidelines for important considerations of use.