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@gmail.com Reporter: barton@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: robin@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@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.