How to created report using the related list condition

Sangeetha8
Tera Contributor

‎10-17-2023 10:32 PM

Hi All,

 

I have created a report on change task table. I want to filter the record to get the change request present in the change task related list "Impacted Services/CIs support group is xyzz as filter condition

Sangeetha8_0-1697606951896.png

How can we achieve this in reporting

0 Helpfuls
  • 197 Views
2 REPLIES 2

Voona Rohila
Kilo Patron
Kilo Patron

‎10-17-2023 10:42 PM

Hi @Sangeetha8 

You can add related list filters in report too.

VoonaRohila_0-1697607685670.png

You can try and let us know if you have any issue.

 

 


Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP
0 Helpfuls

AndersBGS
Tera Patron
Tera Patron

‎10-18-2023 02:41 AM

Hi @Sangeetha8 ,

 

Why not just use the task_ci table as baseline with the condition:

 

AndersBGS_2-1697622062532.png

 

That will give you the configuration items, change tasks and change request as shown below:

 

AndersBGS_1-1697622023108.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

0 Helpfuls