Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-4947

FIWARE.Question.Tech.Apps.DataViz-SpagoBI.: Is is possible to define a script dataset using a query dataset result?

        Details

          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

            Descending order - Click to sort in ascending order
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Open In Progress In Progress
            		2h 59m 1 Backlog Manager 24/Oct/15 3:04 AM
            In Progress In Progress Answered Answered
            		3h 1 Backlog Manager 24/Oct/15 6:04 AM
            Answered Answered Closed Closed
            		4d 6h 34m 1 Manuel Escriche 28/Oct/15 11:39 AM
            fla Fernando Lopez made changes -
            Fix Version/s 2021 [ 12600 ]
            mev Manuel Escriche made changes -
            HD-Enabler SpagoBI [ 10856 ]
            HD-Chapter Apps [ 10836 ]
            mev Manuel Escriche made changes -
            Summary FIWARE.Question.Lab.Apps.DataViz-SpagoBI.: Is is possible to define a script dataset using a query dataset result? FIWARE.Question.Tech.Apps.DataViz-SpagoBI.: Is is possible to define a script dataset using a query dataset result?
            zerbetto Davide Zerbetto made changes -
            Summary [fiware-stackoverflow] SpagoBI: a script data set using a query data set result FIWARE.Question.Lab.Apps.DataViz-SpagoBI.: Is is possible to define a script dataset using a query dataset result?
            mev Manuel Escriche made changes -
            Assignee Davide Zerbetto [ davide.zerbetto ]
            mev Manuel Escriche made changes -
            Resolution Done [ 10000 ]
            Status Answered [ 10104 ] Closed [ 6 ]
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2015-10-24 06:05|UPDATED status: transition Answered| # answers= 1, accepted answer= True

            Show
            backlogmanager Backlog Manager added a comment - 2015-10-24 06:05|UPDATED status: transition Answered| # answers= 1, accepted answer= True
            backlogmanager Backlog Manager made changes -
            Status In Progress [ 3 ] Answered [ 10104 ]
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2015-10-24 03:05|UPDATED status: transition Answer| # answers= 1, accepted answer= True

            Show
            backlogmanager Backlog Manager added a comment - 2015-10-24 03:05|UPDATED status: transition Answer| # answers= 1, accepted answer= True
            backlogmanager Backlog Manager made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            backlogmanager Backlog Manager made changes -
            Field Original Value New Value
            Component/s FIWARE-TECH-HELP [ 10278 ]
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2015-10-24 00:05|CREATED monitor | # answers= 1, accepted answer= True

            Show
            backlogmanager Backlog Manager added a comment - 2015-10-24 00:05|CREATED monitor | # answers= 1, accepted answer= True
            backlogmanager Backlog Manager created issue -

              People

              • Assignee:
                zerbetto Davide Zerbetto
                Reporter:
                backlogmanager Backlog Manager
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: