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/
