Angular Catalog view holds - sort by Status, CN Suffix, and CN Prefix results in an error

Bug #1929565 reported by Garry Collum
50
This bug affects 9 people
Affects Status Importance Assigned to Milestone
Evergreen
Confirmed
Medium
Unassigned

Bug Description

Similar to https://bugs.launchpad.net/evergreen/+bug/1928684. In 3.6.3 and current master, when trying to sort the Status, CN Prefix, or CN Suffix columns in Staff Catalog Search > View Holds an error of "Error Retrieving Results" is displayed.

Also the CN Prefix and CN Suffix data does not display in the table. The easiest way to verify this is to add a prefix and suffix to the call number of a copy and place a copy specific hold.

Revision history for this message
Michele Morgan (mmorgan) wrote :

Marking Confirmed, also observed in a 3.6.1 production system.

- Sorting the grid by Status (hold status) results in "Error Retrieving Results"
- CN Prefix column contains no data
- CN Suffix column contains no data

tags: added: eg-grid
Changed in evergreen:
status: New → Confirmed
Revision history for this message
Michele Morgan (mmorgan) wrote :

Transcribing Steve Callender's comments from duplicate bug 1937436:

"The issue looks to be caused by trying to order by "status_string" in the code.

no_tz.open-ils.storage.action.live_holds.wide_hash: DBD::Pg::st execute failed: ERROR: column "status_string" does not exist
LINE 222: ...78$,$_15178$2$_15178$,$_15178$4$_15178$) ORDER BY status_str...
                                                               ^ [for Statement "WITH
    t_field AS (SELECT field FROM config.display_field_map WHERE name = 'title'),
    a_field AS (SELECT field FROM config.display_field_map WHERE name = 'author')
SELECT h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time,
        h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause,
        h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib,
        h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib,
        h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify,
        (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,
        h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, h.hopeless_date,

        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"

tags: added: circ-holds
removed: holds
tags: added: sorting
Changed in evergreen:
importance: Undecided → Medium
Revision history for this message
John Amundson (jamundson) wrote :

Noting that in 3.7.2, I do not see an error when trying to sort by these three columns, but clicking the headers do not change the sort order of the displayed list at all.

Michele Morgan (mmorgan)
tags: added: staffcatalogblocker
Revision history for this message
Chrisy Schroth (cschroth) wrote :

Using 3-9-4 sorting by Status still brings up Error Retrieving Results. Sorting by CN Prefix did work. If the record had 2 different prefixes it did re-order the results. If all items had the same prefix it did not change the order of the holding patrons when sorting by CN Prefix.

Revision history for this message
Andrea Neiman (aneiman) wrote :

Confirmed still an issue in 3.11.1 with Status sort

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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