EDIT

    protected UUID parentNodeUuid;

            Rank nameRank, UUID parentNodeUuid) {

        this.parentNodeUuid = parentNodeUuid;

            Rank nameRank, UUID parentNodeUuid) {

        this(taxonNodeUuid, taxonNodeId, taxonTitleCache, null, nameRank, parentNodeUuid);

    public SortableTaxonNodeQueryResult(UUID taxonNodeUuid, Integer taxonNodeId, String taxonTitleCache, UUID parentNodeUuid) {

        this(taxonNodeUuid, taxonNodeId, taxonTitleCache, null, parentNodeUuid);

    /**

     * @return the parentNodeUuid

     */

    public UUID getParentNodeUuid() {

        return parentNodeUuid;

    }

    /**

     * @param parentNodeUuid the parentNodeUuid to set

     */

    public void setParentNodeUuid(UUID parentNodeUuid) {

        this.parentNodeUuid = parentNodeUuid;

    }

    @Override

    public TaxonRowWrapperDTO createTaxonRowWrapper(UUID taxonDescriptionUuid, UUID descriptiveDataSetUuid) {

        Classification classification = null;

        DescriptionBaseDto description = descriptionService.loadDto(taxonDescriptionUuid);

        DescriptiveDataSet descriptiveDataSet = dao.load(descriptiveDataSetUuid, null);

        Optional<TaxonNode> first = descriptiveDataSet.getTaxonSubtreeFilter().stream()

                .filter(node->node.getClassification()!=null).findFirst();

        Optional<Classification> classificationOptional = first.map(node->node.getClassification());

        Set<DescriptionBaseDto> descriptions = new HashSet<>();

        TaxonNodeDto nodeDto = null;

        if(classificationOptional.isPresent()){

            classification = classificationOptional.get();

            nodeDto = taxonNodeService.dto(description.getTaxonDto().getUuid(), classification.getUuid());

        }

        return new TaxonRowWrapperDTO(description, nodeDto, descriptions);

    }

     * Creates a taxon row wrapper object for the given description UUID

     * @param taxonDescriptionUUID the taxon description for which the wrapper should be created

     * @param descriptiveDataSetUUID the data set it should be used in

     * @return the created row wrapper

     */

    public TaxonRowWrapperDTO createTaxonRowWrapper(UUID taxonDescriptionUuid, UUID descriptiveDataSetUuid);

    /**

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

       if (states != null){

           this.states = states;

       }

    public static String getCategoricalDtoSelect(){

        String[] result = createSqlParts();

    private static String[] createSqlParts() {

                + "state.uuid,  "

                + "state.count, "

                + "state.state ";

        String sqlJoinString =  "LEFT JOIN a.stateData as state "

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

    /**

     * @param result

     * @return

     */

    public static List<CategoricalDataDto> categoricalDataDtoListFrom(List<Object[]> result) {

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

        CategoricalDataDto 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 CategoricalDataDto(uuid, new FeatureDto(featureUuid, null, null, null, null, null, null, true, false, true, null, true, false, null, null, null, null), null);

                dtoResult.add(dto);

            }

            StateDataDto state = new StateDataDto(TermDto.fromTerm((DefinedTermBase)o[4]),(Integer) o[3], uuid);

            dto.addState(state);

        }

        return dtoResult;

    }

    public static String getDescriptionBaseDtoForTaxonSelect(){

        String[] result = createSqlPartsForTaxon();

    private static String[] createSqlPartsForTaxon() {

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

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;

    }