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.
Best,
ERIC PHETTEPLACE Systems Librarian (he/him)
[email protected] | o 510.594.3660
5212 Broadway | Oakland, CA | 94618
:(){ :|: & };:
On Mon, Oct 14, 2019 at 4:31 AM Mark Alexander <[email protected]> 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
> [email protected]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
