Dynamic filters not working in custom application

[abhilashsg]

dynamic filters "is Me" not returning records. where as when entered the user name it does return the matching records and this is happening in custom app that we built.

This was always working fine but post yokohoma release issue is seen

[NotNowBoss · Accepted solution]

Hi,

Found the solution
MSI (May Maintenance 2025) created query_range ACL with HasQueryRangeRoleAndHasRightsToReadIsTrue Se...

Add the role query_range_role to the user and it will work.

[Kevin Clark1]

Adding query_range_role is really a bit of a workaround - it ends up allowing the user to pass the default conditional_table_query_range ACL that exists for the * table. 

Dynamic Filters require you to be able to pass a conditional_table_query_range ACL before executing - this can also be achieved by putting a table-specific conditional_table_query_range ACL on the table from which you are running your filter.  You can define whatever conditions for that ACL that you want and don't NEED to use the query_range_role that is used in the * version of that ACL.