Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-203

SRS revision: Default order by on paging APIs to an appropriate indexed field

    XMLWordPrintable

Details

    • Folijet Sprint 106
    • 5
    • Folijet
    • R1 2021
    • TAMU

    Description

      Default order by on paging APIs to an appropriate indexed field

      NOTE: This is based on William Welling's analysis of SRS changes that would be helpful for initial data migration. Several other issues linked to the same feature as this one

      When making requests for source records, records, or snapshots with limit and offset and order by is not provided, it should default to id or another appropriate indexed column. Otherwise, the results will be unpredictable. https://www.postgresql.org/docs/9.3/queries-limit.html

      Possibly here, https://github.com/folio-org/mod-source-record-storage/blob/master/mod-source-record-storage-server/src/main/java/org/folio/dao/util/RecordDaoUtil.java#L488 for source records and records.

      And here, https://github.com/folio-org/mod-source-record-storage/blob/master/mod-source-record-storage-server/src/main/java/org/folio/dao/util/SnapshotDaoUtil.java#L292 for snapshots.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                wwelling William Welling
                abreaux Ann-Marie Breaux
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases