Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Show results based on two related lists

ErikJ1
Tera Contributor

‎05-15-2024 03:18 AM

Hi all!

 

I need to create a report on sc_cat_item where both of the related lists "Available for" and "Not available for" are empty.

I can't do it with the reportdesigner since it only supports one related list.

 

What is the best practice for this?

 

Is it possible to combine all the data with a databaseview and report on that?

Is it possible to make a dynamic filter to show the results?

Are there other options to achieve the same goal?

 

//Erik

0 Helpfuls
  • 264 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎05-15-2024 03:24 AM

Hi @ErikJ1 

 

You can create DB view with sc_cat_item and available for and not available for table. 

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