We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Actually you can use %VAR1% in predefined filters, but you have to change "Filter type" to string. My suggestion is to look up video tutorial about placeholders in our documentation on this link.
For number range that is not possible like that, but you can achieve this throw mysql query. For example
SELECT * FROM table_name WHERE table_name.number > %VAR1% AND table_name.number < %VAR2%
I'd like to have a predefined filter but not limit the query to certain values, so your suggestion won't work. I'm talking about a table column with year values, so string filtering isn't really doing the job (you cannot select a range).
If you could implement this feature sometime in a future release, I'm sure your customers would be thankful.
Hi,
in column settings, I cannot predefine a filter using placeholders like %VAR1% if I select "number" or "number range" as filter type.
It'd be good to allow this so we can set predefined filters using shortcode.
Thank you
Johannes
Hi Johannes,
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.
Actually you can use %VAR1% in predefined filters, but you have to change "Filter type" to string. My suggestion is to look up video tutorial about placeholders in our documentation on this link.
For number range that is not possible like that, but you can achieve this throw mysql query. For example
SELECT * FROM table_name
WHERE table_name.number > %VAR1%
AND table_name.number < %VAR2%
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
Hi Milan,
thanks for the help.
I'd like to have a predefined filter but not limit the query to certain values, so your suggestion won't work. I'm talking about a table column with year values, so string filtering isn't really doing the job (you cannot select a range).
If you could implement this feature sometime in a future release, I'm sure your customers would be thankful.
Kind regards
Hi Johannes,
Yes, for now it is possible only throw sql query.
Thank you for your suggestion. I will forward this to my team to think about this like new feature in future.
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