Where Can I Find the Display Values for State, Impact Urgency and Priority

johnfeist
Mega Sage
Mega Sage

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

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster
1 ACCEPTED SOLUTION

Community Alums
Not applicable

Check the 'Choices' table. You can see both the value and label of the choice.


Tim

View solution in original post

5 REPLIES 5

Thank you Kristen.  I'm pulling data straight out of the tables so I need to actually do the joins to get the look up values.  In essence I'm reproducing the functionality of getDisplayvalue() since I'm working at a lower level than the glide records which are an abstraction above the tables..

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster