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

Vidya Aeil
Tera Contributor

Hi All I am trying to establish a database view on incident and question answer table  that connects the incident table with the template questions table.

  • Tables=Question Answers and Incident
  • Connect Template Answer to Incident

 

However i want all where clause answers in a single row for a given incident and question answer. Any experience share is appreciated.

 

1 ACCEPTED SOLUTION

Anurag Tripathi
Mega Patron
Mega Patron

Hi Vidya,

 

Try this

AnuragTripathi_0-1715682867738.png

 

-Anurag

View solution in original post

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Vidya Aeil 

 

I dont have answer, but need info, like how incident and the question/ answer table connecting with each other? Any screen shot?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Vidya Aeil
Tera Contributor

VidyaAeil_0-1715682668793.png

please check tables.

What is missing here? 

What table is template question?

-Anurag

Anurag Tripathi
Mega Patron
Mega Patron

Hi Vidya,

 

Try this

AnuragTripathi_0-1715682867738.png

 

-Anurag