Re: [Koha] Report for titles with all copies checked out
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
Re: [Koha] Report for titles with all copies checked out
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
Re: [Koha] Report for titles with all copies checked out
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
Re: [Koha] Report for titles with all copies checked out
Good Morning We have setup overdue notices and slips but unable to send emails. Email is working when creating a new patron account. Please help On Sun, Aug 23, 2015, 5:12 PM Caitlin Kleinpaste kleinpas...@xenos.org wrote: 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
[Koha] Report for titles with all copies checked out
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? Thanks! Caitlin Kleinpaste ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report for titles with all copies checked out
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