Uploaded image for project: 'mod-data-export-worker'
  1. mod-data-export-worker
  2. MODEXPW-295

"Titles" are missed in exported ".csv" when applying sort to "Package"

    XMLWordPrintable

Details

    • Spitfire Sprint 152
    • 0
    • Spitfire
    • Nolana (R3 2022) Bug Fix
    • Implementation coding issue

    Description

      Overview: the rows with "Titles" were missed in the exported ".csv" file when sorting was applied to the list of "Titles" records under the "Titles" accordion in the opened "Package" record. The number of exported "Titles" doesn't match the "Records found" counter under "Titles" accordion.
      Steps to Reproduce:
      Scenario 1 (original issue):

      1. Log into Snapshot FOLIO environment as User with the following permissions:
        Export manager: All
        eHoldings: Can view providers, packages, titles detail records
        Notes: Can view a note
        Agreements: Search & view agreements
      2. Open the following "Package" record:  "/eholdings/packages/125531-2631932"
      3. Scroll down to the "Titles" accordion and click on the "magnifying glass" icon.
      4. Filter titles, to get less than 10k of "Titles" (e.g. "Asia")
      5. Click on the "Actions">>"Export package (CSV)"
      6. Click on the radio button placed next to the multiselect element "Package fields to export"
      7. Click on the "Export" button.
      8. Go to the "Export manager" app.
      9. After the export job finishes with successful status, click on the "Job ID" column value.

      Expected Results: The number of exported "Titles" records (rows) is equal to the "Records found" counter under "Titles" accordion in "Package" record.
      Actual Results: The number of exported "Titles" records (rows) is less than the "Records found" counter under "Titles" accordion in "Package" record.

      Scenario 2 (to check potential issue about missing rows with same "Title name" column values in exported "Package" record):

      1. Log into Snapshot FOLIO environment as User with the following permissions:
        Export manager: All
        eHoldings: Can view providers, packages, titles detail records
        Notes: Can view a note
        Agreements: Search & view agreements
      2. Open the following "Package" record:  "/eholdings/packages/617-4377"
      3. Click on the "Actions">>"Export package (CSV)"
      4. Click on the "Export" button.
      5. Go to the "Export manager" app.
      6. After the export job finishes with successful status, click on the "Job ID" column value.

      Expected Results: The number of exported "Titles" records (rows) is equal to the "Records found" counter under "Titles" accordion in "Package" record. All rows with "Title+Package" information are filled.
      Actual Results: The number of exported "Titles" records (rows) is less than the "Records found" counter under "Titles" accordion in "Package" record. The one row (the last one) with "Title+Package" information is missed in downloaded ".csv" file.

       

      Scenario 3 (to check potential issue about missing rows with same "Title name" column values in exported "Package" record):

      1. Log into Snapshot FOLIO environment as User with the following permissions:
        Export manager: All
        eHoldings: Can view providers, packages, titles detail records
        Notes: Can view a note
        Agreements: Search & view agreements
      2. Open the following "Package" record:  "/eholdings/packages/22-2163800"
      3. Click on the "Actions">>"Export package (CSV)"
      4. Click on the "Export" button.
      5. Go to the "Export manager" app.
      6. After the export job finishes with successful status, click on the "Job ID" column value.

      Expected Results: The number of exported "Titles" records (rows) is equal to the "Records found" counter under "Titles" accordion in "Package" record. All rows with "Title+Package" information are filled.
      Actual Results: The number of exported "Titles" records (rows) is less than the "Records found" counter under "Titles" accordion in "Package" record. The one row with "Title+Package" information is missed in downloaded ".csv" file.

      Additional Information: See attached screenshots.
      Note: reproducible when filter applied found not less than 1k records.
      Interested parties: viacheslav_kolesnyk , maryna_steshenko , kgambrell 

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                viacheslav_kolesnyk Viacheslav Kolesnyk
                valpil Valery Pilko
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases