I've seen that wildcards can be used with Placeholders based on previous tickets, however they do not work. Please advise. I am getting an error 'cannot calculate position of '%' within' for Placeholder format '%%CURRENT_USER_LOGIN%%'. It works when I replace Placeholder with required string....
Can you please explain in a bit more detail what you're trying to accomplish?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Apologies, I put the wrong Variable name in the last post. I want to use CURRENT_USER_LOGIN, which as I understand is an existing variable, and therefore would not require any custom coding?
Yes if username returns email of current user, then it will be replaced with CURRENT_USER_LOGIN placeholders in the query and you will get data that you need(it that email exist in your database)
Oh please read the query!!! WILDCARDS ARE NOT WORKING AND I NEED THEM TO SEARCH ANY POSITION OF TEXT.... Look I am at wits end with this. Perhaps just refund me and I will find an alternative plugin.
I've seen that wildcards can be used with Placeholders based on previous tickets, however they do not work. Please advise. I am getting an error 'cannot calculate position of '%' within' for Placeholder format '%%CURRENT_USER_LOGIN%%'. It works when I replace Placeholder with required string....
Please advise as i need this to work ASAP
Hello Trent
Thank you for your purchase.
Can you please explain in a bit more detail what you're trying to accomplish?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Aleksandar,
I am trying to achieve a simple SQL statement. SELECT * WHERE column LIKE CURRENT_USER_LOGIN
I need to wildcard CURRENT_USER_LOGIN to find the text within the column in any position.
I have a column that contains a list of email address, I am trying to show only entries that contain the current users email.
should be fairly straight forward as this is a very common SQL statement...
Apologies, I put the wrong Variable name in the last post. I want to use CURRENT_USER_LOGIN, which as I understand is an existing variable, and therefore would not require any custom coding?
Hello Trent,
Aleksandar is on vacation and I will help you out.
Yes you can use CURRENT_USER_LOGIN placeholder which will return current username not user email.
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
this is becoming painful! Yes it will return the username... AND THE USERNAME IS AN EMAIL!! Can wildcards work or not???
Hello Trent,
Sorry for inconvenience,
Yes if username returns email of current user, then it will be replaced with CURRENT_USER_LOGIN placeholders in the query and you will get data that you need(it that email exist in your database)
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
Oh please read the query!!! WILDCARDS ARE NOT WORKING AND I NEED THEM TO SEARCH ANY POSITION OF TEXT.... Look I am at wits end with this. Perhaps just refund me and I will find an alternative plugin.
Hi Trent,
All right.
In file wp-content/plugins/wpdatatables/source/class.wdttools.php around line 87 you will find this
$string = str_replace('%CURRENT_USER_LOGIN%', "'{$wdtCurUserLogin}'", $string);and you need to replace it with this:
$string = str_replace('%CURRENT_USER_LOGIN%', "{$wdtCurUserLogin}", $string);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
Phew! Thank you. Works perfectly.
Glad we got there in the end.
Thanks again.