Very late to the party, but maybe this could provide a clue.
The following throws an error, but I believe the basic idea of finding
records where the lowest itemlost value isn't zero is on the right
track:
WHERE itype = <>
GROUP BY biblionumber
HAVING MIN(itemlost) > 0
I suspect SQL is
Mark, that still didn't do the trick, but thanks!
Caroline, this is much closer to what I need. But still not quite right.
It's messy because I've altered a report that I found in the report library
rather inelegantly.
What I really need is a list of titles and biblio numbers of biblios where
the
Hello Elaine,
from what I understand, you want bibliographic information on lost items?
I'd need to know exactly the purpose of the report to help you more as
there are things in there I don't understand (like why select barcode,
when afterwards you group by biblionumber, or why the title is
Excerpts from Elaine Bradtke's message of 2019-08-23 11:32:44 -0700:
> I've got the following adapted from one in the reports library. But I need
> to limit it by item type, or not return everything that doesn't have an
> item record attached. We've got lots of components in our catalogue that
>
I've got the following adapted from one in the reports library. But I need
to limit it by item type, or not return everything that doesn't have an
item record attached. We've got lots of components in our catalogue that
don't have items and it's returning all of them:
SELECT
CONCAT(
5 matches
Mail list logo