Hello, i builded my wpDataTable query using the %CURRENT_USER_ID% to extract the Wordpress User Id. Is it possible to concatenate to wildcards to extend the search?
Ex: my current id user is 01 and i would extract all user starting for 01 (01123456).
SELECT * FROM table_name WHERE table_name.user_id LIKE '%CURRENT_USER_ID%%'
So id your placeholder %CURRENT_USER_ID% is 01 it will be replace in query (...LIKE '01%') and will be filter and show table results from user_id column that starts with 01.
Hello, i builded my wpDataTable query using the %CURRENT_USER_ID% to extract the Wordpress User Id. Is it possible to concatenate to wildcards to extend the search?
Ex: my current id user is 01 and i would extract all user starting for 01 (01123456).
Thanks for your support
Hi andreanw,
Thank you for your purchase.
You can use query like this:
So id your placeholder %CURRENT_USER_ID% is 01 it will be replace in query (...LIKE '01%') and will be filter and show table results from user_id column that starts with 01.
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