I will try to expand on this:

I have changed jobNumber to batchNumber to help clarify

There are several plc's , each one at different site. Each has 5 datapoints that we want.
(4 sensors and 1 batchNumber)
Using a modbus datasource, we are retreiving and logging these once per sec into mango on office laptop.
Batch numbers are generated on site so the office has no idea which plc has which batches or when they were done.

batch#, ch1, ch2, ch3, ch4

404 63 67 48 78
404 63 67 48 78

405 63 67 48 78
405 63 67 48 78
405 63 67 48 78
405 63 67 48 78

612 63 67 48 78
612 63 67 48 78
612 63 67 48 78
612 63 67 48 78

on and on every second...

back at the office, the supervisor types in batch number he wants into mango dashboard. This could be a batch from 1 week ago, lets say batch #405.
We need to find the device with #405 on it and put the 4 sensor readings into the serialChart input array for graphical viewing.Keep doing this until a historical graph is built
We have a customized serialChart which views realtime very nicely, but its the historical data that im having trouble with.

hence my request for a query that compares a datapoint value on the plc

Thanks MattFox,

I was able to customize the tab name at the top of web page so I thought i'd give this a shot.

have been getting datapoints for my chart using this:

<ma-point-query query="{$and: true, deviceName:'unit#1_plc', name:'jobNumber'}" limit="9" points="points"></ma-point-query>

but im really wanting the datapoints when "jobNumber=certainValue"

can this be done?

what about on only two devices like: deviceName:'unit#1_plc' or 'unit#2_plc'

hello ,

I have enabled the export on my serialChart. I would like to change the filename that mango assigns to the download and appears at bottom left in the download tab . (ex. "mangoChart 37" change to "my filename 38")

also how to change the text at top of the column in csv report. it currently uses the xid and i have been changing that to something more relevant but was hoping to change it to the name property.

Thanks CraigWeb,

I will watch

this is the graph viewer I have built. I can select the source for each pen. in this case it is showing some data points from a plc. but i can with drop down , select a different source for each pen. The user will want to use this viewer to see datapoints from a mySQL database instead of a plc. Im not sure how to do this but....

i set up a SQL data source with the following :
connection string = jdbc:mysql://localhost:3306/unit1jobdata
driver = com.mysql.jdbc.Driver
Query = select * from testdata1
timestamp overide = assigned to the column containing the timestamp data

the mySQL data is from past jobs

not sure if this helps....

Thanks CraigWeb,

I will get some more info.

I also am now thinking my SQL query may not be right. I m not sure if it should be incrementally getting one row per second or the whole thing .
Right now it is: select * from testfile

Hello,

I have a SQL source set up that connects to a mySQL db file. I have used the test button and I have data being retreived so i feel it is set up correctly. The 1rst column is a time and date stamp then 8 columns of integers. The data was taken once per second so Ive made my query ask for a full row every second. also, ive defined the timestamp as the time overide column(hope thats right).

I have a serialChart that reads these 8 columns but still uses a to/from type date picker to select how long the charts time axis is. I dont know how to get it to use the timestamp from my SQL source as the time axis of the serialchart.

what needs to happen to acheive this?

hello MattFox,

got it finally!
Thanks for checking in.

Hello,

Trying to use the json store demo I found in the docs. Dont seem to get any activity on the result side when entering data into inputs. The markup indicates the retreived data should appear at bottom under save button. Do i need to turn on the json store somewheres?

Ultimately, I need to have a way of saving a set of preferences for several users. These preferences hold their favorite serial chart configuration. (pen color, thickness, min and max scales sources etc.) The Idea is to be able to reload the correct chart config for the correct user once it is determined who they are , or at least let them pick from a saved list of configurations. I have the serial chart ready, just need a way of storing it and retreiving it. Ive also thought a config file or "recipe file" might be an option.

any help would be greatly appreciated.