Sorting on the Instance's Holdings item table is not working (Orchid CSP)

Description

Overview:

Sorting on the item table is not working.
Steps to Reproduce:

  1. Log into some FOLIO environment as User with inventory permissions

  2. Open the inventory app and search for a title, containing a holding record with more then one item on a holding; example The ... annual Iowa year book of agriculture /issued by the Iowa Department of Agriculture. HRID: in1354864

  3. Expand the holdings accordion.

  4. Click on any of the table headers; Enumeration would be a better example

Expected Results:

 - The column header should have a chevron happened to ti and the column contents be sorted DESC.
Actual Results:

 

When the column headers are clicked the only call made is for the chevron, there are no additional API calls made. There are not errors in the JS console and there seems to be no click event registered. All logging was enabled in the JS console at the time of testing, tests where original performed on or production env at Cornell Orchid-sp-4 and confirmed in bugfest. 

Screen shots and logs are from bugfest.

Interested parties:

ORCHID Critical service patch details

  1. Describe issue impact on business: Fixes a regression that was introduced in an earlier Orchid CSP (by a different dev team) where sorting in the item record table under the holdings, in the instance detail record, stopped working. When there are large numbers of item records associated with a holdings, the lack of sorting makes it difficult for production libraries to identify specific item records that need attention.

  2. What institutions are affected? (field “Affected Institutions” in Jira to be populated) - All that have large numbers of item records associated with specific items

  3. What is the workaround if exists? No user workaround, other than paging through many, many pages of item records, which is very time-consuming

  4. What areas will be impacted by fix (i.e. what areas need to be retested) Inventory Smoke and Critical Path automated tests

  5. Brief explanation of technical implementation and the level of effort (in workdays) and technical risk (low/medium/high).

    • Work is complete and the level of effort was minimal, though disruptive to have to attend to this unexpected regression. 

    • Use sorted records array instead of initial items prop

    • Risk to backport: Minimal

  6. Brief explanation of testing required and level of effort (in workdays). Provide test plan agreed with by QA Manager and PO. Automated and manual test cases already exist and level of effort is 1/2 hour

  7. What is the roll back plan in case the fix does not work? Revert to previous version

CSP Request Details

Orchid CSP requested 1 Sept 2023 on Slack. Approved 5 Sept by Kristin, Lee, Debra, Khalilah, MDG

CSP Rejection Details

None

Potential Workaround

none

Attachments

11

blocks

requires

Checklist

hide

TestRail: Results

Activity

Show:

Maksym Ishchenko September 25, 2023 at 8:48 AM

Hello  

Ticket verified on Orchid BF. Sorting is done using column "Barcode" and "Enumeration" for Instance with HRID in1354864. Sorting is working. Please doublecheck and close the ticket if it looks good to you

Oleksii Petrenko September 25, 2023 at 8:16 AM

Deployed to Orchid BF.

Please proceed with verification.

Ann-Marie Breaux September 12, 2023 at 8:26 PM

Hi This has become the Orchid CSP 6 issue. Clone for Poppy is

Sobha Duvvuri September 6, 2023 at 2:08 AM

: Since this issue is targeted for Poppy and there should be corresponding tickets for Orchid-SP, could you please give us those links to the JIRAs so we could watch them for fix versions? Thanks!

Ann-Marie Breaux September 1, 2023 at 2:43 PM

Thanks, I'll create a BE ticket, and we'll need to pull into a sprint ASAP, since this needs to be an Orchid CSP.

yesterday we discovered that we partially fixed the item sorting, but not if there are more than 200 items (so more than 1 page of items). We'll dig into it more next week, but looks like we'll need a backend fix as well as the frontend fix.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Folijet

Fix versions

Release

Orchid (R1 2023) Service Patch #6

CSP Approved

Yes

RCA Group

Legitimate regression

Affected releases

Poppy (R2 2023)
Orchid (R1 2023)

Affected Institution

!!!ALL!!!

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created August 11, 2023 at 1:13 PM
Updated September 29, 2023 at 4:23 PM
Resolved August 28, 2023 at 7:15 AM
TestRail: Cases
TestRail: Runs