[Koha-bugs] [Bug 9915] Allow opac/svc/report to be passed sql parameters

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

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

--- Comment #18 from Chris Cormack <chris at bigballofwax.co.nz> ---
(In reply to Martin Renvoize from comment #17)
> 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?

I cant replicate it failing, I did one with 3 parameters and it worked fine
http://rorohiko/cgi-bin/koha/svc/report?id=196&sql_params=2014-01-01&sql_params=AS&sql_params=ABS

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