Rebecca, If I were you, I would use the "Classic Item List" source, which contains all the fields you're looking to display (including use count). Here's what I just did for a test template:
Use Classic Item List source; nullability selection disabled Displayed Fields: Classic Item List -> Callnumber Label as "Call Number Label" Classic Item List -> Title Classic Item List -> Barcode Classic Item List -> Use Count as "Total Circulation Count" Base Filters: Classic Item List -> Use Count - Less than or equal to - "10" Classic Item List -> Circ Modifier - In list Classic Item List -> Circ Lib -> Organizational Unit ID - In list If I were creating this template for PINES, I would also display the org unit shortname (Classic Item List -> Circ Lib -> Short (Policy) Name) since that would allow you to print a master weeding list for an entire system and subdivide it from there. I hope that's helpful! Please test it out and feel free to let me know if it still doesn't work for you Chris ----- Original Message ----- > From: "Rebecca Larocque" <[email protected]> > To: "Evergreen Discussion Group" <[email protected]> > Sent: Tuesday, September 11, 2012 4:44:28 PM > Subject: Re: [OPEN-ILS-GENERAL] Weeding Report > > Hi Chris, > > Sure - I've attached it as a text file. Have at it! > > r. > > Rebecca Larocque, BA (Hons), MLIS > Head of Information Services > North Bay Public Library > 271 Worthington St. E, North Bay ON > P1B 1H1 > Phone: (705) 474-4830 x2821 > Fax: (705) 495-4010 > http://www.cityofnorthbay.ca/library > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On > Behalf Of Sharp, Chris > Sent: Tuesday, September 11, 2012 3:50 PM > To: Evergreen Discussion Group > Subject: Re: [OPEN-ILS-GENERAL] Weeding Report > > Rebecca, > > Would you be willing to share the Generated SQL from your Debugging > Info? It's possible someone can make a recommendation based on > that. > > Thanks, > > Chris > > ----- Original Message ----- > > From: "Rebecca Larocque" <[email protected]> > > To: "Open-ILS General Listserv > > ([email protected])" > > <[email protected]> > > Sent: Tuesday, September 11, 2012 2:49:43 PM > > Subject: [OPEN-ILS-GENERAL] Weeding Report > > > > > > > > > > Good afternoon all, > > > > > > > > This subject has come up from time to time, and the response has > > been > > vague. What I’m looking for is suggestions on how to create weeding > > reports, to see how other libraries are doing it, what filters to > > use, > > etc. > > > > > > > > Currently, we’re still on 2.0.7, and the report I wrote filters on > > the > > following: > > > > · Organization ID > > > > · Total Circulation Count (with the operator set to “Less than or > > equal to”) – we’ve been on the system for almost a year, so > > anything > > that hasn’t circulated 10 times (or less than once a month) can go > > > > · Circulation Modifier code (with the operator set to “In List”) – > > because I want to weed certain AV collections > > > > > > > > The results aren’t that great: > > > > · I’m getting far fewer results than I’m expecting (i.e. the VHS > > video > > collection is lightly used, and considering that a big chunk of it > > is > > in storage and never go out, I should be getting all of them but I > > don’t. Ditto the Talking Book on Cassette collection.) > > > > · It’s picking up material with other circ modifiers. > > > > > > > > Can anyone offer suggestions, pointers, corrections and whatnot? > > > > > > > > Thanks, > > > > Rebecca > > > > > > > > Rebecca Larocque, BA (Hons), MLIS > > > > Head of Information Services > > > > North Bay Public Library > > > > 271 Worthington St. E, North Bay ON > > > > P1B 1H1 > > > > Phone: (705) 474-4830 x2821 > > > > Fax: (705) 495-4010 > > > > http://www.cityofnorthbay.ca/library > > > > > > -- > Chris Sharp > PINES Program Manager > Georgia Public Library Service > 1800 Century Place, Suite 150 > Atlanta, Georgia 30345 > (404) 235-7147 > [email protected] > http://pines.georgialibraries.org/ > -- Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 [email protected] http://pines.georgialibraries.org/
