|Re: Accessing any dataset from a scripted datasource [message #886831 is a reply to message #886547]
||Fri, 15 June 2012 17:48
| Jason Weathersby
Registered: July 2009
Thanks for the update.|
On 6/15/2012 2:44 AM, Juergen Leeb wrote:
> Hi Jason,
> thanks für your answer. Is example was exactly what I' am looking for :) .
> Thanks a lot for that.
> Here is the background for my question:
> We have 3 production lines. Each of them monitors its consumption of
> natural gas. Therefore a table in a data base exists. With every major
> change the new consumption value is added to the old one. This new value
> is written in the table (also the timestamp and the variable's name).
> This means the values grow and grow. Compare with a water meter. To get
> the consumption in a period of time, let say from 06/04/12 12:00 am till
> 06/10/12 12:00 am, I have to query two values from the database. The one
> entry direct before 06/04/12 12:00 and the one entry direct before
> 06/10/12 12:00. The value I what to know is difference between the two
> values. This can only be done by java script.
> In our production are 3 Shifts. I have to generate a report which shows
> for every day and shift the value of consumption for every production line.
> To get out the values of the data base I use an ordenary jdbc data set.
> Parameter are the name of the variable, timestamp from and timestamp
> till. As a middle step I have scripted data set. The table looks like that:
> Variable Name, Production day, Shift, value;
> With a crosstable I' ll do the presenation.
> But within the script code (open event scripted ds) I have to execute
> the jdbc ds multiple times. For every day, shift and variable.
> With your example I will have the change to generate the report.
> Once again. Thank you!
> regards Juergen
Powered by FUDForum
. Page generated in 0.04892 seconds