Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to view all incident Request RITM SC TASK and Interaction data in one table

Ashish Kathait
Tera Contributor

an hour ago

All tables are part of Task so that is one, but Interaction table is different and do not inherit Task. So how we can create one table or report.

0 Helpfuls
  • 60 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

an hour ago

Technically, you can build a database view of the Task and Interaction tables, but make sure there is something common between them to join the data. If there is nothing common, it will not work.

However, I would not suggest creating a database view because the Task table is huge, and building a database view on it may impact performance. It’s better to keep them as two separate reports.

Alternatively, in the report, you can use the Data Set feature, where you can build a report on multiple tables and display the results in one place.

*************************************************************************************************************
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]

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