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 Priority: Minor Original Estimate: 2 hours Remaining Estimate: 2 hours 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.