how to use dynamic variables in the sql query
7 years 5 months ago #5826
by guo
how to use dynamic variables in the sql query was created 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.
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.
- Masood A Khan
- Offline
- Administrator
-
Less
More
- Posts: 103
- Thank you received: 0
7 years 5 months ago #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.
7 years 5 months ago #5828
by guo
Replied by guo on topic how to use dynamic variables in the sql query
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.
- Justyna Wachulka-Chan
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
7 years 4 months ago #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
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.
7 years 4 months ago #5867
by Soni
Replied by Soni on topic how to use dynamic variables in the sql query
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
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.