Database view on Incident and Question Answer[question_answer] table.

[niitnishant]

Hi Friends,

I am trying to establish a database view on incident and question answer table. Want to report all the variable answers for respective incidents.

The logic above shows multiple entries for an incident for each variable.. e.g.

Number    Question    Value

INC11001 Name          XYZ

INC11001 Phone          123

INC11002 Name           ABC

INC11002 Phone          123

However i want all var answers in a single row for a given incident. Any experience share is appreciated.

[rammohanraomadd]

Hi,

I hope you are creating an incident via record producer and in the question answer table for each variable there will be a record created. Hence that is the reason you got the count of number of variables filled while submitting the record producer for an incident.

You can report directly on the Incident table and there is an option called Questions where you can get the variables related to the record producer from there.

Regards,

Ram M

[niitnishant]

where is the questions section located i don't see it in first sight.

[rammohanraomadd]

Hi,

Please find the below screenshot:

Make sure you selected the show related fields option before clicking on the Questions field in available list.

Regards,

Ram M

[niitnishant]

Hello,

This didn't bring variables on report.. see the incident i created from my record producer