Adding catalog variables to the list view

[Mussie]

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:

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

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

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

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

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

Any other ideas?

Mussie

[ariesmanlangit]

Hi.

        You need to configure the list layout of the sc_req_item. heheh         Just right click any column header and select Configure> List Layout and arrange the necessary fields. By doing this you are modifying the global settings of the list layout. I think you can also create a custom list layout.

Hope this helps.

thank you.

a.c.manlangit

serviceNow Developer - Philippines

[Mussie]

Thanks for the reply Ariestotle, that didn't help. Perhaps creating a custom list will do the trick, can you give me some more hint?

Mussie

[Mussie · Accepted solution]

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

[Mussie]

Just a quick update.

I later discovered that the only ACL that is relevant is sc_item_option. I disabled the rest (question, sc_item_option) and still getting the same result, so that ACLs aren't requred. However, sc_item_option_mtom ACL is available out of the box and needs to be left untouched.

Mussie