EDIT

import java.util.ArrayList;

import java.util.List;

import eu.etaxonomy.cdm.model.term.DefinedTermBase;

    public void addValue(StatisticalMeasurementValueDto value) {

        this.values.add(value);

    }

    public static String getQuantitativeDataDtoSelect(){

        String[] result = createSqlParts();

        return result[0]+result[1]+result[2] + result[3];

    }

    private static String[] createSqlParts() {

        //featureDto, uuid, states

        String sqlSelectString = ""

                + "select a.uuid, "

                + "feature.uuid, "

                + "statVal.uuid,  "

                + "statVal.value, "

                + "statVal.type, "

                + "unit";

        String sqlFromString =   " FROM QuantitativeData as a ";

        String sqlJoinString =  "LEFT JOIN a.statisticalValues as statVal "

                + "LEFT JOIN a.feature as feature "

                + "LEFT JOIN a.unit as unit ";

        String sqlWhereString =  "WHERE a.inDescription.uuid = :uuid";

        String[] result = new String[4];

        result[0] = sqlSelectString;

        result[1] = sqlFromString;

        result[2] = sqlJoinString;

        result[3] = sqlWhereString;

        return result;

    }

    /**

     * @param result

     * @return

     */

    public static List<QuantitativeDataDto> quantitativeDataDtoListFrom(List<Object[]> result) {

        List<QuantitativeDataDto> dtoResult = new ArrayList<>();

        QuantitativeDataDto dto = null;

        for (Object[] o: result){

            UUID uuid = (UUID)o[0];

            UUID featureUuid = (UUID)o[1];

            if (dto == null || !dto.getElementUuid().equals(uuid)){

                dto = new QuantitativeDataDto(uuid, new FeatureDto(featureUuid, null, null, null, null, null, null, true, false, true, null, true, false, null, null, null, null));

                dtoResult.add(dto);

            }

            StatisticalMeasurementValueDto statVal = new StatisticalMeasurementValueDto(TermDto.fromTerm((DefinedTermBase)o[4]),(BigDecimal)o[3], (UUID)o[2]) ;

            dto.addValue(statVal);

        }

        return dtoResult;

    }