• Registered: 2016-11-10
  • Posts: 8

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

Post's attachments

Attachment icon ScreenHunter_001.jpg 5.21 kb, 302 downloads since 2017-01-25 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: filter in TableGrid

Hello.


It's not support of this kind filter.

Dmitry.
  • Registered: 2016-11-10
  • Posts: 8

Re: filter in TableGrid

Hi,
Is there any way I can do this kind of filter?

Itzik

  • Registered: 2014-02-14
  • Posts: 10,294

Re: filter in TableGrid

To filter, you can use button with action "Search"

Dmitry.
  • Registered: 2014-09-04
  • Posts: 98

Re: filter in TableGrid

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

Post's attachments

Attachment icon settings.zip 336.12 kb, 478 downloads since 2017-01-26 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,769

Re: filter in TableGrid

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.

Post's attachments

Attachment icon 992 all filters.zip 389.57 kb, 509 downloads since 2017-01-31