Hold Request -> Cancelation cause reports link is broken when creating templates
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
New
|
Undecided
|
Unassigned |
Bug Description
When trying to get information related to bug 1963541, PINES staff discovered that the linkage between action.hold_request and action.
=======
SELECT ahr."cancel_time" AS "Hold Cancel Date/Time",
FROM action.hold_request AS ahr
LEFT OUTER JOIN action.
INNER JOIN actor.usr AS ahr_usr ON (ahr."usr" = ahr_usr."id")
INNER JOIN actor.card AS ahr_usr_card ON (ahr_usr."card" = ahr_usr_card."id")
LEFT OUTER JOIN reporter.
LEFT OUTER JOIN biblio.record_entry AS bre ON (rhrr."bib_record" = bre."id")
WHERE date(ahr.
GROUP BY 1, 2, 3, 4, 5
ORDER BY ahr."cancel_time" ASC, cancel_
=======
(ahr."id" = cancel_cause."id") should be (ahr."cancel_cause" = cancel_cause."id")
Evergreen 3.8
Looks like this is still an issue in 3.11. You can't report on the cancel cause label because the linkage is broken.