Thank you so much! This is perfect.
Caitlin
On Sun, Aug 23, 2015 at 4:36 PM, Josef Moravec
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
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
wrote:
> I've seen the report that gives you all checked out books, but I then have
> to go through e
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
H
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 r
Hi Caitlin,
On Sat, Aug 22, 2015 at 1:49 AM, Caitlin Kleinpaste
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 se
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
_
6 matches
Mail list logo