[OPEN-ILS-GENERAL] Bib records without item attached report template

[Chris Sharp]

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" <csharp at georgialibraries.org>
> To: "Evergreen Discussion Group" <open-ils-general at list.georgialibraries.org>
> 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" <Rita.Liu at statcan.gc.ca>
> > To: open-ils-general at list.georgialibraries.org
> > 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
> > Rita.Liu at statcan.gc.ca
> > 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
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/
> 

-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/