Project

General

Profile

« Previous | Next » 

Revision 692dd91f

Added by Katja Luther over 7 years ago

fix getUuidAndTitleCache for pattern with * or ?

View differences:

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