Reporting on Variables

dlemasurer · ‎07-04-2017

I have some Variables on our supprot portal specfically for getting more infomation at the point of the issue being raised, hwoever once the Incidet is created I'm not able to report on thses fields meaning the additional data is usless.

Shahed Shah1 · ‎07-04-2017

You don't need PA. All you have to do is create a Database View connecting three tables:

Incident
question_answer (connects the variables to the incident)
item_option_new (these are the variables)

There are two fields on the question_answer table that you need to utilise so that you can link it to the incidents:

table_name (name of the target table, i.e. incident)
table_sys_id (sys_id of the incident record)

Then you can create a Report on this database view like you would do on a table

View solution in original post

Anna Gausel · ‎08-26-2018

Hi there,

How do you define the 'where clauses' when creating the dependency view?

Cheers,

Anna

JC S_ · ‎10-29-2019

Were you able to make this work? We have the same requirement.

JC S_ · ‎10-29-2019

All - if you want ServiceNow to consider delivering this functionality out of the box, please vote on this idea on the newly launched Idea Portal.