dynamic filter

gauri06
Tera Contributor

I want to create a dynamic filter that should filter to only show groups that the current logged in user is the manager of.

1 ACCEPTED SOLUTION

Mimi Edet
Tera Guru

Hi @gauri06,

Just to add to @Nishant8—if the resource_plan table has a reference to the group, you can filter it by:

  • Open the resource_plan list view.
  • Click the filter icon to open the filter criteria.
  • Add a new filter condition:
  • Select Show Related Fields from the dropdown.
  • Choose Group → Group Fields, then select Manager (this will now appear as Group.Manager).
  • Use the "is dynamic" operator in the filter condition, which will auto-populate "Me" as the value. 

This will filter the list to show only records where the logged-in user is the manager of the assigned group.

 

Regards,

Mimi Edet

LinkedIn: https://www.linkedin.com/in/edet-promise/

=========================================================
If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

View solution in original post

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

@gauri06 

where is this required?

Please share exact screenshot and business requirement

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Nishant8
Giga Sage

Hello @gauri06, If you want to filter in the Incident or Group list, then you can refer to below screenshots. But, if you'd like to construct in GlideRecord then you can try addEncodedQuery 

Nishant8_0-1740733233678.png

Nishant8_1-1740733265911.png

 

 

gauri06
Tera Contributor

want to create it for resource_plan table where it should only show the record whose current logged in user is the manager of those group

Hello @gauri06, I dont have Resource Mgt app, but, I believe, the concept remains same. you can click the drop down and select Group=>Group Fields (follow SS below- instead of Assigned Group, there should be something Group); now select 'Manager' and then select 'is dynamic' from the bottom of the list and it should work

Nishant8_0-1740734013776.png