Skip to content

Resolve "Add sample comment"

Marjolaine Bodin requested to merge 509-add_sample_comment into master

Closes #509 (closed)
needs icat-compose!12 (merged) to be merged for the docker tests.

Update in ICAT DB:

  • ParameterType Sample_notes to be applicable to Sample
  • Rules: update the 2 existing rules by:
    • SELECT sampleParameter FROM SampleParameter sampleParameter JOIN sampleParameter.type AS parameterType JOIN sampleParameter.sample AS sample JOIN sample.investigation AS investigation JOIN investigation.investigationUsers AS investigationUser JOIN investigationUser.user AS user WHERE user.name = :user AND parameterType.name IN ('Sample_description', 'Sample_notes')
    • SELECT sampleParameter FROM SampleParameter sampleParameter JOIN sampleParameter.type AS parameterType JOIN sampleParameter.sample AS sample JOIN sample.investigation AS investigation JOIN investigation.investigationInstruments AS investigationInstrument JOIN investigationInstrument.instrument AS instrument JOIN instrument.instrumentScientists AS instrumentScientist JOIN instrumentScientist.user AS user WHERE user.name = :user AND parameterType.name IN ('Sample_description', 'Sample_notes')
Edited by Marjolaine Bodin

Merge request reports