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) ephetteplace@cca.edu | o 510.594.3660 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };: On Mon, Oct 14, 2019 at 4:31 AM Mark Alexander <marka@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha