Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName)

Source Link

Document

A property value projection

Usage

From source file:com.liferay.portal.dao.orm.hibernate.ProjectionFactoryImpl.java

License:Open Source License

public Projection property(String propertyName) {
    return new ProjectionImpl(Projections.property(propertyName));
}

From source file:com.maydesk.base.dao.DaoRole.java

License:Mozilla Public License

public static List<MUser> findUsersByRole(IRole roleName) {
    Criteria criteria = PDHibernateFactory.getSession().createCriteria(MUserRole.class);
    criteria.add(eq("roleName", roleName.name()));
    criteria.add(eq("roleClass", roleName.getClass().getCanonicalName()));
    criteria.setProjection(Projections.property("userRef"));
    return criteria.list();
}

From source file:com.maydesk.base.dao.DaoUser.java

License:Mozilla Public License

public static List<MUser> findUsersByProject(MTenant tenant) {
    Criteria criteria = PDHibernateFactory.getSession().createCriteria(MTenantAssignment.class);
    criteria.add(Restrictions.eq("tenant", tenant));
    criteria.setProjection(Projections.property("user"));
    return criteria.list();
}

From source file:com.maydesk.base.dao.DaoUser.java

License:Mozilla Public License

public static List<MTenant> findReachableTenants() {
    Criteria criteria = PDHibernateFactory.getSession().createCriteria(MTenantAssignment.class);
    criteria.add(Restrictions.eq("user", PDUserSession.getInstance().getUser()));
    criteria.add(Restrictions.eq("owner", true));
    criteria.setProjection(Projections.property("tenant"));
    return criteria.list();
}

From source file:com.maydesk.base.table.PDPageableFactory.java

License:Mozilla Public License

public Projection getProjectionList() {
    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.id(), "id");
    projectionList.add(Projections.property("cachedTitle"), "title"); // Model must be of type MBaseWithTitle!
    projectionList.add(Projections.property("cachedDescription"), "description"); // Model must be of type MBaseWithTitle!
    return Projections.distinct(projectionList);
}

From source file:com.mec.DAO.Postgre.LocalidadPostgreDAO.java

public List<LocalidadTipo> getAll() {
    DetachedCriteria subCriteria = DetachedCriteria.forClass(DepartamentoTipo.class, "departamento")
            .add(Restrictions.eq("c_provincia", 18)).setProjection(Projections.property("departamento.id"));
    Criteria cr = getSessionPostgre().createCriteria(LocalidadTipo.class, "localidad");
    cr.add(Subqueries.propertyIn("localidad.cDepartamento.id", subCriteria));//localidades de Corrientes
    return lazyInit(cr.list());
}

From source file:com.metropolitan.formulasport727.dao.KorpaArtikalDAOImpl.java

@Override
public List<KorpaArtikal> getListaSvihJedinstvenihKorpaArtikalaKorpe(Korpa korpa) {
    return session.createCriteria(KorpaArtikal.class).add(Restrictions.eq("korId", korpa))
            .setProjection(Projections.projectionList().add(Projections.property("id").as("id"))
                    .add(Projections.property("korId").as("korId"))
                    .add(Projections.groupProperty("artId").as("artId")))
            .setResultTransformer(Transformers.aliasToBean(KorpaArtikal.class)).list();
}

From source file:com.mil.randommenu.dao.MenuDao.java

public List<MenuItem> getMenuItemFromWeekMenus() {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Menu.class);
    criteria.add(Restrictions.eq("isWeekMenu", true));
    criteria.setProjection(Projections.property("vegetables"));
    return criteria.list();
}

From source file:com.mil.randommenu.dao.MenuItemDao.java

public List<Vegetable> getVegetablesFromMenu(Menu menu) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(MenuItem.class);
    criteria.add(Restrictions.eq("menu", menu));
    criteria.setProjection(Projections.property("vegetable"));
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return criteria.list();
}

From source file:com.mil.randommenu.dao.MenuItemDao.java

public List<Vegetable> getVegdetablesFromWeekMenus() {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(MenuItem.class);
    Criteria menuCriteria = criteria.createCriteria("menu");
    menuCriteria.add(Restrictions.eq("isWeekMenu", true));
    criteria.setProjection(Projections.property("vegetable"));
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return criteria.list();
}