Revision 40b8afc7
Added by Andreas Müller almost 3 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/term/TermVocabularyDaoImpl.java | ||
|---|---|---|
| 350 | 350 |
String queryVocWithFittingTerms = "SELECT DISTINCT(v.uuid) FROM DefinedTermBase term JOIN term.vocabulary as v WHERE " ; |
| 351 | 351 |
for (CdmClass availableFor: availableForSet){
|
| 352 | 352 |
queryVocWithFittingTerms += " term.availableFor like '%"+availableFor.getKey()+"%' AND term.termType = :feature"; |
| 353 |
|
|
| 354 | 353 |
} |
| 355 | 354 |
|
| 356 |
// Query query1 = getSession().createQuery(queryVocWithFittingTerms); |
|
| 357 |
// List<Object[]> result1 = query1.list(); |
|
| 358 |
|
|
| 359 | 355 |
String queryString = TermCollectionDto.getTermCollectionDtoSelect() |
| 360 | 356 |
+ " WHERE a.uuid in " |
| 361 | 357 |
+ " (" + queryVocWithFittingTerms + ")";
|
| 362 | 358 |
|
| 363 |
|
|
| 364 |
|
|
| 365 |
|
|
| 366 | 359 |
Query query = getSession().createQuery(queryString); |
| 367 | 360 |
query.setParameter("feature", TermType.Feature);
|
| 368 | 361 |
|
| 369 | 362 |
@SuppressWarnings("unchecked")
|
| 370 | 363 |
List<Object[]> result = DefinedTermDaoImpl.deduplicateResult(query.list()); |
| 371 | 364 |
|
| 372 |
// Map<UUID, TermVocabularyDto> dtoMap = new HashMap<>(result.size()); |
|
| 373 | 365 |
List<TermVocabularyDto> dtos = TermVocabularyDto.termVocabularyDtoListFrom(result); |
| 374 | 366 |
|
| 375 | 367 |
return dtos; |
Also available in: Unified diff
cleanup