Report does not display record producer variable data

gaf627 · ‎10-03-2017

I am trying to create a report on an Incident record producer that displays the variable record data. It is a very simple list report with a single variable called Building. I can get the label to display in column, but the data is hidden. Here are some screenshots and explanations of how I got here.

List report result:

The selected columns from the Incident table. I was able to select the Building variable by first selecting Questions and then the Report an Issue record producer and Building

If I double- click on the Building field, I can see that the data is there and prevented by Security.

I am logged in as Admin and still get this result. Any help is appreciated, as I need to provide similar data from another record producer for an audit. Thanks!

gaf627 · ‎10-06-2017

It turns out this is a known problem - PRB712052, and will not be addressed until Kingston or after. I was able to implement a workaround using a database view with the Incident table (left join) and the Question Answers (question_answer) table. Although, not ideal if you have many variables, I was able to extract the data.

View solution in original post

Priya Shekar · ‎10-04-2017

Hi Greg,

Please check ACLs for this table, hope there is a write acl restriction for it.

gaf627 · ‎10-04-2017

The only ACL for Question Answer is read requiring the role catalog_admin. I suspect this is the issue, but I'm not sure how to fix it. I've tried adding roles, as well as creating other ACLs for question_answer. This issue also exists in my personal developer instance. I've opened an issue with ServiceNow support.

Priya Shekar · ‎10-04-2017

Did you try making that particular ACL inactive.

To check whether that ACL is causing the issue.

gaf627 · ‎10-05-2017

I did and still have the same issue. However, I'm not sure how no ACL would change anything.