Revision 542640fa
Added by Katja Luther over 7 years ago
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/reference/ReferenceDaoHibernateImpl.java | ||
---|---|---|
270 | 270 |
|
271 | 271 |
Query query = null; |
272 | 272 |
if (pattern != null){ |
273 |
query = session.createQuery("select uuid, id, abbrevTitle, titleCache from " + type.getSimpleName() +" where (abbrevTitle like :pattern OR (abbrevTitle IS NULL AND titleCache like :pattern)) ");
|
|
273 |
query = session.createQuery("select uuid, id, abbrevTitleCache, titleCache from " + type.getSimpleName() +" where abbrevTitleCache like :pattern ");
|
|
274 | 274 |
pattern = pattern + "%"; |
275 | 275 |
pattern = pattern.replace("*", "%"); |
276 | 276 |
pattern = pattern.replace("?", "_"); |
277 | 277 |
query.setParameter("pattern", pattern); |
278 | 278 |
} else { |
279 |
query = session.createQuery("select uuid, id, abbrevTitle, titleCache from " + type.getSimpleName() ); |
|
279 |
query = session.createQuery("select uuid, id, abbrevTitleCache, titleCache from " + type.getSimpleName() );
|
|
280 | 280 |
} |
281 | 281 |
if (limit != null){ |
282 | 282 |
query.setMaxResults(limit); |
Also available in: Unified diff
fix #5837: search on abbrevTitleCache instead of abbrev title