[Koha-bugs] [Bug 12757] Integers in saved SQL report ODT export prepended with single quote
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Oct 8 16:10:36 CEST 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12757
--- Comment #2 from Nicole C. Engard <nengard at gmail.com> ---
Here's one:
select i.location, s.type, count(s.datetime) as count from statistics s left
join items i using (itemnumber) where i.location IN
('BOARDBK','EASYRDR','JAUDIOBK','JBIO','JDVD','JDVDNF','JDVDS7','JDVDSER','JFIC','JGRAPHIC','JLANG','JMUSIC','JMYS','JNF','JOS','JPER','JSPN','JVDV','KIWANIS','PICBOOK','SUMMER')
AND s.datetime between <<Between (yyyy-mm-dd)|date>> and <<and
(yyyy-mm-dd)|date>> and s.type in ('issue','renew','return') group by
i.location, s.type
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list