Tabulator Custom Filters

[3fingers]

For a project I'm close to start I'm evaluating the use of Tabulator or DataTables to make a custom filtered table like the one you can see here.
The example shows four custom dropdown that act upon custom data, filtering it via data-attributes stored on the table rows in this case.
Both plugins don't offer natively this kind of functionality.

@bernhard I know you have played a lot with Tabulator, releasing also a module based on it, but as far as I can tell you didn't implemented anything like that, but maybe you (or someone else, of course) could give me some pointers ?
 

Thanks, as usual.

[bernhard]

100% recommendation for tabulator! I'm using it all over now in several projects and I'm finally very happy. Having tried datatables, aggrid and tabulator I can say that I've tried a lot of them and tabulator is IMHO the best overall - and it's MIT ? 

The custom filter you are talking about should be easy. If you need help just give me a shout ? 

[psy]

Thanks to @bernhard introducing me to Tabulator, I've used it in several projects too - both admin and frontend side. It's powerful & fast. Once you get your PW PageArray converted to json, it's just a matter of defining your columns, filters & CSS

[3fingers]

From @bernhard suggestion:

Quote

You can filter everything that is data of your table (either a cell value of a visible column, or a hidden one, or via custom function you can even filter based on combinations). Another key is to understand that such tables have VALUES (that are used for filters, sorting, etc) and a FORMATTED value that is used for presentation of data. That means each cell can have ONE value, but can have multiple representations for different use cases (display, print, download, ...)

One key thing I missed the first time I read Tabulator docs:

Quote

The data can contain more columns that are defined in the columns options, these will be stored with the rest of the data, but not rendered to screen.

So I can use that further data (unused for presentational purpose) to filter various columns because it is effectively present and coupled with every row.
Does it sound correct? ?

[bernhard]

yes, just set visible=false http://tabulator.info/docs/4.9/columns#visibility