[Koha-bugs] [Bug 9915] Allow opac/svc/report to be passed sql parameters
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Mar 12 12:57:04 CET 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9915
Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|Signed Off |Failed QA
CC| |martin.renvoize at ptfs-europe
| |.com
--- Comment #17 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
I'm afraid I can't get this to work for more than one parameter?
I have the below report to grab 'New Items added between two dates', running
through the normal report interface I can varify I do get responses for the
query, but running through svc interface I get zero results (i.e [] is the
response)
URLs and Report detailed below:
svc URL used:
http://koha-staff.koha-ptfs.co.uk/cgi-bin/koha/svc/report?id=69&sql_params=2010-03-19&sql_params=2010-11-18
report URL used:
http://koha-staff.koha-ptfs.co.uk/cgi-bin/koha/reports/guided_reports.pl?reports=69&phase=Run+this+report&sql_params=2010-03-19&sql_params=2010-11-18
report used:
SELECT
biblio.title,biblio.author,biblio.datecreated,biblioitems.isbn,items.barcode,items.location
FROM items LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on
(biblioitems.biblionumber=biblio.biblionumber) WHERE biblio.datecreated >=
<<Enter Start Date|date>> AND biblio.datecreated <= <<Enter End Date|date>>
ORDER BY biblio.author asc
If I remove the second parameter from the report and hard code it, I can use
both the reports and svc interface without issue.
Could you look into this Chris?
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list