I am using the Datagrid with Form to display Sales Leads. I am trying to include some filters that let me select Open Leads, Closed Leads and All Leads. Setting up the filters isn't the problem. I am also trying to implement Search while typing. When I set up the default page, it works fine. If I add buttons for the filters and have the invoke data source method with the same "get" that the datagrid uses but with different .Where(r => r.xxxx) it filters properly but when I try to use the search, it reverts back to the original "get" as the search invokes the load() method. I made a work around by duplicating the grid 3 times with different .Where(r => r.xxx) and making them visible or not visible based on button click. This works, but the form does not update until I actually click a row in the grid. The form uses lead.xxxx (lead being the set property for the result.FirstOrDefault(), which on row select accesses the ${event} which I cannot seem to modify.
Is there a way to filter a datagrid in a Datagrid with Form page and still be able to used search and update the form on filter?