Oh, one more thing... It's possible to have bib records that legitimately don't have copies attached (such as a record for an e-resource). To exclude these, you could add the following filter:
Bibliographic Record -> Record Source -> id (In list) which will give you a selectable list of Record sources to filter on when running the report. Hope that's helpful too, Chris ----- Original Message ----- > From: "Chris Sharp" <[email protected]> > To: "Evergreen Discussion Group" <[email protected]> > Sent: Monday, April 27, 2015 7:19:37 AM > Subject: Re: [OPEN-ILS-GENERAL] Bib records without item attached report > template > > Hi Rita, > > This may do what you're after: > > Use the Bibliographic Record source. > > Displayed Fields: > > Bibliographic Record -> TCN Value > Bibliographic Record -> Record Creator -> OPAC/Staff Client User Name > > Base Filters: > > Bibliographic Record -> Record Creation Date/Time (Date) (Between) > Bibliographic Record -> Is Active? (Equals) (True) > Bibliographic Record -> Is Deleted? (Equals) (False) > Bibliographic Record -> Call Numbers -> Copies -> Copy ID (Is NULL) > > Please let me know if there's anything confusing about my notations. > > Note that this approach makes sorting by spreadsheet unnecessary - it should > only show bibs without copies attached. > > Hope that helps! > > Chris > > ----- Original Message ----- > > From: "Rita Liu" <[email protected]> > > To: [email protected] > > Sent: Friday, April 24, 2015 6:00:36 PM > > Subject: [OPEN-ILS-GENERAL] Bib records without item attached report > > template > > > > Good evening, > > > > Sometimes our staff forgot to add an item (item barcode) when they create a > > new bib record, I would like to get a list of bib records without item > > attached and also display cataloguer's login ID for them to fix the record. > > > > I tried to create a report template to list bib record TCN value, OPAC > > Staff > > Client username and filter by Record creation date, however when I tried to > > have the report also list the Bib record's item barcode, it failed. > > > > Is there a way to link Bib and Item in the Report Source? > > > > Here is my current report template source: > > Display field: > > Bib record: Simple Record Extracts: TCN value > > Bib record: Record Creator : OPAC Staff Client Username > > Filter field: > > Bib record: Record Creator : Record creation date > > Also set report template default filter for active and non-deleted records. > > > > For Item level, I put Bib Record - Call Number :: Copies - barcode in the > > display field, however it didn't list any of the barcode attached with bib > > record from the report output, I thought if the report result displays bib > > records having the item barcode attached or no item barcode attached, I can > > easily sort the final report to get those empty barcode lines in Excel and > > get the bib TCN value and OPAC Staff client Username to fix the record. > > > > Thanks, > > > > > > Rita Liu > > Statistics Canada | 100 Tunney's Pasture Driveway, Ottawa ON K1A 0T6 > > Statistique Canada | 100, promenade Tunney's Pasture, Ottawa ON K1A 0T6 > > [email protected] > > Telephone | Téléphone 613-850-6587 > > Facsimile | Télécopieur 613-951-0939 > > Government of Canada | Gouvernement du Canada > > > > > > > > > > -- > Chris Sharp > PINES System Administrator > Georgia Public Library Service > 1800 Century Place, Suite 150 > Atlanta, Georgia 30345 > (404) 235-7147 > [email protected] > http://pines.georgialibraries.org/ > -- Chris Sharp PINES System Administrator Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 [email protected] http://pines.georgialibraries.org/
