We want to return the customer's personalized prices using a SQL query from a external database connected to it, while hiding other customers prices, is it possible?
We could get it into a local variable called $userprice.
When creating the table it didnt let us use a variable so I editted the query in the database to read something like: WHERE PLICRI1_0 LIKE $userprice AND PLI_0 LIKE 'T002'
But it didnt worked out even though "echo $userprice " return the correct term.
We even tried adding it including quotes to see if it was passd correctly.
Is there any easier way to archieve this with this plugin?
Using variables in wpDataTables queries is not supported, so if this works in phpMyAdmin, you would be able to create a MySQL view and then generate a table that would pull the data from the view.
Using SQL queries requires coding experience, and included support refers only to advice, so we wouldn't be able to help you with a custom query.
In your previous ticket, you mentioned that your support expired and questions like this are offered in the premium support for the plugin. Where did you purchase the plugin from? If you bought it from Envato marketplace, we would be able to offer you a discount to move to our subscription-based licensing, so could you please provide me the invoice for the purchase, and I'll check with our management which discount we'd be able to offer (if you're interested, of course).
Please note that this is a public ticket, so if you're sharing purchase details with us, make sure to enable the PRIVATE response.
I cannot offer you any discounts without seeing the invoice for the purchase from Envato. Please share that with me, and I will provide you with a discount coupon you can use to purchase the plugin from our website.
Thank you for all your support, we discussed internally but if variables aren't supported I think we will need to find a totally different solution, further support wouldn`t be of much help. Please consider it as an feature (or add-on, we would pay extra for that) request for now.
I guess you can close this ticket... (or feel free to ask for further details of what we couldn't achieve, if that would help)
I'm sorry to hear that, Igor, but I can understand.
We do plan to develop this, but it will require a lot of work, most likely changing the SQL parser we use. Our developers are working on a plan, but I don't see it coming any time soon, unfortunately.
Hello,
We want to return the customer's personalized prices using a SQL query from a external database connected to it, while hiding other customers prices, is it possible?
We could get it into a local variable called $userprice.
When creating the table it didnt let us use a variable so I editted the query in the database to read something like: WHERE PLICRI1_0 LIKE $userprice AND PLI_0 LIKE 'T002'
But it didnt worked out even though "echo $userprice " return the correct term.
We even tried adding it including quotes to see if it was passd correctly.
Is there any easier way to archieve this with this plugin?
Best Regadrs,
Igor
Hello Igor
Using variables in wpDataTables queries is not supported, so if this works in phpMyAdmin, you would be able to create a MySQL view and then generate a table that would pull the data from the view.
Using SQL queries requires coding experience, and included support refers only to advice, so we wouldn't be able to help you with a custom query.
In your previous ticket, you mentioned that your support expired and questions like this are offered in the premium support for the plugin. Where did you purchase the plugin from? If you bought it from Envato marketplace, we would be able to offer you a discount to move to our subscription-based licensing, so could you please provide me the invoice for the purchase, and I'll check with our management which discount we'd be able to offer (if you're interested, of course).
Please note that this is a public ticket, so if you're sharing purchase details with us, make sure to enable the PRIVATE response.
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
Hello… Yes, we bought it from Envato, can you share the subscription link/instructions?
Its not MySQL, its MSSQL so no phpMyAdmin here.
I have some coding knowledge in C and Assembly and we also have someone with some PHP knowledge to help.
Best Regards,
Igor
Hi again Igor
I cannot offer you any discounts without seeing the invoice for the purchase from Envato. Please share that with me, and I will provide you with a discount coupon you can use to purchase the plugin from our website.
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
Thank you for all your support, we discussed internally but if variables aren't supported I think we will need to find a totally different solution, further support wouldn`t be of much help.
Please consider it as an feature (or add-on, we would pay extra for that) request for now.
I guess you can close this ticket...
(or feel free to ask for further details of what we couldn't achieve, if that would help)
I'm sorry to hear that, Igor, but I can understand.
We do plan to develop this, but it will require a lot of work, most likely changing the SQL parser we use. Our developers are working on a plan, but I don't see it coming any time soon, unfortunately.
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