[Koha] Create a report that lists biblio number for a specific item type

Kyle Hall kyle.m.hall at gmail.com
Sat Oct 31 01:32:10 NZDT 2015


Here is the most basic version of the report you are looking for:

SELECT biblionumber FROM items WHERE itype=<<Select itemtype|itemtypes>>

When you run the report, you will be asked to select the itemtype to report
on.

Kyle

http://www.kylehall.info
ByWater Solutions ( http://bywatersolutions.com )
Meadville Public Library ( http://www.meadvillelibrary.org )
Crawford County Federated Library System ( http://www.ccfls.org )
Mill Run Technology Solutions ( http://millruntech.com )

On Fri, Oct 30, 2015 at 5:54 AM, Charlotte Stock <charlotte at bu-london.co.uk>
wrote:

> I've searched the forum but cannot find an SQL report that will allow me to
> generate a list of biblio numbers for a specific item type (for example,
> list all DVDs or list all Set Texts). Should I be creating a report for
> this
> type of listing or should I be using another tool to create the information
> I need?
>
> Thanks in advance for your time
> Charlotte
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Create-a-report-that-lists-biblio-number-for-a-specific-item-type-tp5859385.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> 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