We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3981755
Persistent Table Filters for SQL source table
Open

Comments

  • Frank started the conversation

    I have multiple tables created using your plugin. 

    I have looked all over and can't find a solution. I also tried chatgpt and none of the suggested solutions worked.

    My tables have filters, the filters work as intended. The issue is that if I navigate to a different page, to edit and entry for example, when I return to the page with the table the filters are reset. I know that I can set default filters but that is not what I am asking about.

    I need to be able to set the filters and they persist after page reload until they are cleared or user logs out.

    Please assist. I hope this is a simple fix.

    Your help is much appreciated as this lack of persistent filter is making the usability of the table pages suffer.

    Frank

  •  1,895
    Miloš replied

    Hi Frank,

    To begin, I want to extend my heartfelt apologies for the delayed reply, 

    which is due to our Holiday break here in Serbia.
    We truly value your patience during this period.

     

    In regard to your use case :

    Sorry to disappoint you, but at this time, we don't have any built-in solution to achieve the scenario you described, such as to keep the filters active when redirecting/returning to a page/or refreshing the Page.
    Any action such as that is going to clear all the filters and return the table to its default state.

     

    You can suggest it to our developers, though - they will do their best to make 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.

    -

    If you have coding skills and wish to try to make a custom solution now,

    you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

    We also added this new developer's handbook, which can allow users with coding skills to make custom add-ons.

    Our developers will keep adding more custom hooks/examples there over time.

    -

    Please be advised that custom solutions with hooks are not included in our support.

    You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

    ( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)

    The closest example I found is this one, basically, there is a custom way to 'save selected filters as a table view'.

    This bit of custom js will update the browser url (without triggering a reload) to reflect which values have been entered in filters, thereby generating a direct link to the current 'view'. Note this only works for separate filter forms, but should only need a couple of tweaks to do a version for the simple in-table filter boxes ...

    jQuery(window).load(function(){
      wpDataTables.table_1.addOnDrawCallback(function(){
        var params={};
        jQuery('.wpDataTableFilterSection').each(function(i, obj) {
          if ( inputbox = obj.id.match("table_1_(.+)_filter_sections") ) {
            if (jQuery(obj).find('input').val()) {
              var key='wdt_column_filter['+inputbox[1]+']';
              params[key] = jQuery(obj).find('input').val();
            }
          }
        }); 
        history.pushState('','','?'+jQuery.param(params));
      });
    });

    I hope it helps.

    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