Restrict filters and breadcrumbs with fixed queries

[Juan Pablo Vas1]

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.

[Mike Patel]

Try what Paul suggested. It's not user sys_id it's filter sysid so anyone clicking on that module link will get logged in user's sys_id. That should work fine.

&sysparm_fixed_query=case_managerDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORassigned_teamDYNAMIC90d1921e5f510100a9ad2572f2b477fe

 FYI: If I log into my dev instance my dynamic filter also look like 

DYNAMIC90d1921e5f510100a9ad2572f2b477fe

[Juan Pablo Vas1]

Thanks, I'll give that a try, and comeback 🙂

[The SN Nerd]

there is a dynamic list filter for 'dynamic (is me)' on user reference fields.

I thought you were already using that?

[Juan Pablo Vas1]

Ok, work perfectly. what I did not understand from the start is that the query included the Sys_ID of the filter, and not the one from the user... now I understand that the query was ready to be used.

Thank you!