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
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
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
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
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
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 <kleinpastec@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 <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
On 24/08/15 15:12, Ahmad Amanullah Khan wrote:
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
Most likely you need to enable email cron jobs. If you've installed from Debian packages you'll find the command here: http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages (see #3.1) When starting a new thread to the mailing list, please change the subject heading. Bob Birchall Calyx
participants (5)
-
Ahmad Amanullah Khan -
Bob Birchall -
Caitlin Kleinpaste -
Indranil Das Gupta -
Josef Moravec