Resolve "Improve samples"
Loading
Related to #339 (closed) and linked to Data Portal MR E-DataPortal!657 (merged)
CRU 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 = 'Sample_description'
CRU 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 = 'Sample_description'