ref #7965 methods to get typeDesignationStatusInUse as term an as filter object

[cdmlib.git] / cdmlib-persistence / src / main / java / eu / etaxonomy / cdm / persistence / dao / hibernate / name / TypeDesignationDaoHibernateImpl.java

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TypeDesignationDaoHibernateImpl.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TypeDesignationDaoHibernateImpl.java
index 284c656d8a39a15176a99081176f83e97f21e7eb..35a224b7bc54986b5930df3a029010f000ea0504 100644 (file)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TypeDesignationDaoHibernateImpl.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TypeDesignationDaoHibernateImpl.java
@@ -13,9 +13,11 @@ import java.util.List;
 
 import org.apache.log4j.Logger;
 import org.hibernate.Criteria;
+import org.hibernate.Query;
 import org.springframework.stereotype.Repository;
 
 import eu.etaxonomy.cdm.model.name.TypeDesignationBase;
+import eu.etaxonomy.cdm.model.name.TypeDesignationStatusBase;
 import eu.etaxonomy.cdm.persistence.dao.hibernate.common.SourcedEntityDaoImpl;
 import eu.etaxonomy.cdm.persistence.dao.name.ITypeDesignationDao;
 
@@ -50,4 +52,14 @@ public class TypeDesignationDaoHibernateImpl
                return results;
        }
 
+    /**
+     * {@inheritDoc}
+     */
+    @Override
+    public List<TypeDesignationStatusBase> getTypeDesignationStatusInUse() {
+        Query query = getSession().createQuery("select distinct tdb.typeStatus from TypeDesignationBase tdb");
+        List<TypeDesignationStatusBase> terms = query.list();
+        return terms;
+    }
+
 }