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/
