Application for showing Empty Groups

EthanJacocks
Tera Contributor

‎03-26-2024 09:58 AM

Hi all, I am trying to create an application module that can show the customer a list of empty groups. Right now it is set up so that the module is on the sys_user_group table and that is working properly, but I am struggling to have it only show the empty ones. Current strategy is to use a before query business rule on the view that I set through the module (so that it only triggers when using this module) but I'm not sure how to only query for empty groups. I know I need to utilize the sys_user_grmember table in some way but past that I'm lost. Thank you for any input!

0 Helpfuls
  • 236 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-26-2024 10:03 AM

Hi @EthanJacocks 

 

did you try the link type

 

AGLearnNGrow_0-1711472592209.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