Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Adding catalog variable as a column in the list view using Database view

Momiji
Tera Contributor

Hi Everyone! Just want to know if it's possible to add a catalog variable as a column in the list view using Database view?
So we already created a database view joining these tables (sc_req_item, sc_item_option_mtom, sc_item_option), and what I can show as a column for now is the Question field from sc_item_option. But what I want to happen is that a specific question/variable from a catalog item will be shown as a column.

 

This can be done in the sc_req_item by configuring the view in sys_ui_list. In the List Elements, the catalog variable can be added by inputting variables.[sys_id of the catalog variable]. Is there a way that something like this can be done when using Database view? Thanks in advance!

1 REPLY 1

Rafael Batistot
Mega Patron

Hi @Momiji 

 

This post might help you 

 

https://www.servicenow.com/community/itsm-articles/adding-catalog-items-variables-as-columns-in-list...

 

If this response was helpful, please mark it as Helpful and, if applicable, as Correct.
This helps other users find accurate and useful information more easily