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.
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)
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.
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