Trigger filter on DataGrid

Forum to discuss the new web client version of Servoy.

Trigger filter on DataGrid

Postby rph » Wed Jun 22, 2022 9:51 am

Hi there

How can we trigger, when a filter is set on a DataGrid-Table?

Background: we have a parent-child-scenario. For example orders => orderdetails. Both are schown in separated datagrids on the same form. When a user selects an order in the orders-datagrid the according orderdtails are shown in the orderdetails datagrid (works over a relation). Now the user wants to filter orders depending on a filter criteria upon the orderdetails form. So the user sets a filter on the datagrid of the orderdetail-form and now I want to react on that and add an additional filter on the parent form (something like this: ...where order_id in (select order_id from order_details where ...). Maybe there is a better way to achieve this. But at least I'm not aware of it.

Thanks in advance for any suggestions.
Best, Roland
rph
 
Posts: 75
Joined: Wed Aug 10, 2011 11:44 am
Location: Cham, Switzerland

Return to Servoy NGClient

Who is online

Users browsing this forum: No registered users and 6 guests