DAL Version v2.7.6

Version 2.7.7
Date: 27/05/2025
Description: Bug Fixing Patch and Improvements

• Upgrade deployment scripts added for Debian 11.

• New end point to return trial unit specimens for Genotype .

• New end point to return summarised data for Genotype.

• New end point to return summarised data CSV for a trial.

• New end point to return Genotypes present in a trial.

• New end point assist searching Genotype, Specimen and Item tables.

• Fix to v2.7.0 deployment script.

DAL Version v2.7.6

Version 2.7.6
Date: 29/05/2023
Description: Bug Fixing Patch and Improvements

• New import/extract/csv endpoint that will allow for extracts to be imported without plates.

• Deployment scripts added for Debian 11.

• Configuration support added for OpenID authentication model. A key change is that now the session name is now defined by configuration, rather than hard coded as it was previously.

• Wider activity logging based on configuration.

• Fixing issue with user directory not being created correctly with wrong permission settings.

• Fixed issue with Adding Taxonomy without parent.

• Fixed issue with List Survey Trial unit related to locations and inclusion of Trial unit Specimens.

• Updated import sample measurements to be more strict when involved with Surveys to ensure that the Trial Unit is attached to Survey given.

• Updates to list trial unit specimen to include more information from Specimen table.

• Fix to v2.6.0 to v2.7.0 upgrade script

Instance Testing

• Tests have been reorganised in folders for more convenient access.

• Tests updated to test_order_all.txt. The number of tests that can be run at the start of deploy remains 482. VCol realted test remain at 47.

DAL version v2.7.5

Version 2.7.5
Date: 10/10/2023
Description: Bug Fixing Patch and Improvements

• Item Measurements and Item Measurement Group related endpoints added

• Crossing Measurement and Crossing Measurement Group related endpoints added

• Virtual Column validation added for all Core module objects that support virtual columns. They are: organisation, contact, site, trial, genotype, specimen, item, trial event, trial group, survey, device register, trial unit, general type, genotype alias, project and breeding method.

Database Update

• Drop any constraints in itemmeasurement and crossingmeasurement.

Instance Testing

• A number of new whitebox tests have been added. This takes the number of tests that can be run at the start of deployment to 482. VCol related tests will be 47

DAL version v2.7.4

Version 2.7.4
Date: 07/08/2023
Description: Bug Fixing Patch and Improvements

• Support for Trial Unit Factors/Virtual Columns added, allowing it to be included in add, update, bulk add, bulk update and filtering in lists.

• Update Trial Unit Bulk revamped to no longer remove trial units to be updated

• Permissions in Inventory Module overhauled. Admin access no longer required for storage, item parent, item and item group operations

• Deleting trial units will now delete relevant trial unit location entries in the PostgreSQL database

Database Update

• FactorName changed to VARCHAR(255) data type.

DAL version 2.7.3

Version 2.7.3
Date: 30/06/2023
Description: Bug Fixing Patch and Improvements

• SOLR dependencies upgraded to use the latest version of SOLR

• New Endpoint added to display taxonomy ancestors.

• Bug related to Add Genotype that mistakenly assigned Taxonomy to be compulsory fixed.

• Bug that showed TagName for Get Taxonomy incorrectly fixed.

• Delete Trial Unit now deletes linked Trial Unit Treatments.

• Get and List Genotype now shows Taxonomy Names.

• Docker Deployment of DAL now available.

• Ansible Scripts' dates have been updated to reflect the last meaningful work on them was done.

DAL version 2.7.2

Version 2.7.2
Date: 12/04/2023
Description: New Features and Improvements

• Survey related endpoints added

• Sample Measurement endpoints ammended to include Survey as a relation

• Extract Data related enpoints added

• Specimen, Storage Location, Survey update geography added.

• Trial Unit, Trial and Site updage geography updated to conform to new model.

Databse Update

• Survey Location spelling mistake corrected

Instance Testing

• A number of new whitebox tests have been added. This takes the number of tests that can be run at the start of deployment to 465.

DAL version 2.7.1

Version 2.7.1
Date: 16/03/2023
Description: New Features and Improvements

• Taxonomy related endpoints added and Genotype related endpoints updated to include TaxonomyId as a field where relavent.

• Pedgiree endpoints updated to include new field ParentTrialUnitSpecimenId.

• Specimen endpoints updated to include new field SourceCrossingId

• New endpoints user/:username/request/passwordreset and user/:username/execute/passwordreset to support password reset feature

Database update

• Taxonomy's TaxonomyName field has been corrected. Please ensure to use ansible upgrade scripts to update the table.

Instance Testing

• A number of new whitebox tests have been added. This takes the number of tests that can be run at the start of deployment to 421.

DAL version 2.7.0

GNU nano 6.2 CHANGES
Version 2.7.0
Date: 11/01/2023
Description: Major Database Upgrade

Database Changes:

• Survey entity added that involves new relations and updates to Sample Measurements, Trial Units and Traits. This creates an opportunity to link multiple Trial Units across different Trials.

• Trial Unit Treatment entity added that involves new relations and updates to Treatment and Trial Units. This effective allows for multiple treatments to be added to a single Trial Unit.

• GPS Locations of Sites, Trials, Trial Units, Contacts all now have Datetime fields to allow multiple locations to be stored. Furthermore, Specimens, Surveys and Storage can now have GPS Locations added to them.

• Tileset entity added to support the use of custom tiles for mapping purposes.

• Extract Data and Extract Data File entities created to support expanded Marker Data Import.

• Item Measurement entity added that involves new relation and updates to Item. This allows for measurements to be attached to Item entities.

• Crossing Measurement entity added that involves new relations and updates to Crossing. This allows for measurements to be attached to Crossing entities.

• Trial Unit Type added for General Types.

• Taxonomy entity added that invovles new relations and updates to Genotype

• Pedigree allows relation to Trial Unit Specimen in addition to Specimen

• Specimen allows relation to a Crossing to identify potential source Crossing.

Major:

• Trial Treatment endpoints updated to reflect new database structure change. This allows for multiple treatments to be added to a single Trial Unit and the return of multiple Treatments from a single Trial Uni>

• End points for Tile Data added.

Minor:

• Fixed issue #9522 relating to Genpedigree Filtering on GenParentType

DAL version 2.6.3

Version 2.6.3
Date: 01/08/2022
Description: Bug fixing version and minor improvements

Minor:

• Fixed issue #9025 relating to PlateName filtering being case senesitive

• Fixed issue #9136 relating to "DateAdded" being overwritten in item bulk update

• Fixed issue #7410 allowing TraitName to be included in genotype/_id/list/trait

• Fixed issue #8089 allowing "Public" to be returned in list/factors

• Fixed issue #8743 allowing SpecimenNote to be included in import/specimen

• Fixed issue #8851 allowing ItemFactors to be included in item bulk update

• Fixed issue #9008 allowing existing items to be added in Item Groups

• Fixed issue #9039 allowed Trial Unit Specimens to be filtered by Specimen Name and Trial Id

• Fixed issue #6650 that includes Trial Id in list/trialunitspecimen

• Added feature #8681 that deletes Specimen Keywords when deleting Specimen

• Added feature #3025 to allow children storage to be listed in list/storage

• Added feature #5168 to allow new extracts to be added to existing Analysis Groups.

• Added feature #5540 to list all trait aliases in trial/_trialid/list/trait

• delete/trialunitspecimen/:id has been added with the intention to replace remove/trialunitspecimen/:id in future versions.

DAL version 2.6.2

Minor:

• Filtering Genotype by Factors is now enabled through a config option

• Improved error handling for importing sample measurements. Entire error list from CSV is returned rather than first error encountered.

• Fixed issue relating to permissions to delete Specimens

• Fixed issue relating to updating trial unit locations

• Fixed issue relating to Item "DateAdded" being mistakenly overwritten

• Fixed issue relating to Specimen pagination count being affected by various Genotype-Specimen relationships

• Fixed issue relating to Filtering with special characters

• Updates to returned data for Genotypes in Specimens, Trial Traits and Crossings.