As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2897995
can I build more than one filter for the same column?
Closed

Comments

  •  1
    Carmelo Caruso started the conversation

    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

  • [deleted] replied

    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.

    8052151734.png

    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.

  •  1
    Carmelo Caruso replied

    Hi Blaženka, these are very useful informations!  Thanks for your help. I'll work on it and try some.

    Best,

    Carmelo

  • [deleted] replied

    You are most welcomesmile.png

    If there is anything else we can assist you with please don't hesitate to open a new ticket.

    Have a wonderful day!