Okay
  Public Ticket #1594448
non-functioning multi-select filters
Closed

Comments

  • irim_2015 started the conversation

    Since updating to wpDataTables 2.2 (and 2.2.1), Multiselctbox column filters are no longer working properly. On the web pages, they simply don't respond to user mouse clicks. They do seem to work on the back end.

    Checkbox filters and text filters work OK. The problem seems to be limited to multiselect box filtering.

    The "Show X" entries dropdown does not function on the web pages either. The user is no longer able to change this from the default values that is set on the back end.

  •  417
    Bogdan replied

    HI irim_2015,

    Can you please tel me is this is happening only when the Powerful filtering Add-on is turned on.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • irim_2015 replied

    I didn't know filtering was possible without the add-on, but yes, the add-on is on

  •   Bogdan replied privately
  • irim_2015 replied

    Yes please send the patched version.

    Is this your recommended approach, rather than backing out of wpDataTables 2.2.1 to an older version that is still compatible with Powerful Filters?

  •   Bogdan replied privately
  • irim_2015 replied

    There is not change in behavior after replacing Powerful Filters 1.0 with 1.0.1. The multiselect box still does not function, and neither does the "Show X" rows selector.

    Now I can't set up pre-defined filter values anymore either. The option remains "grey" and inactive no matter what other configuration options I choose.

    Should I regress to wpDataTables 2.1?

  •  417
    Bogdan replied

    HI irim_2015,

    Predefined values are disabled when the cascade filtering is on form this version.

    Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.

    I can send you any version that you like but may I first see this issue.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   irim_2015 replied privately
  •   Bogdan replied privately
  •   irim_2015 replied privately
  •   Bogdan replied privately
  • irim_2015 replied

    It still won't build a checklist or multiselect list. The lists are empty.

  •  417
    Bogdan replied

    Hi Irim

    Ok can you please then go in file wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php

    And after the last line of code add this line 

    add_action('wp_ajax_nopriv_wpdatatables_get_column_possible_values', 'wdtGetColumnPossibleValues');

    so it will look like this (attachment )

    Best regards.

    Attached files:  Screen Shot 2018-06-04 at 11.31.42 AM.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   irim_2015 replied privately
  •   irim_2015 replied privately
  •   irim_2015 replied privately
  •   irim_2015 replied privately
  • irim_2015 replied

    I think the closing semi-colon on the sql statement is the culprit. multiselect droplists are working properly too now that I have omitted the semi-colon

  •  417
    Bogdan replied

    HI irim_2015,

    Can you please tel me if everything is working fine now?

    You are right, it is not recommended to use " ; " sing in the query because PHPparser that are used to read the query can get confused.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • irim_2015 replied

    Yes. Everything is working fine now. It was closing my queries with ";" that was causing the issues. Perhaps you could add a tool tip to the interface warning users about this?

    Thanks for your help.

  •  417
    Bogdan replied

    HI irim_2015,

    Glad to hear that.

    I will note your suggestion and maybe we can make some kind of notification to avoid this issues.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards,
    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • irim_2015 replied

    Bogdan,

    It seems this isn't resolved entirely yet.

    While the select and multiselect filters and the Show XX entries options work properly in the back end (table preview), only the select filter operates on the web pages (front end). If I build a multiselect filter and select it on the front page, nothing happens. The same is true of the Show XX entries select list. These last two just simply do not function at all.

  •  194
    Milan replied

    Hi irim_2015,

    Bogdan is on vacation and I will help you.

    Sorry for late response. 

    We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

    Can you try to turn off option" Include full bootstrap front-end" in main settings of plugin?

  • irim_2015 replied

    Milan,

    That did it! Thanks so much for the help.

    Don

  • irim_2015 replied

    Milan,

    Maybe I spoke too soon.

    Now the checklist and multiselect forms are populated, but the pop up seems to completely disable the page. I can't select anything, reset the popup, or close it. I have to refresh the page to regain access to it. 

    However, the Show XX entries drop list is functioning now.

  •  194
    Milan replied

    HI Don,

    Can you please provide me a link of that page where you are using that table so I can take a look? I suppose that is some css conflict, but I have to look with Inspect element and investigate what cause the issue.

  • irim_2015 replied

    I cannot. The server is behind a firewall and requires vpn access.

    As an alternative, can you tell me how your development or test environment is configured? What themes do you commonly use?

    I have cloned my site to a development environment and disabled all plugins except wpDataTables and powerful filters and changed the theme to Twenty Seventeen. Now the filters work properly on the front end. 

    Next step is to restore theme and plugins one by one till I find the conflict.

    It seems to be an issue with the theme.

    I had been using WP Invictus theme, but I can't tell why there is a conflict.

    I would like to use a theme that has a full width template so I can fill the screen with my charts. Do you know of one that works with wpDataTables and powerful filters that does not conflict?

  •  194
    Milan replied

    Hi irim_2015,

    All right we understand, but it is hard to figure out what cause the issue if we don't have access to the website. 

    We are using a lot of themes(mostly used,premium or free) in our local environment, but the issues like conflicts with third party plugins or themes are always possible due to the nature of WP.

    Can you please send me that theme so I can test it in our local environment?

  • irim_2015 replied

    You should be able to download the them from wordpress.org. The name of the theme is "WP Invictus"

  •  194
    Milan replied

    Hi irim_2015,

    We download that theme form wordpress.org and we see the issue. There is some css conflict.

    Just add this code in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables.

    .wpdt-c .modal-backdrop{ 
    z-index: 0 !important;
     }

    Best regards

  • irim_2015 replied

    It works! Thanks a lot for all your help.

  •  194
    Milan replied

    Hi irim_2015,

    You are welcome.  Glad that we help you to solved the issue.

    If you have any more issues or questions feel free to open a new ticket, we will gladly help.

    We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!