Okay
  Public Ticket #3101588
filtering multiple tables
Closed

Comments

  • Renze started the conversation

    Hi,

    I'm struggling with filtering. Let me try and explain what I want to achieve:

    I'm developing a website for golfscores. There are 200+ players in the database and over 6000 score records. Now I want a summary page for the individual player with several tables. All tables have at least the columns playercode and course. I start with a general page where all players are listed with a link to the summary page.

    What I want is that when the link is clicked all the tables on the summary page are filtered by the playercode. And on the summary page itself I want the possibility to filter all tables on course. Can this be done?

    Btw. I also purchased the advanced filter plugin.

    Best regards,

    Renze

  •  1,851
    Miloš replied

    Hi , Renze 

    Sorry for the delay

    1.

    Regarding being able to filter multiple pages on the fly, while all tables are on the same page - I am sorry to disappoint you, but that is currently not possible.

    For example, if all the tables are already loaded on the same page - then you try to use a filter directly on one table, it is not possible for it to affect other tables > it will just filter that table.

    -

    But we can make a suggestion for our developers, to create a solution in the future.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    2.

    But regarding creating a prefiltered URL ( for every player), that can lead to a prefiltered page when clicked, 

    where all tables are filtered by the player code, this is an interesting question.

    I am not 100% sure, to be honest - i never personally tried this, but i have a couple of ideas.

    For example, I'm thinking if we use something like our URL prefiltering feature here ,  or some dynamic placeholders;

    and to set shortcodes with VAR placeholders on the page, for all the table's shortodes to filter by player code value...  But not sure.

    -

    I will get help from our 2nd level Team, and we will report back to confirm if something like this is possible at this time.

    We will do our best to be as quick as possible.

    Thank you for your patience.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Renze replied

    Hi Miloš,

    I've been trying to get the pre-filtering through url to work but my table is to big so it has to use server-side processing and I guess that filtering through url only works without server side processing. Am I right?

  •  1,851
    Miloš replied


    Hi, Renze

    Sorry for my delay

    - I did some testing , and on our Demo and my local site - everything works, server-side or none server-side tables have the ability to use URL pre-filtering.

    For example, i have a Manual table,  for Manual tables we can't even disable server-side;

    9255378016.png

    Let's say if i filter this Company field;

    and i use some value from another page ,  page number 2 ;

    3464327078.png

    I just add this to the page URL -   ' ?wdt_column_filter[1]=A Malesuada Ltd  '

    1711848637.png


    And i got the result :

    6565260885.png

    -

    I check your example related page - and i can't see any filters for this table?

    I tried to do a prefilter URL on it - but i am not sure what is the number of the columns, for indexing, perhaps you have hidden a column....

    Can i inspect the back-end for one of your tables - and i can test if you have any issue for prefilter URL on your site?

    Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.

    And point me to any table ID that i can test?

    Thank you


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Renze replied

    Hi Miloš,

    Thanks for your reply. I was browsing the tickets and found that I had to remove the `` around the table from my query. That solved it.

  •   Miloš replied privately