How to show display value of a variable in a database view

[Cassandra Cuppl]

Good afternoon - I am attempting to create a database view to report on Catalog item variables and struggling in getting the display name of the variable to show instead of the value. 

I have joined the table as seen below and am pulling back the noted fields from the sc_item_option table. Any help would be appreciated!

[Community Alums]

Hi @Cassandra Cupples ,

If you are saying you want to show variables under RITM in database view columns; then it is not possible since those variables and values are stored in this table Variable Ownership (sc_item_option_mtom).

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[shloke04]

Hi,

Please refer the below blogs which talks about the same query you are having, this hould solve your issue I believe:

https://community.servicenow.com/community?id=community_article&sys_id=59c5c11cdbaed810fb4ae15b8a9619e4

https://community.servicenow.com/community?id=community_blog&sys_id=e94d2229dbd0dbc01dcaf3231f96190f

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Cassandra Cuppl]

I have already created the database view, similar to those in the links provided, but I am having issues getting the display value of the variable to show versus the value.

I am not sure if there is another join that would possible give me that?