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

[Manuela Blaj]

Hi Mussie,

I created a read ACL on sc_item_option without a role and I am still not able to see the variables in the list.  Can you please let me know if I understood the solution or what am I doing wrong?

Thanks in advance,

Manuela

[Topan Kamil]

How do you do that

[rakesh_ng87]

How can we add variable set in list view ? I can add variables in list view, but variables of variable set are not appearing LIST

[Paramahanns]

Ok Mussie, Glad that you got the solution. I see your solution as

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

what was the action that you actually did.. You removed the roles for the tables..Can you please explain more.

[Mussie]

Hi Rakesh/Paramahanns,

I have followed the steps outlined in my first post and I then created an ACL without a role for the tables I mentioned and that solved my issue.

Mussie