Hey everyone!

With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:

Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.

We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.

In the meantime, if you need help, feel free to:

https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos

https://www.youtube.com/@wpDataTables/videos

Thank you for being so understanding, and we hope you enjoy the long weekend! 

Okay
  Public Ticket #1841946
Filter problem on big table
Closed

Comments

  • PrzemyslawGumulka started the conversation
    January 4, 2019 at 5:31pm

    Table has ca 15000 records. Server side processing is ON. SQL SELECT based on a view. I would like to use filter on column "Rok" (year). Table has only 3 values: 2016, 2017 and 2018. All of them are in the first 3 rows of the table (so there shouldn't be a problem to read data from the 1st batch). I want to have a predefined value = 2018. But I can't do it. When I choose "multiselectbox" and try to choose value in "predefined value" the list is empty. Sometimes even an empty row appears with a "checked" marker (!). I can't manually write for example "2018". You can use my credentials given in another ticket to check the case.

  •  472
    Isidora replied
    January 9, 2019 at 1:17pm

    Hi PrzemyslawGumulka,
    Thank you for your purchase.

    Sorry for late response. 

    We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days and also we had Orthodox Christmas which is our national holiday.

    We check your website, and we notice that you have semicolon on end of the query, so we remove it. Please avoid using semicolon on end of the query in our SQL box. Then we check your column Rok, and we see that wpdatatables recognize this column type as integer, so we change it to string and set Filter type on Multiselect in Filtering tab in column settings and then set Predefined value on value 2018 without any issues. You can check on your website that table is filtered properly. (attachment)

    Best regards.

    Kind Regards, 

    Isidora Markovic

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

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

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

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables