Topic: filter in TableGrid
Hi,
Is there a way to add filter (like in excel) to a table grid? sO the user can filter the table in runtime.
Thanks
My Visual Database → General → filter in TableGrid
Hi,
Is there a way to add filter (like in excel) to a table grid? sO the user can filter the table in runtime.
Thanks
Hello.
It's not support of this kind filter.
Hi,
Is there any way I can do this kind of filter?
Itzik
To filter, you can use button with action "Search"
Here is an example
it filters by all three columns
the secret is the sql query in the autorefresh button
{name_q} is reference to the field on the form
the %{name_q}% around the field make it so the LIKE matches whatever is contained in the string which is the contents of name_q
items.name LIKE '%{name_q}%'
and then the "Increm. search" option for each of the fields on the forms is pointing at the autorefresh button to rerun the query for each keystroke
Hello Itzik, Timlitw,
I have only just seen your post so maybe you have a solution already.
I have a user who also wanted the tablegrid to have a filter function like EXCEL.
What I came up with is the nearest that I could get it. It's not 100% what the user wanted but it's okay.
Maybe this approach can give you some ideas (please see attached).
Regards,
Derek.
My Visual Database → General → filter in TableGrid
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi