Sorting of "Notes" in exported ".csv" file is different at "Snapshot" and "Nolana BF" environments

Description

Overview: For some reason, at "Snapshot" environment "Notes" in exported ".csv" file are sorted the same way as in the "UI" (by relevance).
But at "Nolana BF" environment "Notes" in exported ".csv" file are sorted randomly (looks like).
Steps to Reproduce:

  1. Log into Snapshot / Nolana BF FOLIO environment as User with the following permissions:
    Agreements: Search & view agreements
    eHoldings: Can view providers, packages, titles detail records
    Export manager: All
    Notes: Can assign and unassign a note
    Notes: Can create a note
    Notes: Can view a note

  2. Go to the "Title+Package": "/eholdings/resources/58-2476-3154".

  3. Create 10 "Notes" record with
    "Note type"="General note".
    "Note title*"=any unique name with index (n+1).
    "Details"="Test"

  4. Export "Title+Package" by clicking on the "Actions">>"Export title package (CSV)">>"Export".

  5. Go to "Export manager" app and download the exported ".csv" file.

Expected Results: "Notes" in downloaded ".csv" file is sorted by last updated in descending order.
Actual Results: At "Snapshot" environment: "Notes" in exported ".csv" are sorted by relevance (I guess).
At "Nolana BF" environment: "Notes" in exported ".csv" are sorted randomly.
Additional Information: see attached screencast.
Example of expected sorting of "Notes" records:
1) The User creates the "Notes" in some "Package"/"Title+Package" record in the following order:
first - Note 1
second - Note 2
third - Note 3
On UI it will look like (see screenshot):

2) In exported ".csv" file the "Note" records will look like as at screenshot:

Interested parties: ,  

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

6

Checklist

hide

TestRail: Results

Activity

Show:

Valery_Pilko March 9, 2023 at 4:58 PM

Verified on Orchid Bugfest environment - works as expected.
See attached screenshot: 

JenkinsNotifications March 7, 2023 at 8:56 PM

Deployed to Orchid bf env. Moved status to In bugfix review from status Awaiting deployment. Please proceed with verification

Pavlo Smahin March 6, 2023 at 1:55 PM

Yes, we can

Khalilah Gambrell March 6, 2023 at 12:45 PM
Edited

Hey and   - can we move this to Orchid bugfix release?

Yauhen Viazau March 6, 2023 at 7:59 AM

Verified on Snapsjot-1 env - works as expected

Please see attached screencasts:

  •  

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Orchid (R1 2023) Bug Fix

RCA Group

Lack of testing

Affected releases

Nolana (R3 2022)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created November 11, 2022 at 6:49 PM
Updated March 26, 2023 at 11:06 PM
Resolved March 6, 2023 at 6:03 PM
TestRail: Cases
TestRail: Runs