Revision 740aabcf
Added by Katja Luther over 2 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonNodeDaoHibernateImpl.java | ||
|---|---|---|
| 1190 | 1190 |
*/ |
| 1191 | 1191 |
private String getTaxonNodeDtoQuery() {
|
| 1192 | 1192 |
String queryString = "SELECT new " + SortableTaxonNodeQueryResult.class.getName() + "("
|
| 1193 |
+ "tn.uuid, tn.id, t.titleCache, name.titleCache, rank " |
|
| 1193 |
+ "tn.uuid, tn.id, t.titleCache, name.titleCache, rank, p.uuid "
|
|
| 1194 | 1194 |
+ ") " |
| 1195 | 1195 |
+ " FROM TaxonNode tn " |
| 1196 | 1196 |
+ " INNER JOIN tn.taxon AS t " |
| 1197 |
+ " INNER JOIN tn.parent AS p" |
|
| 1197 | 1198 |
+ " INNER JOIN t.name AS name " |
| 1198 | 1199 |
+ " LEFT OUTER JOIN name.rank AS rank "; |
| 1199 | 1200 |
|
| ... | ... | |
| 1226 | 1227 |
List<TaxonNodeDto> nodeDtos = new ArrayList<>(); |
| 1227 | 1228 |
Collections.sort(result, new SortableTaxonNodeQueryResultComparator()); |
| 1228 | 1229 |
for(SortableTaxonNodeQueryResult queryDTO : result){
|
| 1229 |
TaxonNodeDto nodeDto = new TaxonNodeDto(queryDTO.getTaxonNodeUuid(), queryDTO.getTaxonNodeId(), queryDTO.getNameTitleCache(), queryDTO.getTaxonTitleCache(), queryDTO.getNameRank().getOrderIndex()); |
|
| 1230 |
TaxonNodeDto nodeDto = new TaxonNodeDto(queryDTO.getTaxonNodeUuid(), queryDTO.getTaxonNodeId(), queryDTO.getNameTitleCache(), queryDTO.getTaxonTitleCache(), queryDTO.getNameRank().getOrderIndex(), queryDTO.getParentNodeUuid());
|
|
| 1230 | 1231 |
nodeDtos.add(nodeDto); |
| 1231 | 1232 |
} |
| 1232 | 1233 |
return nodeDtos; |
Also available in: Unified diff
ref #9843: fix taxonnode dto creation and add parent uuid