how to use dynamic variables in the sql query

More
20 Apr 2018 14:11 #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.

  • Justyna Wachulka-Chan
  • Offline
  • New Member
  • New Member
More
20 Apr 2018 13:11 #5865 by Justyna Wachulka-Chan
Replied by Justyna Wachulka-Chan on topic how to use dynamic variables in the sql query
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
10 Apr 2018 09:29 #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
10 Apr 2018 07:46 #5827 by Masood A Khan
Replied by Masood A Khan on topic how to use dynamic variables in the sql query
Can you please let us know your Order or Subscription number

Please Log in to join the conversation.

More
10 Apr 2018 07:42 #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.

Cron Job Starts