Datagrid 2 filter default value shows “1 item selected (but not applied)” and does not auto-filter

0
I have a Datagrid 2 on a page with multiple columns. One of these columns contains the name of the order creator name and uses a dropdown filter based on OrderCreator. My goal is to set the default value of this filter to the name of the currently logged-in OrderCreator, so that the grid initially only shows records for that user. What happens instead:The filter shows the message:“1 item selected (but not applied)”. The Datagrid is not filtered.   Things I have checked: The value of the variable exactly matches the value used in the filter The correct ordercreator object is being retrieved (same entity / same object type) The dropdown visually shows the correct user If I change the default value from variable to text, I get the same behavior and message. “1 item selected (but not applied)”   Even though the default value is visible and correct, the filter is not automatically “applied” on page load. Is this a known limitation of Datagrid 2?Is there a recommended way to explicitly trigger the filter (e.g. via microflow/nanoflow), or am I missing a configuration option? Any tips or best practices are welcome!    
asked
2 answers
1

To apply the filter when the page loads, set the default value in the filter properties to the GUID (converted to a string) of the desired object.

In this case, save the GUID (converted to a string) of the desired OrderCreator, pass it to the datagrid2 via a page parameter or a data view, and set the default value accordingly.

answered
0

I had a similar issue recently and what helped me was the Set_Filter javascript action that comes with the DataWidgets module. There you can just enter the name of the filter and add the value that should be set. in this case just let the datagrid retrieve all the objects and then set the dropdown filter to the desired value (guid of the user as a string)

answered