Query option in Plugin

Hi Anes,
I dont understand what you mean by “prepared statement”. Anyway dynamic chart configuration per user’s interaction is not supported at the moment. Unless you are modifying the code base.
can you please elaborate on what you’re trying to achieve?

Dear Claudio,
I will explain my doubt, suppose our query that work for a chart is
“select name,age from table where region=’Alabama'”
in that query when user need data of “Kentucky” region , do we can add an option in query to change the region as “Kentucky” from user view . Reply with your idea.

Thanks,
Anes

Hi Anes,
currently when you load a page with the chart some placeholders in the query are replaced with actual values.
For example you can create a query using {{{userID}}} and this will be replaced by the actual userID when loading the page.
This will enable user-specific charts.
On the other hand if you want to dynamically change the structure of a chart you need to completely change how the charts are created. This can probably be done using AJAX calls that refresh the displayed data.
To do so you need to:
1) create an API to be called and retrieve the data
2) create on the client side an ajax event that calls this service
3) dynamically update using JS the placeholder with the data. For example in this example
https://www.wpbusinessintelligence.com/line-chart/
you need to update the content of nvd3Data_ph_Stocks_Multiline

This is quite a heavy change in the plugin and will require some work.
I hope this helps
regards,
Claudio