Rebecca, I have created a version that doesn't require the view. Could you try this out?:
Uses Item source with nullability selection enabled Displayed Fields: Item -> (Default) Call Number/Volume -> Call Number Label (Raw Data) Item -> (Default) Call Number/Volume -> (Default) Bib Record -> (Default) Simple Record Extracts -> Title Proper (normalized) (Raw Data) as "Title" Item -> Barcode (Raw Data) Item -> (Child) Circulations -> Circ ID (Count Distinct) as "Total Circulation Count" Aggregate Filters: Item -> (Child) Circulations -> Circ ID (Count Distinct) - Less than or equal to - "10" Base Filters: Item -> Circluation Modifier (Raw Data) - In list Item -> (Default) Circulating Library -> Organizational Unit ID - In list Please let me know if that works for you. Thanks, Chris ----- Original Message ----- > Hey Chris, > > I gave it a shot, and got the following error message when I went to > output: > > DBD::Pg::st execute failed: ERROR: relation > "reporter.classic_item_list" does not exist at character 265 > > I also tried "Classic circulation view" and enabling the nullability > selection. I'll keep poking at it for now. > > 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: Wednesday, September 12, 2012 8:28 AM > To: Evergreen Discussion Group > Subject: Re: [OPEN-ILS-GENERAL] Weeding Report > > 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/ > -- 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/
