[Koha-bugs] [Bug 10216] New: Request for a more in-depth report

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

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

            Bug ID: 10216
           Summary: Request for a more in-depth report
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: 3.10
          Hardware: PC
                OS: Windows
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: gmcharlt at gmail.com
          Reporter: lisenbee at uiwtx.edu

Hello,

We need some assistance with a report. We would like to run the following
Patron Fines SQL report:


SELECT 
    b.surname, b.firstname, b.email, bib.title, i.barcode, 
    a.amountoutstanding, ni.issuedate, ni.date_due, 
    IF ( ni.returndate IS NULL , " ", ni.returndate ) AS returndate 
FROM accountlines a 
  LEFT JOIN borrowers b ON ( b.borrowernumber = a.borrowernumber ) 
  LEFT JOIN items i ON ( a.itemnumber = i.itemnumber ) 
  LEFT JOIN biblio bib ON ( i.biblionumber = bib.biblionumber ) 
  LEFT JOIN ( SELECT * FROM issues UNION SELECT * FROM old_issues ) ni ON (
ni.itemnumber = i.itemnumber AND ni.borrowernumber = a.borrowernumber ) 
WHERE 
    a.amountoutstanding > 0 
GROUP BY a.description
ORDER BY b.surname, b.firstname, ni.timestamp DESC


But we need more information. We need there to be two additional fields: year
of graduation (i.e., Class of 2016), and ID/Card number. Is this possible?

Thank you in advance for your assistance.

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