Incident Report Variables

[Ralton Stewart]

I need to create a report on  the incident table but require the attached variables. 

[jMarshal]

That looks like a record producer, not an incident itself -- very common for client reported incidents.

Do you know how your fields are mapped? What does the flow/execution engine of the record producer do with the values submitted?

...often it will just write them to a comment and if that's the case, you'll need to parse your comments via script to report on them as values...though you can probably include the info as a comment instead of a value (not sure on your business requirements)...

[Tai Vu]

Hi @Ralton Stewart 

You can use this table Question Answers [question_answer] for the record producer variables.

Let's create a database view to link the question_answer and incident table. Then do create the report on that db view.

Let me know if it works for you.

Cheers,

Tai Vu

[swathisarang98]

Hi @Ralton Stewart ,

You can create a simple report on Incident Table then in Configure - > Choose Column You can select "Questions[+]"  click on  expand and select your record producer then select all the field that you want to add in the Report then click ok and save the report you will get all the variable required from record producer in the report.

Please find the below snapshots, 

 

    

Please check and Mark Helpful and Correct if it really helps you.

Regards,

Swathi Sarang

 

  

[Patrick Rodrigu]

Is there a way to restrict the available Record Producers when "questions" is expanded through ACL or Business Rule?