Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon how to use dynamic variables in the sql query

More
20 Apr 2018 14:11 #5867

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 or Create an account to join the conversation.

  • Justyna Wachulka-Chan
  • Justyna Wachulka-Chan's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
20 Apr 2018 13:11 #5865

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 or Create an account to join the conversation.

  • guo
  • guo's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
10 Apr 2018 09:29 #5828

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 or Create an account to join the conversation.

More
10 Apr 2018 07:46 #5827

Can you please let us know your Order or Subscription number

Please Log in or Create an account to join the conversation.

  • guo
  • guo's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
10 Apr 2018 07:42 #5826

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 or Create an account to join the conversation.