reports

tGhadage
Tera Contributor

‎07-08-2024 11:03 PM

Hi Guys,

I have received requirement on reports never worked on it actually 

can anyone please help.

 

 

Screenshot (272).png

Thanks!!!!

0 Helpfuls
  • 221 Views
7 REPLIES 7

Dr Atul G- LNG
Tera Patron
Tera Patron

‎07-09-2024 12:01 AM

Hi @tGhadage  

 

For this you need to create the Database view,  as task are on change task table and change on change request table.

 

You need to create DB view like

AGLearnNGrow_0-1720508434790.png

 

Instead of task sla , use change_request table. 

 

https://youtu.be/QdiTio73Mnc

 

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

****************************************************************************************************************
Batch 12 | Day 26 | Report - Dashboard and Database View #Shorts #Short
Batch 12 | Day 26 | Report - Dashboard and Database View #Shorts #Short
youtu.be/QdiTio73Mnc
csa #ServiceNow #TechnoFuncational Disclaimer: These videos are from my training batch. These videos did not promote any ServiceNow Sales pitch or marketing. These videos are only for knowledge purposes & basic on my experience & Knowledge. Redistribution or copying of functionality is not ...
0 Helpfuls

tGhadage
Tera Contributor
In response to Dr Atul G- LNG

‎07-09-2024 03:31 AM

have added the database view on the report regarding the condition what shall I use to get the data shown in above table format ..

I mean get the change task assigned for the particular change request.

 

Thanks!!!!

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to tGhadage

‎07-09-2024 03:36 AM

Hi @tGhadage  

 

You will not get in same format as you need, 

 

you will get like

AGLearnNGrow_0-1720521368275.png

 

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

tGhadage
Tera Contributor
In response to Dr Atul G- LNG

‎07-09-2024 03:37 AM

okay how shall I get the format you mentioned,

0 Helpfuls