View variables in a report

[Dan Brown2]

Hi,

We use a Record Producer to create records on a custom table, and they appear on the form fine.  But when I report on them the users can't view them as columns.

These are none itil users (i.e a custom app and role) - so I wondered if there was ACL elsewhere that needed amending to included the custom role?

Any help much appreciated,

Cheers,

Dan

[Ahmmed Ali]

Hi,

variables can not be reported from record producers.

you can create a database view of your target table and "question_answer" table (here all variable values are stored).

you user query on question_answer table as "que_table_sys_id=cus_sys_id" where que is  question_answer table prefix and cus is your custom table prefic in database view.

Please refer below link for more details on Database view.

https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/reporting/concept/c_DatabaseViews.html

Let me know for any query.

Thanks,

Ali

[reginabautista · Accepted solution]

Hi as far as I know you can't report on record producer variable responses. They are however located in the 'question_answer' table. Please note though that this table contains millions of records so might take take a while to load and generate report.

[Dan Brown2]

Thanks for the replies.

I have added the Variables from the Questions option in the Available list and selected the ones required.  Then I can view them in the report as columns.

I can view them ok (as an admin) - but the other users with the custom role can't.  They appear in the Selected List, but not as a column.

[andersbogsjo]

Thoose Variable questions is stored in the Table Question (question)and it has ACL:s on it, maybe it works if you change (or creates a copy of the OOTB ACL -  read

Regards

Anders