Some users are not able to see variable columns of sc_req_item

[Stephie Soo]

Hi all,

I want my users to be able to view the sc_req_item variables in portal side page via using "Data Table from URL definition widget" link used will be eg. "https://xxxx.service-now.com/xxxxx?id=pageID&t=sc_req_item&view=xxxxx", therefore i found this article "Article #19 - How to show Catalog Variables on RIT... - ServiceNow Community" and followed the steps. 

However, it seems like some users are not able to see the variable columns, but some are able to and i believe is due to them are not allowed to access via the backend/platform. As such, anyone has any workaround/alternative way so they can see the sc_req_item variables in portal? 

[Kieran Anson]

If you're using the standard ticket page, variables can be shown on a per record basis. But with you using a data table, I gather the intention is a list view.

The Data Table from URL Definition explicitly enables ACLs because GlideRecordSecure is used. You would need to clone widget-data-table to work-around this

[Stephie Soo]

Able to share after cloning what needs to be changed? 

I edited to use GlideRecord instead of GlideRecordSecure but still not showing for some users. Any tips?

[Kieran Anson]

After digging a bit deeper, because both the Data Widget, and the Data widget from URL definition handle the URL parameters differently, I'd suggest creating a page and using the "Data Table From Instance Definition"

What I did

• Created a new page via service portal configuration (portal designer)
• Added the 'Data Table from Instance Definition'
• Edited the instance definition to specify the table, filter, and fields 

The fields were then accessible by itil and non-itil (ess) users.

[Stephie Soo]

Hi @Kieran Anson , sorry for the late reply, this sounds like a good idea. However, my sc_cat_item has variables "item_option_new_set", do you know how to enable "Data Table from Instance Definition" widget to show the variables?