[Koha-bugs] [Bug 8287] remove filter on checked out from overdues

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8287

--- Comment #1 from Owen Leonard <oleonard at myacpl.org> ---
Here's the SQL for what is run without the box checked:

SELECT date_due, borrowers.title as borrowertitle, borrowers.surname,
borrowers.firstname, borrowers.streetnumber, borrowers.streettype,
borrowers.address, borrowers.address2, borrowers.city, borrowers.zipcode,
borrowers.country, borrowers.phone, borrowers.email, issues.itemnumber,
issues.issuedate, items.barcode, biblio.title, biblio.author,
borrowers.borrowernumber, biblio.biblionumber, borrowers.branchcode,
items.itemcallnumber, items.replacementprice, items.enumchron FROM issues LEFT
JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) LEFT JOIN
items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblioitems ON
(biblioitems.biblioitemnumber=items.biblioitemnumber) LEFT JOIN biblio ON
(biblio.biblionumber=items.biblionumber ) WHERE 1=1 AND date_due < '2012-06-21
14:16' ORDER BY date_due, surname, firstname 

Here's the SQL with the box checked:

SELECT date_due, borrowers.title as borrowertitle, borrowers.surname,
borrowers.firstname, borrowers.streetnumber, borrowers.streettype,
borrowers.address, borrowers.address2, borrowers.city, borrowers.zipcode,
borrowers.country, borrowers.phone, borrowers.email, issues.itemnumber,
issues.issuedate, items.barcode, biblio.title, biblio.author,
borrowers.borrowernumber, biblio.biblionumber, borrowers.branchcode,
items.itemcallnumber, items.replacementprice, items.enumchron FROM issues LEFT
JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) LEFT JOIN
items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblioitems ON
(biblioitems.biblioitemnumber=items.biblioitemnumber) LEFT JOIN biblio ON
(biblio.biblionumber=items.biblionumber ) WHERE 1=1 ORDER BY date_due, surname,
firstname

Checking the box removes the limit on date_due.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.