| Page Properties |
|---|
| Submitted | |
|---|
| Approved |
|
|---|
| Status | DRAFT |
|---|
| Impact | MEDIUM |
|---|
|
Context
Tracking
| Type | Ticket | Module |
|---|
| Module ticket | | Jira Legacy |
|---|
| server | System Jira |
|---|
| serverId | 01505d01-b853-3c2e-90f1-ee9b165564fc |
|---|
| key | MODAUD-155 |
|---|
|
| mod-audit |
| Arch ticket | | Jira Legacy |
|---|
| server | System Jira |
|---|
| serverId | 01505d01-b853-3c2e-90f1-ee9b165564fc |
|---|
| key | ARCH-51 |
|---|
|
|
|
Technical details
The circulation log data is persisted in jsonb format in FOLIO database and itemBarcode field is part of the nested array items as each circulation log record can contain multiple items. No indexes are present for the table.
...
Option C - add index for creation date and limit search date range
Questions
| # | Question | Answer | Status |
|---|
| 1 | How many records per year clients produce? |
| |
| 2 | Do clients have any retention policy or regulations on circulation records? |
| |
Rationale
Option A depends on client needs.
...