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 <[email protected]> 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 > [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
