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

[Chris Sharp]

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/