Reporting on record producer variable

[faizu]

Hi,

I need to do a reporting on record producer variable.

As far as I know we have question answer table that stores variable responses but it is not good to do report on this table as it has large amount of data plus it is not domain separated. Moreover the reference field stores sys_id in string format.

database view is also not possible as we have multiple reference fields across different recod producers.

Any other efficient way to do report?

Regards,

Faizan

[Brad Bowman]

So you're talking about record producer variables that are not defined as mapped to a field on the producer table?  Just curious if you are using producer.variable_name in your record producer script to do something with these values, or else what is the point of having reference fields on a RP that aren't used for anything?

[faizu]

Hi Brad,

Thanks for your response.

yes, the variables are not mapped with target table fields. User needs to provide some additional information while creating ticket like some questions that we are using as variables. these variables are shown in variable editor on INC. I am looking the ways to report on these variables.

Regards,

Faizan

[asifnoor]

Hello Faizu,

Generally the record producer variables are linked to the records and you can acces sthe data using either that recordobj.variablename.

What exactly is the report you are trying to make here?

[Ankur Bawiskar]

@faizu 

Currently the only possible ways are

1) Database view by joining the question_answer and the task table

OR

2) report directly on question_answer table

Regards
Ankur