Details
-
Type:
Story
-
Status: Closed (View Workflow)
-
Priority:
P3
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: 13.0.4
-
Labels:
-
Template:
-
Sprint:ACQ Sprint 127
-
Story Points:0
-
Development Team:Thunderjet
-
Release:R2 2021 Hot Fix #4
-
Hot Fix Approved by Cap Planning?:Yes
-
Hot Fix Approval Comments:
-
Epic Link:
-
RCA Group:Not a bug
Description
Purpose/Overview:
In order to speedup searching of polines via GET /orders/order-lines database indexes should be added.
Following warnings found in logs:
WARNING: Doing FT search without index for po_line.jsonb->'vendorDetail'->>'referenceNumbers', CQL >>> SQL: vendorDetail.referenceNumbers = testRefNumber >>> get_tsvector(f_unaccent(po_line.jsonb->'vendorDetail'->>'referenceNumbers')) @@ tsquery_phrase(f_unaccent('testRefNumber'))
WARNING: Doing LIKE search without index for acquisitions_unit.jsonb->>'isDeleted', CQL >>> SQL: isDeleted == false >>> lower(f_unaccent(acquisitions_unit.jsonb->>'isDeleted')) LIKE lower(f_unaccent('false'))
WARNING: Doing LIKE search without index for acquisitions_unit.jsonb->>'protectRead', CQL >>> SQL: protectRead == false >>> lower(f_unaccent(acquisitions_unit.jsonb->>'protectRead')) LIKE lower(f_unaccent('false'))
WARNING: Doing FT search without index for purchase_order.jsonb->>'acqUnitIds', CQL >>> SQL: purchaseOrder.acqUnitIds = 0ebb1f7d-983f-3026-8a4c-5318e0ebc041 >>> get_tsvector(f_unaccent(purchase_order.jsonb->>'acqUnitIds')) @@ tsquery_phrase(f_unaccent('0ebb1f7d-983f-3026-8a4c-5318e0ebc041'))
Acceptance criteria:
- Indexes added
- No warnings present while invoking following requests:
/orders-storage/po-lines?query=vendorDetail.referenceNumbers=("testRefNumber")
/orders-storage/po-lines?query=purchaseOrder.acqUnitIds=(0ebb1f7d-983f-3026-8a4c-5318e0ebc041 OR d669b8cb-4b94-4193-a0f2-b77e8b77b2e6 )
TestRail: Results
Attachments
Issue Links
- blocks
-
MODORDSTOR-260 MODORDSTOR (mod-orders-storage) R2 2021 Hotfix release
-
- Closed
-
- clones
-
MODORDSTOR-255 Kiwi - Add indexes to improve searching speed of polines
-
- Closed
-
- relates to
-
MODINVOICE-318 Creating multiple large invoices quickly from Data Import failed (JUNIPER HF)
-
- Closed
-
-
MODINVOICE-333 Creating multiple invoice lines per invoice fails - Juniper HF #4(Harrassowitz Chicago)
-
- Closed
-