[Koha-bugs] [Bug 16219] New: Runreport.pl should allow sql paramters to be passed on the command line.

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16219

            Bug ID: 16219
           Summary: Runreport.pl should allow sql paramters to be passed
                    on the command line.
 Change sponsored?: ---
           Product: Koha
           Version: 3.18
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Command-line Utilities
          Assignee: gmcharlt at gmail.com
          Reporter: barton at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: robin at catalyst.net.nz

Runreport.pl has a major limitation in that it is not capable of running
reports that use sql parameters:

Runreport will run this:

SELECT p.surname, p.firstname, p.email, p.cardnumber, 
       h.waitingdate AS 'hold date', i.barcode, b.title
FROM reserves h 
LEFT JOIN borrowers p USING (borrowernumber) 
LEFT JOIN items i USING (itemnumber) 
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) 
WHERE h.waitingdate IS NOT NULL AND h.branchcode='ABC'


but if your report looks like this:

SELECT p.surname, p.firstname, p.email, p.cardnumber, 
       h.waitingdate AS 'hold date', i.barcode, b.title
FROM reserves h 
LEFT JOIN borrowers p USING (borrowernumber) 
LEFT JOIN items i USING (itemnumber) 
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) 
WHERE h.waitingdate IS NOT NULL AND h.branchcode=<<Waiting at|branches>>

We should be able to supply a --sql_params argument one or more times to
provide the sql parameters.

runreport.pl --to="someone at someplace.com" --subject="Patrons with Holds Waiting
at Library" --format=csv --sql_params="ABC" 1

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