Bug 1085820
| Summary: | Date range in some reports queries is incorrect - includes the end date | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Shirly Radco <sradco> |
| Component: | ovirt-engine-reports | Assignee: | Shirly Radco <sradco> |
| Status: | CLOSED ERRATA | QA Contact: | Petr Matyáš <pmatyas> |
| Severity: | high | Docs Contact: | |
| Priority: | medium | ||
| Version: | 3.3.0 | CC: | gklein, iheim, movciari, pstehlik, rbalakri, Rhev-m-bugs, sherold, yeylon, ylavi |
| Target Milestone: | --- | ||
| Target Release: | 3.5.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | infra | ||
| Fixed In Version: | vt10 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2015-02-11 18:17:13 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 1142923, 1156165 | ||
Reports fixed in this bug: BR18, BR19, BR17, BR7, BR8, BR13, BR46, BR16, BR10A, BR22B, BR22B, BR18A, BR23, BR6B, BR4, BR11, BR7A, BR14A Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHEA-2015-0176.html |
Description of problem: Date range in some reports queries is incorrect - includes the end date. The date range should be from the starts date (included) till the end date (excluded). Version-Release number of selected component (if applicable): How reproducible: Example query report currently: AND history_datetime >= CAST ( $P{P_Start_Date} AS TIMESTAMP ) AND history_datetime <= CASE .. Should be: AND history_datetime >= CAST ( $P{P_Start_Date} AS TIMESTAMP ) AND history_datetime < CASE .. Actual results: The date range is from the starts date (included) till the end date (included). Expected results: The date range should be from the starts date (included) till the end date (excluded). Additional info: Report for example: br46