https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21445
Bug ID: 21445
Summary: Report - having two date ranges in query creates a
formatting issue when running report
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Reports
Assignee: koha-bugs@lists.koha-community.org
Reporter: tgoat...@gmail.com
QA Contact: testo...@bugs.koha-community.org
When the report is run like the following query, the second half of the second
date range does not display.
SELECT borrowers.cardnumber, borrowers.surname, borrowers.firstname,
borrowers.dateofbirth, borrowers.dateenrolled
FROM borrowers
WHERE dateofbirth BETWEEN <<Date of Birth BETWEEN (yyyy-mm-dd)|date>> AND <<
AND (yyyy-mm-dd)|date>> AND dateenrolled BETWEEN <<Enrollment Date BETWEEN
(yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND
branchcode=<<Branch|branches>>
ORDER BY borrowers.surname ASC
Reformatting the query as follows all dates ranges display correctly.
SELECT
borrowers.cardnumber,
borrowers.surname,
borrowers.firstname,
borrowers.dateofbirth,
borrowers.dateenrolled
FROM
borrowers
WHERE
dateofbirth BETWEEN <<Date of Birth BETWEEN (yyyy-mm-dd)|date>> AND << AND
(yyyy-mm-dd)|date>>
AND dateenrolled BETWEEN <<Enrollment Date BETWEEN (yyyy-mm-dd)|date>> AND
<<and (yyyy-mm-dd)|date>>
AND branchcode=<<Branch|branches>>
ORDER BY
borrowers.surname ASC
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
