Reports based on region

Chirag Pathak
Tera Contributor

‎02-26-2024 02:01 AM - edited ‎02-26-2024 02:03 AM

Hi community,

I have a requirement that based on the users region the work orders in that locations of that region reports on work order task , task SLA and work order should be shown ie. when they open the FSM live dashboard in that widget it should show only the relevant locations to the user based on the region . So, how can I achieve it?

0 Helpfuls
  • 775 Views
5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Chirag Pathak

‎02-26-2024 08:08 AM

Hi @Chirag Pathak 

 

I think I understood more now.

 

Create a DB view of all 3 tables

Create an interactive filter (Location table) and add that on dashboard  

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