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,572
    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