As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

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