Unfortunately, using variables ( @ ), stored procedures and nested queries is not supported, but you can prepare a MySQL view (which will return the data you need); call it “view1” for example, and then build a wpDataTable based on a simple query like “SELECT * FROM view1”.
Unfortunately this solution can't work for me because the user has to insert the values in two different table and when it visit the page i need to do some math operation but the value can be change in the table under the views.
I find some solution but it required too tables. Do you have any suggestion by ussing wpdatatables for implementing this solution?
Hi,
i need to use variable in my sql query because i have to do some math operation from more tables ecc.
For example i have to do this simple Query:
select @num:= 1stsampledate, @num2:= 1stsampledate
from wp_wpdatatable_29
where sostanza='Iron';
The plugin doesn't support the variable? can i use the variables in my query?
Regards
Massimiliano Ferraresi
Hello Massimiliano
Unfortunately, using variables ( @ ), stored procedures and nested queries is not supported, but you can prepare a MySQL view (which will return the data you need); call it “view1” for example, and then build a wpDataTable based on a simple query like “SELECT * FROM view1”.
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,
Unfortunately this solution can't work for me because the user has to insert the values in two different table and when it visit the page i need to do some math operation but the value can be change in the table under the views.
I find some solution but it required too tables. Do you have any suggestion by ussing wpdatatables for implementing this solution?
Thanks
Hi,
sorry whit the views i resolve this problem!!
Thanks for help!
Regards
I'm glad to hear that, Massimiliano
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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