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,

Click on + icon between Available and selected to get the details.

Regards,

Ram M

[niitnishant]

Please be informed. That reference doesn’t bring question answers. That is referenced to question/variable table.

[Ashutosh Munot1]

HI,

This is not possible. Because in question_answer table we create record for each question.

For example: IF i have 10 question then we will have 10 entries.

Thanks,
Ashutosh Munot

[Venkat122]

How did you resolve this issue?