I want to display current user data in a table or chart, I have a query but in my query I have to write for example:
Select purchase_amount,Book_name from table where user_ID= 1 what should I write instead of 1 to make it dynamic, does query accept WP_Current_User_ID() function ?
We have a %CURRENT_USER_ID% placeholder which you can use. Something like this:
SELECT * FROM my_table
WHERE my_field > %VAR1%
AND my_field < %VAR2%
AND user_id = %CURRENT_USER_ID%
In this example the query means: “show me everything from my_table, where my_field is greater than variable 1, but less than variable 2, and user_id is equal to the currently logged in users’s ID”.
You can read more about placeholders in our documentation.
Sure, I will review in next month after fully used this plug in in my website, then I can write better review for you.
I have tried to use technique of place holder but not succeed. Basically I need to filter between two date, I have a column of dattime format. I have tried to use ( my_dat >%VAR1% and my_date<%VAR2), when I wrote : ('2019-01-06 00:00:01') in Var1 & Var 2 I got error, when I put values in quotation I(''2019-01-06 00:00:01'') I still get error.
I also want to know how can I change those values in frontend, can I use variable in your shortcode, for example: write and script and put today date as one of the variable ?
You have to make sure the datetime format is the same in the Database and in wpDataTables.
If at all possible, could you 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.
Hi
I want to display current user data in a table or chart, I have a query but in my query I have to write for example:
Select purchase_amount,Book_name from table where user_ID= 1 what should I write instead of 1 to make it dynamic, does query accept WP_Current_User_ID() function ?
Thanks
Navid
Hello Navid.
Thank you for your purchase.
We have a %CURRENT_USER_ID% placeholder which you can use. Something like this:
In this example the query means: “show me everything from my_table, where my_field is greater than variable 1, but less than variable 2, and user_id is equal to the currently logged in users’s ID”.
You can read more about placeholders in our documentation.
I hope this helps.
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
Hi Aleksandar,
Thank you very much for quick reply. That works afor me !
Regards,
Navid
You are welcome Navid. Glad that we solved the issue.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a Review on CodeCanyon on this link. Thanks!
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
Hi Aleksanda,
Sure, I will review in next month after fully used this plug in in my website, then I can write better review for you.
I have tried to use technique of place holder but not succeed. Basically I need to filter between two date, I have a column of dattime format. I have tried to use ( my_dat >%VAR1% and my_date<%VAR2), when I wrote : ('2019-01-06 00:00:01') in Var1 & Var 2 I got error, when I put values in quotation I(''2019-01-06 00:00:01'') I still get error.
I also want to know how can I change those values in frontend, can I use variable in your shortcode, for example: write and script and put today date as one of the variable ?
Thanks
Hi Navid.
You have to make sure the datetime format is the same in the Database and in wpDataTables.
If at all possible, could you 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