http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9915
--- Comment #18 from Chris Cormack <ch...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/