I know that I can retrieve the values that are in a column and build a filter based on the those (values).
Would it be possible to build more than one filter for a single column?
The cells value are like this:
"category1::value1"
"category1::value2"
"category2::value3"
"category2::value6"
Categories are just a few (5, 10, 20) meanwhile values are a lot for a filter (50, 100, 200). Under this conditions having waterfall filters (first category, then values) would optimise table filtering operations. Would it be possible to have more filters on the same column?
Otherwise, would it be possible to realise it with "Powerful Filters AddOn"?
>> workaround?!
I can split category and value in two columns. I would than impose a filter in each column but keep the category column invisible. Would it work. Columns that are not shown in the frontend interface can expose a filter?
Update (21/10/21): yes, I tested it and it is possible to have non-shown columns with active filters.So, a possible workaround is to duplicate columns (overload!!!) and apply two different filters.
Or you can add a filter through the shortcode if you assign one of our placeholders to column settings/filters/predefined filtering value.
If you add %VAR1% as a predefined filtering value to ColumnA, for example, it will load all the data (because the placeholder is not defined in the Placeholders tab above the table). Then, when you add the shortcode like:
[wpdatatable id=1 var1=150] it will filter the table per columnA with the value of "150". We have 3 VAR placeholders you can use for this purpose.
I hope this helps, do let us know if you need any further assistance.
Dear Sir or Madam,
I know that I can retrieve the values that are in a column and build a filter based on the those (values).
Would it be possible to build more than one filter for a single column?
The cells value are like this:
"category1::value1"
"category1::value2"
"category2::value3"
"category2::value6"
Categories are just a few (5, 10, 20) meanwhile values are a lot for a filter (50, 100, 200). Under this conditions having waterfall filters (first category, then values) would optimise table filtering operations. Would it be possible to have more filters on the same column?
Otherwise, would it be possible to realise it with "Powerful Filters AddOn"?
>> workaround?!
I can split category and value in two columns. I would than impose a filter in each column but keep the category column invisible. Would it work. Columns that are not shown in the frontend interface can expose a filter?
Update (21/10/21): yes, I tested it and it is possible to have non-shown columns with active filters. So, a possible workaround is to duplicate columns (overload!!!) and apply two different filters.
:)
Kind regards,
CC
Hi Carmelo
Thank you for reaching out to us.
You can filter the table through URL
https://wpdatatables.com/documentation/table-features/global-search-via-url/
Or you can add a filter through the shortcode if you assign one of our placeholders to column settings/filters/predefined filtering value.
If you add %VAR1% as a predefined filtering value to ColumnA, for example, it will load all the data (because the placeholder is not defined in the Placeholders tab above the table). Then, when you add the shortcode like:
[wpdatatable id=1 var1=150] it will filter the table per columnA with the value of "150". We have 3 VAR placeholders you can use for this purpose.
I hope this helps, do let us know if you need any further assistance.
Hi Blaženka, these are very useful informations! Thanks for your help. I'll work on it and try some.
Best,
Carmelo
You are most welcome
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!