- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2016 11:06 PM
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
Solved! Go to Solution.
- 20,494 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2016 01:58 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2017 11:46 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-25-2018 01:30 PM
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:
Best,
Dan R
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2022 10:39 AM
Hi How did you find this Module? Where you set the catalog item? Could you please clarify