[ic] graph.usertag

Josh Lavin josh at perusion.com
Mon Aug 18 15:04:25 UTC 2014


Quoting dev2 at adeux.net (dev2 at adeux.net):
> Hello,
> I am trying to use the graph.usertag on the RTFM site - looking at the documentation I have come up with the following syntax:
> [graph type="lines" title="Temperature" x_label="Time" y_label="degrees c" query=""]
> However, I do not really folow what the query should be.  The documentation says:
> query - SQL query returning data to populate the graph with.  The first column
>   returned is the code or label of the dataset, the second column is the x-axis
>   label and the 3rd column is the y-axis point.
> Does that mean that each row needs the dataset name - eg:
> temp 10:00 20.0
> temp 10:01 20.0
> temp 10:02 19.9

If it did, then you could just do something like: SELECT 'temp', row1,
row2 FROM ...

-- 
Josh Lavin
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
... ask me about job opportunities ...



More information about the interchange-users mailing list