Details
-
Story
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
-
ACQ Sprint 87, ACQ Sprint 88
-
2
-
Thunderjet
Description
Overview
In order to support filtering titles by information in the associated piece record, we need to add a titleId field to the piece schema and create a foreign key.
The end result is that we should be able to execute queries like:
GET /orders/titles?query=pieces.receivingStatus=Expected
The new field should be required.
Data Migration
- migration scripts need to be updated to include this new field in pieces as it's required.
Acceptance Criteria
- the piece schema/example have been updated
- schema.json has been updated to include foreign key
- sample data is updated
- mod-orders acq-models submodule is updated
- migration scripts are updated
TestRail: Results
Attachments
Issue Links
- has to be done before
-
UIOR-774 Use mod-orders for piece queries
-
- Closed
-
-
UIREC-42 Filter Titles by piece status and Acq unit
-
- Closed
-
-
UIREC-55 Receive title - use mod-orders for piece queries
-
- Closed
-
-
UISACQCOMP-46 Use mod-orders for piece queries
-
- Closed
-
- has to be finished together with
-
MODORDERS-390 Populate titleId during piece creation
-
- Closed
-
- is blocked by
-
MODORDSTOR-148 Delete sample data for open and closed orders
-
- Closed
-
- relates to
-
MODORDSTOR-136 Title, PoLine schema updates
-
- Closed
-
-
UXPROD-2294 Check-in and Receiving updates and fixes
-
- Closed
-