86 pagination

Created by: ri-pandey

Description

• Added pagination to Dataset table (Raw Data/Data Product) pages.
• Pagination works using OFFSET and LIMIT clauses in the SQL.
• Pagination respects any search/filter/sort criteria specified. Results are fetches in batches based on the criteria specified.

Related Issue(s)

Closes #86 (closed)

Changes Made

• Feature added
• Code refactored
• Documentation updated
• Other changes:
• Modified HTTP endpoint used for retrieving datasets to enable sorting/searching/filtering queries to be run across the entire Dataset table, and to limit and offset the datasets retrieved. All new criteria are optional. Also added ability to sort by fields in the metadata column, with some reasonable defaults.
• Disabled sorting on 'Archived' and 'Staged' fields, and made those filters instead.

Checklist

Before submitting this PR, please make sure that:

• Your code passes linting and coding style checks.
• Documentation has been updated to reflect the changes.
• You have reviewed your own code and resolved any merge conflicts.
• You have requested a review from at least one team member.
• Any relevant issue(s) have been linked to this PR.