[Koha] Creating Lists of Item Numbers

Eric Phetteplace ephetteplace at cca.edu
Tue Oct 15 06:05:01 NZDT 2019

In particular, the SQL you will need is likely:

SELECT itemnumber
FROM items
WHERE location IS NULL OR location = ''

That will give you a simple list of item IDs that do not have an associated
shelving location ("location" in the database's terms). If you're on a
modern version of Koha, there will even be a "batch modify" button in the
report results which takes you to exactly the Batch item modification tool
with all of these items ready to be bulk edited.


ERIC PHETTEPLACE Systems Librarian (he/him)

ephetteplace at cca.edu | o 510.594.3660

5212 Broadway | Oakland, CA | 94618

:(){ :|: & };:

On Mon, Oct 14, 2019 at 4:31 AM Mark Alexander <marka at pobox.com> wrote:

> Excerpts from Charles Kelley's message of 2019-10-14 18:18:16 +0900:
> >     Can someone help me? Is there a tutorial on compiling item lists,
> bib.
> > record lists, patron lists, etc.?
> I believe that generating of lists is usually done with reports.
> See this section of the Koha manual:
> https://koha-community.org/manual/19.05/en/html/reports.html
> Also see this page, which shows many sample reports:
> https://wiki.koha-community.org/wiki/SQL_Reports_Library
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list