Thank you so much! This is perfect. Caitlin On Sun, Aug 23, 2015 at 4:36 PM, Josef Moravec <josef.moravec@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 < kleinpastec@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 <indradg@gmail.com> wrote:
Hi Caitlin,
On Sat, Aug 22, 2015 at 1:49 AM, Caitlin Kleinpaste <kleinpastec@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_Book...
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