Details
-
Type:
Monitor
-
Status: Closed
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: 2021
-
Component/s: FIWARE-TECH-HELP
-
Labels:
-
HD-Chapter:Apps
-
HD-Enabler:SpagoBI
Description
Created question in FIWARE Q/A platform on 28-08-2015 at 16:08
Please, ANSWER this question AT http://stackoverflow.com/questions/32273762/spagobi-a-script-data-set-using-a-query-data-set-result
Question:
SpagoBI: a script data set using a query data set result
Description:
In spagoBI there are many ways to create a data set: script (using Groovy or Javascript), data base query
but I want to create a script data set based on the data base query result
For example if my data base query result returns: "ON"
My script returns a value incremented by one comparing to the last value returned
if the DB query returns OFF, the script value will be decremented by 1
Any ideas how to get data base query results in a Groovy or Javascript script to create a SpagoBI data set?
Activity
2015-10-24 03:05|UPDATED status: transition Answer| # answers= 1, accepted answer= True
2015-10-24 06:05|UPDATED status: transition Answered| # answers= 1, accepted answer= True
2015-10-24 00:05|CREATED monitor | # answers= 1, accepted answer= True