Dasun Pubudumal

# Achieving the use-case through sequencescape ## Approach I: Create a new table for retention instructions ### New tasks required 1. **Prepare `retention_instructions` to be stored in a separate table...

Hi @KatyTaylor, thanks for the quick response! > Is the 'events' table linked to the Events Warehouse? Specifically, is it going to create an unintended event in the warehouse if...

Hi @KatyTaylor, > If we do move where retention instructions are stored, it's worth putting an acceptance criteria to search the codebase for places that retrieve it. e.g. `def obtain_retention_instructions`...

Cool. So our current options are as follows: 1. Keep the existing structure where retention instructions are stored in `custom_metadata`, and use the `events` table for audits. Permissions are controlled...

@KatyTaylor I updated the description :)

**A note about existing labware that has retention instructions stored in `custom_metadata`** - **In perspective of the Asset Summary**: When displaying the asset summary (see the screenshot below), the sequence...

Dual Passwords for MySQL Reference: [MySQL 8.3 Reference](https://dev.mysql.com/doc/refman/8.3/en/password-management.html#:~:text=passwords%20to%20it.-,Dual%20Password%20Support,MySQL%20servers%2C%20possibly%20involving%20replication.)

The following procedure could be carried out for testing dual password feature (source referenced in https://github.com/sanger/sequencescape/issues/4043#issuecomment-2051656462) in a local MySQL 8.x database. **Note:** Creating the user and updating grants are...

Identified that the following databases are in the host `psdp-db`: ``` barcode_warehouse dba delegated_user_management labwhere_production mixtio_production mmonit_production monitoring print_my_barcode_production process_tracking_production samples_extraction_production sequencescape_production sequencescape_production_archive sm_workflow_lims_production sys traction_production traction_service_production util ``` The...

[credentials](https://gitlab.internal.sanger.ac.uk/psd/credentials) project was updated with the latest KeePassXC database, with the new password for `psdp` user in `psdp-db`. The grace period for switching off the old password begins today, and...