Revision df0abd11
Added by Patrick Plitzner about 5 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/common/IdentifiableDaoBase.java | ||
|---|---|---|
| 695 | 695 |
@Override |
| 696 | 696 |
public <S extends T> List<UuidAndTitleCache<S>> getUuidAndTitleCache(Class<S> clazz, Integer limit, String pattern){
|
| 697 | 697 |
Session session = getSession(); |
| 698 |
Query query = null; |
|
| 699 |
if (pattern != null){
|
|
| 700 |
query = session.createQuery( |
|
| 701 |
" SELECT uuid, id, titleCache " |
|
| 702 |
+ " FROM " + clazz.getSimpleName() |
|
| 703 |
+ " WHERE titleCache LIKE :pattern"); |
|
| 698 |
Query query = session.createQuery( |
|
| 699 |
" SELECT uuid, id, titleCache " |
|
| 700 |
+ " FROM " + clazz.getSimpleName() |
|
| 701 |
+ (pattern!=null?" WHERE titleCache LIKE :pattern":"")); |
|
| 702 |
if(pattern!=null){
|
|
| 704 | 703 |
pattern = pattern.replace("*", "%");
|
| 705 | 704 |
pattern = pattern.replace("?", "_");
|
| 706 | 705 |
pattern = pattern + "%"; |
| 707 | 706 |
query.setParameter("pattern", pattern);
|
| 708 |
} else {
|
|
| 709 |
query = session.createQuery( |
|
| 710 |
" SELECT uuid, id, titleCache " |
|
| 711 |
+ " FROM " + clazz.getSimpleName() ); |
|
| 712 | 707 |
} |
| 713 | 708 |
if (limit != null){
|
| 714 | 709 |
query.setMaxResults(limit); |
Also available in: Unified diff
ref #8146 Refactor service method