Y24-239 As a CASM Project Mgr (LH) I would like the bait capture library name to be displayed on the Sample Tracking Report so that we can analyse the results quickly.

[TWJW-SANGER]

As a CASM Project Mgr (LH) I would like the bait capture library name to be displayed on the Sample Tracking Report so that we can analyse the results quickly.

Additional Context Bait libraries are selected and entered into SequenceScape when making a sequencing request.

The bait ids are stored in the iseq_flowcell table bait_name column.

Therefore these bait ids will need aggregating when displaying on a stock plate per row basis as in the Sample Tracking View. I would suggests starting with a distinct concatenation along the lines of the other aggregated columns.

There may be no or NULL bait library.

Acceptance Criteria

• [ ] An additional column "bait_names" in sample_tracking_view in the mlwh_reportign database is added to the right of the view to avoid breaking query logic.
• [ ] The Tableau view has an additional column "bait_names" added to the right of the report displaying result from the database view.

[khelwood]

@TWJW-SANGER What is the "query logic" that requires new columns to be added to the right of existing columns in the SQL view?