SELECT aaie_wpdatatable_1.`wdt_ID`, aaie_wpdatatable_1.`prnom`, aaie_wpdatatable_1.`nle` FROM aaie_wpdatatable_1
WHERE wdt_ID = %CURRENT_USER_ID%
But this does not work
SELECT aaie_wpdatatable_1.`wdt_ID`, aaie_wpdatatable_1.`prnom`, aaie_wpdatatable_1.`nle` FROM aaie_wpdatatable_1
WHERE prnom = %CURRENT_USER_FIRST_NAME%
SQL answher : Unknown column '(%CURRENT_USER_FIRST_NAME%)' in 'where clause' In fact, (%CURRENT_USER_FIRST_NAME%) is contained in several cells of the field 'prnom'
Could you first try this ; if you remove the WHERE statement from this SQL Query,
and then enter the column settings for the column prnom , and use a predefined filter, with the placeholder there :
But I am not sure if that will be perfect for you, and I am curious to see why the placeholder won't work from the SQL Query,
so if you wish, we can take a look at the back-end of the table, and we could check your database, to be sure to check all the relevant details.
Please provide me a temporary WP-admin (administrator) user for your site where this happens,
and access to the database ( either a login URL with credentials for PHPMyAdmin, or cPanel),
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 parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Hi !
My problem, using PlaceHolders :
This works
SELECT aaie_wpdatatable_1.`wdt_ID`,
aaie_wpdatatable_1.`prnom`,
aaie_wpdatatable_1.`nle`
FROM aaie_wpdatatable_1
WHERE wdt_ID = %CURRENT_USER_ID%
But this does not work
SELECT aaie_wpdatatable_1.`wdt_ID`,
aaie_wpdatatable_1.`prnom`,
aaie_wpdatatable_1.`nle`
FROM aaie_wpdatatable_1
WHERE prnom = %CURRENT_USER_FIRST_NAME%
SQL answher : Unknown column '(%CURRENT_USER_FIRST_NAME%)' in 'where clause'
In fact, (%CURRENT_USER_FIRST_NAME%) is contained in several cells of the field 'prnom'
prnom is varchar(255) whereas wt_ID is int(11)
best regards
Hi, Romain
Sorry for the delay
Could you first try this ; if you remove the WHERE statement from this SQL Query,
and then enter the column settings for the column prnom , and use a predefined filter, with the placeholder there :
But I am not sure if that will be perfect for you, and I am curious to see why the placeholder won't work from the SQL Query,
so if you wish, we can take a look at the back-end of the table, and we could check your database, to be sure to check all the relevant details.
Please provide me a temporary WP-admin (administrator) user for your site where this happens,
and access to the database ( either a login URL with credentials for PHPMyAdmin, or cPanel),
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 parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, Romain
Actually i did some additional testing , and I can replicate this on my local test site.
Here is my video of the test SQL Query - I guess it is the exact same behaviour on your end?
Maybe the slight difference for my case is that the Query actually renders the user's first name correctly,
I see it in the error message,
but still the same result - we don't get the generated table.
-
I have escalated this to be tested by our QA Team,
and I will report back with an update on it;
but if we could get temporary access to investigate your end, as well, that can help.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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, Romain
My apology, i should have spotted this little ( but important) detail right away.
I forgot that when using placeholder like this, in the Query, we have to add the Quotation mark around it.
So, just add the ' symbol around the placeholder, in the Query, and it should work :
WHERE prnom = '%CURRENT_USER_FIRST_NAME%'
-
Let me know how it goes. Thanks
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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 Miloš !
Great ! it was "only" that !
the Quotation mark !
I looked for it for hours without finding it.
Thanks a lot.
Maybe a quick note about this in the documentation might help others?