[Koha] Report for titles with all copies checked out

[Caitlin Kleinpaste]

Thank you so much!  This is perfect.

Caitlin

On Sun, Aug 23, 2015 at 4:36 PM, Josef Moravec <josef.moravec at 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 at 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 at gmail.com>
>> wrote:
>>
>> > Hi Caitlin,
>> >
>> > On Sat, Aug 22, 2015 at 1:49 AM, Caitlin Kleinpaste
>> > <kleinpastec at 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 at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>