in which table are the close codes for an incident stored (close_code)

reradus
Kilo Contributor

in which table are the close codes for an incident stored (close_code) I'm closing incidents via the rest api, I need to know where those values are stored so I can populate dropdowns

find_real_file.png

1 ACCEPTED SOLUTION

Check the dictionary of the cause code field. If it has a choice list in its dictionary, it should be in sys_choice table. If it is pointing to a table, you will get those values in that table. If it is dynamically generated using a client script, you will have to search for that client script


Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

4 REPLIES 4

SanjivMeher
Kilo Patron
Kilo Patron

It is in sys_choice table


Please mark this response as correct or helpful if it assisted you with your question.

and the cause codes? those don't seem to be documented anywhere, at least I've not found them in any table

Cause codes may be custom fields that are created by your organization depending on business needs.

Right click on the field and choose show choice list. It will show you the list of options for Cause Codes Field


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Check the dictionary of the cause code field. If it has a choice list in its dictionary, it should be in sys_choice table. If it is pointing to a table, you will get those values in that table. If it is dynamically generated using a client script, you will have to search for that client script


Please mark this response as correct or helpful if it assisted you with your question.