Adding catalog variables to the list view

Mussie
ServiceNow Employee
ServiceNow Employee

Hi Guys,

I need to add the catalog item variables to the list view so that they are viewable as columns not just values. I know for sure that creating a database view will not do the trick, however I was lucky enough to stumble on the below link which solved 90% of my issue:

PSA: How to View Variables in Lists

However, I still have few issues but first let me list things I have done:

- Created a custom view on the forum with the fields I require:

find_real_file.png

Then went to System UI > List and created the following and added each variable in a format variable.<sys_id>:

find_real_file.png

When I created a menu item and added this view, it gave me the results I am after

find_real_file.png

Now, I am able to see the variables as columns if I login as ITIL:

find_real_file.png

However, when I try to access the same view using a user who have no role, then I get this:

find_real_file.png

I know for sure, this not an ACL issue because end users can see the variable details:

find_real_file.png

Any other ideas?

Mussie

1 ACCEPTED SOLUTION

Mussie
ServiceNow Employee
ServiceNow Employee

Thanks guys, I was able to resolve this by creating without a role for the below tables:



sc_item_option_mtom


item_option_new


question


sc_item_option



I am now able to see the variables as columns.


Mussie


View solution in original post

12 REPLIES 12

Matt Hernandez
Tera Guru

We were using this functionality, but it broke when we upgraded from Helsinki to Jakarta. I believe its no longer possible to display catalog variables in a list. Just in case, I created a HI ticket and asked them but they said its not possible, and when I referenced these articles they said it was not supported.


Dan R3
Kilo Expert

The above was very useful, however there is a mistake in the steps provided which I think is where much of this threads' confusion lies.

 

Correction to above:

When you go to SystemUI > List, and identify the list to add the list elements to, you need to do 'variables.<sys_id>.' In your steps you indicate variable.<sys_id> (no 's' in variables) and that didn't work but as soon as I changed it to "variables". it worked just fine and appeared as soon as I switched to the indicated 'view'.

Hope this helps!

Screenshot below:

find_real_file.png

 

 

Best,

 

Dan R

Muskan Hans2
Tera Contributor

Hi How did you find this Module? Where you set the catalog item? Could you please clarify