Film Expiration Search

[arthur-aguilera]

• [ ] Create Wiki Page for Report
• [ ] Add Wiki Page to Current Reports Directory
• [ ] Identify Fields Needed for Report
• [ ] Check FOLIO Analytics for exisiting reports or tables
• [ ] Check Cornell's Reports for exisiting reports or tables
• [ ] Build Query
• [ ] Query Needs Reviewed
• [ ] Add Query + ReadMe to Library Report github
• [ ] Update Wiki with "How to Run"

Swank Expiration Dates: BIBLIOGRAPHIC MARC Tag 001 starts with "swv" AND BIBLIOGRAPHIC MARC Tag 506 ends with (exact) "4/30/2022"

Kanopy Expiration Dates: BIBLIOGRAPHIC MARC Tag 001 starts with (exact) "kan" AND BIBLIOGRAPHIC MARC Tag 001 All Fields don't have "kano" AND BIBLIOGRAPHIC BCODE3 equal to "z" AND BIBLIOGRAPHIC MARC Tag 956 has "kanopy" AND BIBLIOGRAPHIC MARC Tag 506 has "expires: 5/" AND BIBLIOGRAPHIC MARC Tag 506 ends with "2022"

• [x] Verify if 001 and 506 tags can be queried directly within Folio
• [x] Verify how the 001 field is mapped to instance records
• [ ] Verify how the 506 field is mapped to instance records.
• [ ] Verify with Melanie which data fields need to be exported or have her share her process for what she uses this query for

Within Inventory App, you can search all records beginning with swv by searching "swv*" in the HRID field. Still exploring how to limit this by the 506 field.

LDP App - MARC searching is supporting through the LDP App but the search strings have to be exact. You can't (so far) search a field that starts or contains a string.

[steveellis]

See #55.

[steveellis]

@arthur-aguilera would be great if you could add a sentence or two about the report description and maybe name.

[steveellis]

What 506 is: https://www.loc.gov/marc/bibliographic/concise/bd506.html

[arthur-aguilera]

Changed title "Film Expiration Search" and will add #50 to this and close out that ticket.

[steveellis]

https://github.com/culibraries/folio/issues/264

[steveellis]

We identified a few places where notes fields (500) are available in FOLIO. Here's a screenshot for example:

Also 506 is being included in our data migration:

• https://docs.google.com/spreadsheets/d/1zW8Z4dry6uYd1gmcsWGoVVDHKwqLQrKef-tF_XtczCI/edit#gid=0
• https://docs.google.com/spreadsheets/d/11lGBiPoetHuC3u-onVVLN4Mj5KtVHqJaQe4RqCxgGzo/edit#gid=2007644603

[blocke1]

@arthur-aguilera I have been trying to work on this but am doing something wrong. I can get both parts of these to work individually but not together:

select instance_id from folio_source_record.marc__t as marc where (marc.field = '035' and marc.sf = 'a' and marc.content like '%kan%') intersect (select instance_id from folio_source_record.marc__t as marc2 where (marc2.field = '506' and marc2.sf = 'b' and marc2.content like '%expires%'))