Y25-121 - As a Project Manager (Laura H) I would like to add two new columns to the seqops_tracking_per_sample table, library_type_ordered and project_name from the order_made event so that we can improve our financial planning. #45
Description
User story
As a Project Manager (Laura H) I would like to add two new columns to the seqops_tracking_per_sample table, library_type_ordered and project_name from the order_made event so that we can improve our financial planning.
Who are the primary contacts for this story
Tom W
Ya-Lin H
Laura H
Michael F (finance)
Who is the nominated tester for UAT
Testing can be performed by the development team - see acceptance criteria.
Acceptance Criteria
- A new longtext column before 'libary_type' called 'library_type_ordered' is added to the table.
- 'library_type_ordered' is populated by a distinct concatenation of values from the library_type metadata key/value pair on the order_made event
- A new longtext column before sequencing_cost_code called 'project_name' is added to the table.
- project_name is populated by a distinct concatenation of values from the 'project' role/subject data associated with the order_made event.
- The output of the new query minus the 2 new columns is identical to the output of the old query.
- The Confluence page "Sample Tracking. Report" is updated with new columns and restrictions.
Background
The logic for these extra columns has already been added to the seqops_tracking_per_plate table in #42