Revision 98838827
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");
|
|
| 273 |
query = session.createQuery("select uuid, id, abbrevTitle, titleCache from " + type.getSimpleName() +" where (abbrevTitle like :pattern OR (abbrevTitle IS NULL AND titleCache like :pattern)) ");
|
|
| 274 | 274 |
pattern = pattern + "%"; |
| 275 | 275 |
pattern = pattern.replace("*", "%");
|
| 276 | 276 |
pattern = pattern.replace("?", "_");
|
Also available in: Unified diff
fix #6061: search for titlecache if abbrev title is empty