mix up two tables

mregragui_ext · ‎10-02-2023

hello community, i want to create a table that display the result of task table and asmt_metric_result.

Thanks!

Peter Bodelier · ‎10-02-2023

Hi @mregragui_ext,

That is hard to say without knowing the rest of your setup.

It should be self explanatory when you follow this though.

Add a table to the database view (servicenow.com)

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

Dr Atul G- LNG · ‎10-02-2023

Hi @mregragui_ext

The best way is use database view. and in normal words Database is like a table but it is combination of 2 or more tables.

https://InstanceName.service-now.com/now/nav/ui/classic/params/target/sys_db_view.do%3Fsys_id%3D6529...

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

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

mregragui_ext · ‎10-02-2023

@Dr Atul G- LNG can you tell me what i need to do in the where clause to join them bases on task number

Dr Atul G- LNG · ‎10-02-2023

Hi @mregragui_ext

Where clause is the key where which join these 2 tables and bring the results. Here is the example of OOTB. Open this or check OOTB and you can do it. Its not tough.

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

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

Anand Kumar P · ‎10-02-2023

Hi @mregragui_ext ,

Create a Database View that combines the task table and the asmt_metric_result table to display and extract data from both tables. Once you've created the Database View, you can use it in reports, lists, and other modules in ServiceNow to access and work with the combined data seamlessly. This allows you to extract, analyze, and report on the data as needed.

Thanks,

Anand