Use == not = for userId manualblocks lookup

Description

Use the field match == operator, not the word match = operator when looking up menualblocks for a userId:

https://dev.folio.org/faqs/explain-cql/
Only the field match == operator has a database index:
https://github.com/folio-org/mod-feesfines/blame/v18.1.1/src/main/resources/templates/db_scripts/schema.json#L94-L104
Using the word match = operator results in a full table scan with bad performance when the the manualblocks table gets bigger.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:
Done

Details

Assignee

Reporter

Priority

Development Team

EBSCO - FSE

RCA Group

Data related (ex. Can be detected with large dataset only)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created November 22, 2022 at 12:29 PM
Updated November 22, 2022 at 1:58 PM
Resolved November 22, 2022 at 1:58 PM
TestRail: Cases
TestRail: Runs