Show results based on two related lists

ErikJ1
Tera Contributor

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

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

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