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

    • Template:
    • Sprint:
      Folijet Sprint 106
    • Story Points:
      5
    • Development Team:
      Folijet
    • Release:
      R1 2021
    • Affected Institution:
      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

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases