how to use dynamic variables in the sql query

More
7 years 5 months ago #5826 by guo
i see the thing in vchart was: You can also include dynamic variables in your SQL query. You just need to enter variable name within curly braces. e.g. {catid}. {loggedinuserid} is reserverd for Logged-in User.
nut i don't know how to use the dynamic variables in my sql query, and when i want to use dynamic variables, what should i do.
please help me.

Please Log in to join the conversation.

More
7 years 5 months ago #5827 by Masood A Khan
Can you please let us know your Order or Subscription number

Please Log in to join the conversation.

More
7 years 5 months ago #5828 by guo
i dont know the number, because the plugin was boss samlee give me to install. if he give me the number, i will tell you in the first time.

Please Log in to join the conversation.

More
7 years 4 months ago #5865 by Justyna Wachulka-Chan
Hi! that is also an interesting topic for me. any follow up on that?
Do you have any example of a sql code for a query? I am trying to build sql pie chart, the code I created works for bar, but not for pie chart.
thanks

Please Log in to join the conversation.

More
7 years 4 months ago #5867 by Soni
Hi

use this format to write query for pie chart
select `first column name(can be integer or string)`, `second column name (should be integer or float value)` from `table name`

Thanks
Zaheer

Please Log in to join the conversation.

Cron Job Starts