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 #1881734
Error Checkbox Filter
Closed

Comments

  • AAARob started the conversation

    I have a problem with Checkbox Filter.

    I would like to use the checkbox Filter, but the checkbox filter is always empty. See Image: 1

    Several data are contained in the column. see Image 2

    Settings are on the image: 3 & 4


  •   AAARob replied privately
  •  2,576
    Aleksandar replied

    Hello AAARob.

    I think I got it, so please take a look.

    There was no bigger issue, only a small thing we're aware about because we're working with the plugin on daily basis; so no custom code added, nothing had to be changed anywhere, etc.

    It looks like you have mod_security enabled, or you have a security plugin installed which doesn't allow the asterisk ( * ) to be inserted in the query, and that's why it wasn't populating the checkbox filter.

    So I just modified your query from this:

    SELECT * FROM tommydatabase2;
    

    To this:

    SELECT 
    * FROM tommydatabase2
    

    And everything worked fine. If it's in another row, the security seems to ignore it.

    Since your support expired today, let me just say a couple more things about the query, for future reference:

    • You don't need the semicolon ( ; ) at the end of the Query.
    • From version 2.3 we implemented a feature that you can use multiple separate DB connections for (MySQL, MSSQL and PostgreSQL) and for MySQL engine we are dynamically adding the accent grave ( ` ). So, when you're generating a query avoid these as well.

    Please let me know if this works.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    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