While configuring a specific list in a legacy/custom Workspace, you might want to use a fixed_query instead of a condition query. The expected behavior is that the list should filter records based on the fixed query defined in the sys_ux_list table.
However, you may encounter an issue where the filter is not applied, and the list displays all records, as if no query exists.
Root Cause
Populating the fixed_query field directly in the sys_ux_list table does not automatically bind the query to the list component in the Workspace. The component requires a dynamic value binding for the fixed query to take effect.
Solution
To resolve this issue:
1. Open the Workspace in UI Builder where the list is configured.
2. Select the List component you want to fix.
3. Navigate to the Data tab.
4. Locate the fixed_query field.
5. Click to add a dynamic value instead of leaving it static.
6. Use the following dynamic path:
@data.list_navigation._information.listMenuData.fixedQuery
7. Save and publish your changes.
Why This Works
Dynamic binding ensures that the list component retrieves the correct query from the navigation context and applies the filter as intended.
