Revision 692dd91f
Added by Katja Luther over 7 years ago
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/agent/AgentDaoImpl.java | ||
---|---|---|
183 | 183 |
if (pattern != null){ |
184 | 184 |
query = session.createQuery("select uuid, id, nomenclaturalTitle from " + type.getSimpleName() +" where nomenclaturalTitle like :pattern" + clazzString); |
185 | 185 |
pattern = pattern + "%"; |
186 |
pattern = pattern.replace("*", "%"); |
|
187 |
pattern = pattern.replace("?", "_"); |
|
186 | 188 |
query.setParameter("pattern", pattern); |
187 | 189 |
} else { |
188 | 190 |
if (clazzString != ""){ |
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/common/IdentifiableDaoBase.java | ||
---|---|---|
287 | 287 |
Query query = null; |
288 | 288 |
if (pattern != null){ |
289 | 289 |
query = session.createQuery("select uuid, id, titleCache from " + type.getSimpleName() +" where titleCache like :pattern"); |
290 |
pattern.replace("*", "%"); |
|
290 |
pattern = pattern.replace("*", "%"); |
|
291 |
pattern = pattern.replace("?", "_"); |
|
291 | 292 |
pattern = pattern + "%"; |
292 | 293 |
query.setParameter("pattern", pattern); |
293 | 294 |
} else { |
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/reference/ReferenceDaoHibernateImpl.java | ||
---|---|---|
108 | 108 |
query.setMaxResults(limit); |
109 | 109 |
} |
110 | 110 |
if (pattern != null){ |
111 |
pattern.replace("*", "%"); |
|
111 |
pattern = pattern.replace("*", "%"); |
|
112 |
pattern = pattern.replace("?", "_"); |
|
112 | 113 |
pattern = pattern + "%"; |
113 | 114 |
query.setParameter("pattern", pattern); |
114 | 115 |
} |
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonDaoHibernateImpl.java | ||
---|---|---|
1981 | 1981 |
} |
1982 | 1982 |
Query query = getSession().createQuery(queryString); |
1983 | 1983 |
if (pattern != null){ |
1984 |
pattern.replace("*", "%"); |
|
1985 |
pattern = pattern + "%"; |
|
1984 |
pattern = pattern.replace("*", "%"); |
|
1985 |
pattern = pattern.replace("?", "_"); |
|
1986 |
pattern = pattern + "%"; |
|
1986 | 1987 |
query.setParameter("pattern", pattern); |
1987 | 1988 |
} |
1988 | 1989 |
if (limit != null){ |
Also available in: Unified diff
fix getUuidAndTitleCache for pattern with * or ?