Restrict filters and breadcrumbs with fixed queries

Juan Pablo Vas1
Tera Contributor

Hi Community,

I need to add an argument to a Module link type, so I can restrict my user to a specific set of records and he can't see all records by clicking all.

However, the filter is set using is (dynamic) Me

like this: Manager IS (dynamic) Me OR Assigned_team CONTAINS is (dynamic) Me

Query looks like this

case_managerDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassigned_teamDYNAMIC90d1921e5f510100a9ad2572f2b477fe

I need a &sysparm_fixed_query= that matches this dynamic query but I'm not sure how.

Could somebody help me with this one?

Regards.

JP.

1 ACCEPTED SOLUTION

Is the following in the 'arguments' field on the module not working?

&sysparm_fixed_query=case_managerDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassigned_teamDYNAMIC90d1921e5f510100a9ad2572f2b477fe

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

View solution in original post

8 REPLIES 8

The SN Nerd
Giga Sage
Giga Sage

See documentation below for help with fixed query

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/list-administration/task/t_RestrictBreadcrmbsWFixedQueries.html

Regardless of a fixed query, the user can still report on or view these tickets outside of the menu option.

Would a before query business rule suit this requirement more?


ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

I thought about a before query business rule too, but my users can only see one module of the entire application (the my cases module), therefore I thought a fixed query could do.

Thank you!

Is the following in the 'arguments' field on the module not working?

&sysparm_fixed_query=case_managerDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassigned_teamDYNAMIC90d1921e5f510100a9ad2572f2b477fe

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

That query includes the Sys_id of the users, is there a way to tell the argument to adjust the sys_id to the current user? something like current.sys_id?