Unable to see the RITM variables as a columns in report for ITIL users

[JK9903]

Hello Everyone, 

I've created a report on RITM table and in the columns, I've selected the columns from RITM variables. As an admin I can able to see the variables in report but for ITIL users the columns are not visible. Any ideas on why this is not visible?

Note: This catalog item is in a custom application and the ITIL user has all the necessary roles related to the custom app

[GlideFather]

Hi @JK9903,

answers from variables are stored in different table (question_answer) than ritms (sc_req_item), so it is likely that the itil users don't have visibility to that variable table... 

Check the read and report access for itil on that table

[JK9903]

Hi @GlideFather ,

Thank you for your response, I've checked the ACL for the question_answer table and it has a read and report_view ACL for catalog_admin role. I gave this role to the ITIL grp still unable to see the variables in the report

[GlideFather]

OK @JK9903, I am running out of ideas, but when it comes to reviewing any of the access rights, I use the Access Analyser, you can give it a try as well:

Select a user, table and optionally fields to better understand the security applied in that case. Not sure if that help but you can give it a try

[JK9903]

Hi @GlideFather , @Ankur Bawiskar

I've checked in the access analyzer it shows the read and report_view as passed, but still unable to see it as an ITIL user. 

ITIL user are able to see and edit the variables in the RITM