I think there is a bug with the Placeholders function. When configuring a new table based on a mySQL query, I attempted to substitute a where clause parameter by adding %VAR1% e.g.
SELECT view_user_rank_by_category.`user_id`, view_user_rank_by_category.`cat_name_for_reporting`, view_user_rank_by_category.`category_name`, view_user_rank_by_category.`rank_cat`, view_user_rank_by_category.`user_iq_score`, view_user_rank_by_category.`comparison_iq_score`, view_user_rank_by_category.`report_dt` FROM view_user_rank_by_category where user_id = 371 and cat_name_for_reporting = '%VAR1%'
I placed a variable in the default value 'Intelligence Factor' (without quotes) and when I press 'Apply' the screen goes white at a date/time appears in the top left corner. When I refresh the page the screen returns to query without any placeholder configurations i.e. the last time I saved it.
I'd really like to use this feature. Is this an issue you are aware of? or am I doing something wrong?
If you are using String for Placeholder - ‘variable’ %VAR1% should be surrounded with Single Quote (‘) in the query.
Please try this, and let me know if it works. If it doesn't, 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.
I think there is a bug with the Placeholders function. When configuring a new table based on a mySQL query, I attempted to substitute a where clause parameter by adding %VAR1% e.g.
SELECT view_user_rank_by_category.`user_id`,
view_user_rank_by_category.`cat_name_for_reporting`,
view_user_rank_by_category.`category_name`,
view_user_rank_by_category.`rank_cat`,
view_user_rank_by_category.`user_iq_score`,
view_user_rank_by_category.`comparison_iq_score`,
view_user_rank_by_category.`report_dt`
FROM view_user_rank_by_category
where user_id = 371 and cat_name_for_reporting = '%VAR1%'
I placed a variable in the default value 'Intelligence Factor' (without quotes) and when I press 'Apply' the screen goes white at a date/time appears in the top left corner. When I refresh the page the screen returns to query without any placeholder configurations i.e. the last time I saved it.
I'd really like to use this feature. Is this an issue you are aware of? or am I doing something wrong?
Thanks
Hello again Peter.
If you are using String for Placeholder - ‘variable’ %VAR1% should be surrounded with Single Quote (‘) in the query.
Please try this, and let me know if it works. If it doesn't, 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.
Best regards.
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