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]

Below is the screenshot of the widget instance I created whilst testing this approach. The final item in the selected box is an example of a variable included. If you're unable to dot-walk to it via the 'Available' list of fields, you can use snutils to amend the list field directly

Below showing SN Utils edit functionality. variables are added with the 'variables' prefix and the sys_id of the variable

[Ankur Bawiskar · Accepted solution]

@Stephie Soo 

Did you check any table level READ ACL on that table "sc_item_option_mtom" is blocking the access?

Is it working fine for admins?

also check in those individual variables if any READ role is added in variable configuration?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Stephie Soo]

Thank you for your reply. I checked the ACL for "sc_item_option_mtom" and its readable by a role but i checked the user that can see the variables does not have that role. 

While for the individual variables, currently none of the variables have any read roles added, so technically it shouldnt be caused by that right? 

[Ankur Bawiskar]

@Stephie Soo 

admins can see all the variables?

[Stephie Soo]

Hi @Ankur Bawiskar , sorry for the late reply. I've checked the ACL, seems like that is why some users are unable to see however i am not the main admin so my account has no permission to toggle the ACL.  

I also tried adding the user role into the variable configuration "Read Role" but i guess the permission strictly follows ACL first.