[jboss-jira] [JBoss JIRA] Created: (JBPM-1080) Limit BAM Query to input data for simulation to time range doesn't work

Tue Nov 13 06:46:55 EST 2007

Limit BAM Query to input data for simulation to time range doesn't work
-----------------------------------------------------------------------

                 Key: JBPM-1080
                 URL: http://jira.jboss.com/jira/browse/JBPM-1080
             Project: JBoss jBPM
          Issue Type: Feature Request
          Components: Simulation
    Affects Versions: jBPM jPDL 3.2.2
            Reporter: Bernd Ruecker
         Assigned To: Tom Baeyens
            Priority: Minor

The GetSimulationInputCommand has a parameter "fromTimeOfDay" and "tillTimeOfDay". This should be included in the hibernate quries to supprto to query statistical data only for special times (for example shifts).

Unfortunately, comparing the time is not really easy with supporting different databases. In MySQL, there is a TIME(xxx) function, HSQL only supports HOUR(xxx) and MINUTE(xxx). 

Si I skipped it for the moment. The mySQL ready statements are commented out in the queries file.

Co currently, ALL statistics from all 24 hours are returned.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira