Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Combine multiple tables

Community Alums
Not applicable

‎04-29-2024 02:59 AM

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

 

  • 637 Views
3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

‎04-29-2024 03:05 AM

Hi @Community Alums 

 

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]

****************************************************************************************************************
0 Helpfuls

Community Alums
Not applicable
In response to Dr Atul G- LNG

‎04-29-2024 03:08 AM

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

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

‎04-29-2024 03:11 AM

Hi @Community Alums 

 

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

 

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

****************************************************************************************************************
0 Helpfuls