Issues

Select view

Select search mode

 
25 of 25

Enhance "GET /authority-storage/authorities" endpoint for filter handling

Done

Description

Overview:

This story focuses on enhancing the "GET /authority-storage/authorities" endpoint within the mod-entities-links module to effectively handle filters for authority retrieval. Filters include source file, headings type, date created, and date updated. Necessary indices will be added to optimize query performance.

Requirements/Scope:

  1. Ensure the "GET /authority-storage/authorities" endpoint can handle filters for source file, headings type, date created, and date updated.

  2. Add the required indices to optimize query performance.

  3. Update the documentation to reflect the changes related to filter handling.

Approach:

  1. Enhance the endpoint to support various filters for authority retrieval.

  2. Add the necessary indices to optimize query performance for the archive table.

  3. Implement the logic for proper filter handling.

  4. Update the documentation to inform users about the enhancements (add section CQL support).

Acceptance Criteria:

  • The "GET /authority-storage/authorities" endpoint can effectively handle filters for source file, headings type, date created, and date updated.

  • The documentation is updated to reflect the changes in filter handling.

  • Covered by unit and integration tests.

Environment

None

Potential Workaround

None

CSP Request Details

None

CSP Rejection Details

None

Attachments

10

Checklist

hide

TestRail: Results

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Quesnelia (R1 2024)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created October 24, 2023 at 9:15 AM
Updated February 16, 2024 at 6:56 AM
Resolved January 17, 2024 at 3:22 PM

Activity

Show:

Mukhiddin YusupovJanuary 12, 2024 at 11:42 AM

Separate ticket - MODELINKS-190 was created to handle the cases 4 and 6 as they require some additional work in order to have support of such filtering through CQL

cc  

Valery_PilkoJanuary 11, 2024 at 2:47 PM
Edited

Tested on Snapshot environment, see Passed/Failed tests below:
1) Filter by heading type - Passed

2) Filter by created date - Passed

3) Filter by authority source file name - Passed for default and local

4) Filter by authority source file name (Not specified) - Failed

5) Filter by authority source file Id - Passed for default and local

6) Filter by authority source file Id (Not specified) - Failed

7) Filter by combination - Passed

8) Filter by Updated Date - Passed

See attached screencast:

9) Issue:
-"500" error returns when user sends invalid query - "4xx" should be returned-

UPD: fixed, see attached screenshot:

TestRail: Cases
TestRail: Runs