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
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
2h 59m | 1 | Backlog Manager | 24/Oct/15 3:04 AM | |||||
|
3h | 1 | Backlog Manager | 24/Oct/15 6:04 AM | |||||
|
4d 6h 34m | 1 | Manuel Escriche | 28/Oct/15 11:39 AM |
