Thank you so much! This is perfect. Caitlin
On Sun, Aug 23, 2015 at 4:36 PM, Josef Moravec <josef.mora...@gmail.com> wrote: > Hello Caitlin, > > I've just tried to write an SQL which meets your needs and I think > something like this should work for you: > > select b.biblionumber, b.title, b.author, SUM(IF(i.onloan is null, 1, 0)) > as available > FROM biblio b > JOIN items i > ON b.biblionumber = i.biblionumber > GROUP BY b.biblionumber > HAVING available = 0 > > Josef > > ne 23. 8. 2015 v 14:12 odesÃlatel Caitlin Kleinpaste < > kleinpas...@xenos.org> napsal: > >> I've seen the report that gives you all checked out books, but I then have >> to go through each title and see if we have any copies that are not >> checked >> out. >> >> I've also seen the one that tells you books with copies on hold, but our >> patrons tend to do a lot of dropping in to see if we have something rather >> than placing holds. >> >> I'm just wondering if someone has written a report that is not on the SQL >> Reports Library that finds titles with every copy checked out. If not, I >> may try writing one, but I've never written a report before so I thought >> I'd try this first. >> >> Thanks, >> Caitlin Kleinpaste >> >> >> On Fri, Aug 21, 2015 at 7:38 PM, Indranil Das Gupta <indr...@gmail.com> >> wrote: >> >> > Hi Caitlin, >> > >> > On Sat, Aug 22, 2015 at 1:49 AM, Caitlin Kleinpaste >> > <kleinpas...@xenos.org> wrote: >> > > We're trying to get an idea of books that we might need more copies >> of, >> > and >> > > so want to get a list of all the titles we have that all copies are >> > checked >> > > out. >> > > >> > > Has anyone written a report like this? If so, could you send it to >> me? >> > >> > >> > >> http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_Checked_Out_Books >> > >> > And while you are at it, also take a look at the other reports :-) >> > >> > hope this helps, >> > -Indranil >> > >> > >> > -- >> > Indranil Das Gupta >> > L2C2 Technologies >> > >> > Phone : +91-98300-20971 >> > Blog : http://indradg.randomink.org/blog >> > IRC : indradg on irc://irc.freenode.net >> > Twitter : indradg >> > >> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- >> > Please exchange editable Office documents only in ODF Format. No other >> > format is acceptable. Support Open Standards. >> > >> > For a free editor supporting ODF, please visit LibreOffice - >> > http://www.documentfoundation.org >> > >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha