reporter.simple_record needs to add the RDA publisher and publisher date tags

Bug #1368314 reported by Dale Rigney
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Medium
Unassigned
2.5
Fix Released
Undecided
Unassigned
2.6
Fix Released
Undecided
Unassigned

Bug Description

The reporter.simple_record should include the new RDA publisher tag (tag = '264' AND ind2 = '1' AND subfield = 'b') and publish date tag (tag = '264' AND ind2 = '1' AND subfield = 'c').

The reporter.old_super_simple_record view has already been updated with these two lines:

LEFT JOIN metabib.full_rec publisher ON (r.id = publisher.record AND (publisher.tag = '260' OR (publisher.tag = '264' AND publisher.ind2 = '1')) AND publisher.subfield = 'b')
LEFT JOIN metabib.full_rec pubdate ON (r.id = pubdate.record AND (pubdate.tag = '260' OR (pubdate.tag = '264' AND pubdate.ind2 = '1')) AND pubdate.subfield = 'c')

If the reporter.simple_record view would replace the following two lines with the lines above that should fix the issue:

LEFT JOIN metabib.full_rec publisher ON (r.id = publisher.record AND publisher.tag = '260' AND publisher.subfield = 'b')
LEFT JOIN metabib.full_rec pubdate ON (r.id = pubdate.record AND pubdate.tag = '260' AND pubdate.subfield = 'c')

description: updated
Revision history for this message
Chris Sharp (chrissharp123) wrote :
Changed in evergreen:
status: New → In Progress
importance: Undecided → Medium
assignee: nobody → Chris Sharp (chrissharp123)
milestone: none → 2.7.1
tags: added: pullrequest reports
Revision history for this message
Ben Shum (bshum) wrote :

Looks good to me. Thanks Chris!

Picked to master and backported to rel_2_7, rel_2_6, and rel_2_5.

Changed in evergreen:
status: In Progress → Fix Committed
assignee: Chris Sharp (chrissharp123) → nobody
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.