Filter multiple columns in a table in perspective

Ignition
,
1

Dears,
I want to filter multiple columns in my table using the built-in filter textbox.Now I just can filter in a one column only .
Any suggestions ?

Regards,

2

From 8.1.22 the Perspective Table component features individual column filters.

  • Make sure that columns.x.field (where 'x' is the column number) is filled in.
  • columns.x.filter.enabled : true
  • columns.x.filter.visible : always | on-hover | never
3

So It is not available to make multiple filters on different columns on the same time !!

4

You can run one filter on each column simultaneously.

For example, with the default Perspective Table you can filter on both "city contains 'San'" and "country contains 'United'".

5

I’m not sure what exactly is your use case, but you should be able to apply filters on multiple columns.
If you can’t find a built in way to do what you want:
Bind the data to a custom prop instead.
Then bind data to that custom prop.
Add a transform and apply whatever custom filter you want.

6

My ignition is 8.1.13 ,so filter could be done on only one column in my case? .
I face challenges to update to latest ignition version now.

7

thanks for your feedback but I am asking about the built in function in table component

8

Yes, but if you can't find a way to make them work the way you want, there's the solution of custom filters.

Edit: Especially in 8.1.13, where there's no column-specific filters.
I'm working mostly in 8.1.17 lately, and I had to make my own filters because the built-in one didn't fit my needs.

1 Like