Report does not display record producer variable data

[gaf627]

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!

[Jaspal Singh]

Hi Greg,

Look for ACL on table item_option_new & then add itil role to it for read operation.

This would help in achieving what is expected.

[gaf627]

The itil role is there for the read operation on item_option_new out of box.   I believe item_option_new is for catalog items, not record producers.   I do not have the same issue with catalog items.

[gaf627 · Accepted solution]

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.

[LA_]

Hello @gaf627 I am also encountering this error even on Paris. Has there been any update on a fix for this one? Thanks in advance.

[mvivar]

See the accepted answer on this page https://community.servicenow.com/community?id=community_question&sys_id=2f38b2b4db66ac104aa5d9d96896...

I tried it and it worked!