Sorting holds by status from bib record gives an error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
I've tested this in a handful up updated 3.6 Evergreen systems,
When view a bib record and selecting the "View Holds" option, you cannot sort by the hold status. The screen returns an error.
"Error Retrieving Results"
The issue looks to be caused by trying to order by "status_string" in the code.
no_tz.open-
LINE 222: ...78$,
t_field AS (SELECT field FROM config.
a_field AS (SELECT field FROM config.
SELECT h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time,
(SELECT name FROM config.sms_carrier WHERE id = h.sms_carrier) AS "sms_carrier",
h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition,
CASE WHEN h.cancel_time IS NOT NULL THEN 6
WHEN h.frozen AND h.capture_time IS NULL THEN 7
WHEN h.current_shelf_lib IS NOT NULL AND h.current_shelf_lib <> h.pickup_lib THEN 8
WHEN h.fulfillment_time IS NOT NULL THEN 9
WHEN h.current_copy IS NULL THEN 1
WHEN h.capture_time
Changed in evergreen: | |
status: | New → Confirmed |
Marking this as a duplicate of bug 1929565