- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2018 12:45 PM
I'm importing ServiceNow data into SQL Server to handle a number of management reports that I cannot find a way to do in ServiceNow. When I extract state, impact, urgency and priority I get the numeric values. While I can build the lookup table(s) to convert the numbers to words, I'd rather just import the data in presentation form. Can anyone tell me where the labels that go with the values are stored?
Thanks in advance for any suggestions.
John
:{)
Helpful and Correct tags are appreciated and help others to find information faster
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2018 01:06 PM
Check the 'Choices' table. You can see both the value and label of the choice.
Tim

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2018 01:06 PM
Check the 'Choices' table. You can see both the value and label of the choice.
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-17-2018 03:03 PM
Thank you Tim. That was what I needed. After some head scratching that lead me to the ACL's it's exactly what I need!
:{)
Helpful and Correct tags are appreciated and help others to find information faster
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2018 01:12 PM
How are you extracting the data from ServiceNow? If via a script in servicenow, you should be able to use .getDisplayValue() to grab the display rather than the back end value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2018 01:15 PM
Or, if you're using the api, you should be able to include sysparm_display_value=true in your call to get the display rather than the back end.