Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Display only records with an empty related list

Go to solution
miyu
Tera Guru

‎12-14-2022 04:36 PM

I want to display only records with an empty related list on the list screen.
I do not want to display records for which a record has been set in the related list.
How can I do this?

0 Helpfuls
  • 2,474 Views
1 ACCEPTED SOLUTION

Go to solution
reshmapatil
Tera Guru
In response to reshmapatil

‎12-14-2022 09:32 PM

Hi @miyu ,

 

Check below screenshots how to build and use scripted filter:

reshmapatil_0-1671082301874.pngreshmapatil_1-1671082332528.png

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**

View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
jaheerhattiwale
Mega Sage

‎12-14-2022 10:12 PM

@miyu You can create a READ ACL where you you need to write a script and you have to query the related list table and check if the records are present. If records present then allow access (answer = true) else don't allow access (answer=false)

 

Please mark as correct answer if this solves your issue.

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023
0 Helpfuls