Combine multiple tables

Andrew_TND
Mega Sage
Mega Sage

Hello all, 

There may be a another way to do this so I may be making it more complicated than it needs to be.

I have a requirement where I need a single view of the below tables which can be used in a reference field and within related list.

  • Incident
  • Change
  • Problem
  • Risk
  • Issue
  • Project Task

 

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Andrew_TND 

 

Is these all tables extended from Task ,then youse task table as reference. What is your use case to combine all these.

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

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

I didnt note it but I do need to add 2 additional custom tables which are not part of the TASK table lets just call them u_one and u_two

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Andrew_TND 

 

https://www.servicenow.com/community/developer-forum/how-to-reference-field-with-multiple-tables/m-p...

 

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

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