Examples of createAlias()


Examples of org.hibernate.Criteria.createAlias()

        return productSkus;
    }
   
    public List<ProductSku> findProductSkusNotInThisVirtualCatalogCategoryId(final Long categoryId, Object... params) {
        Criteria criteriaSubListId = createDefaultCriteria(ProductSku.class);
        criteriaSubListId.createAlias("catalogCategoryVirtualProductSkuRels", "catalogCategoryProductSkuRel", JoinType.LEFT_OUTER_JOIN);
        criteriaSubListId.add(Restrictions.eq("catalogCategoryProductSkuRel.pk.catalogCategoryVirtual.id", categoryId));
//        criteriaSubListId.setProjection(Projections.property("id"));

        @SuppressWarnings("unchecked")
        List<ProductSku> subProductSkus = criteriaSubListId.list();
View Full Code Here

Examples of org.hibernate.criterion.DetachedCriteria.createAlias()

                    String innerClass = field.split("\\.")[0].trim();
                    String innerAttribute = field.split("\\.")[1].trim();
                    log.debug("Adicionando resultado da consulta por ordem do campo "+innerClass+"."+innerAttribute+" COM criação de alias");
                    if (sortOrder) {
                        log.debug("Ordenação adicionada: " + sortField + " ASC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.asc(innerClass+"."+innerAttribute));
                    } else {
                        log.debug("Ordenação adicionada: " + sortField + " DESC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.desc(innerClass+"."+innerAttribute));
                    }
                }
View Full Code Here

Examples of org.hibernate.criterion.DetachedCriteria.createAlias()

                    if (sortOrder) {
                        log.debug("Ordenação adicionada: " + sortField + " ASC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.asc(innerClass+"."+innerAttribute));
                    } else {
                        log.debug("Ordenação adicionada: " + sortField + " DESC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.desc(innerClass+"."+innerAttribute));
                    }
                }

            }
View Full Code Here

Examples of org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery.createAlias()

    String code = oConvertUtils.getString(request.getParameter("typecode"));
    String filekey = oConvertUtils.getString(request.getParameter("filekey"));
    CriteriaQuery cq = new CriteriaQuery(MyClassLoader.getClassByScn(subclassname), dataGrid);
    cq.eq("businessKey", businessKey);
    if (StringUtil.isNotEmpty(type)) {
      cq.createAlias("TBInfotype", "TBInfotype");
      cq.eq("TBInfotype.typename", type);
    }
    if (StringUtil.isNotEmpty(filekey)) {
      cq.eq("id", filekey);
    }
View Full Code Here

Examples of org.projectforge.core.QueryFilter.createAlias()

  }

  public QueryFilter buildQueryFilter(final HRPlanningFilter filter)
  {
    final QueryFilter queryFilter = new QueryFilter(filter);
    queryFilter.createAlias("planning", "p").createAlias("p.user", "u");
    if (filter.getUserId() != null) {
      final PFUserDO user = new PFUserDO();
      user.setId(filter.getUserId());
      queryFilter.add(Restrictions.eq("p.user", user));
    }
View Full Code Here

Examples of uk.gov.nationalarchives.droid.core.interfaces.filter.expressions.QueryBuilder.createAlias()

     * @return QueryBuilder - the filter as an EJB QueryBuilder object.
     */
    public static QueryBuilder getQueryBuilder(Filter filter) {
        QueryBuilder queryBuilder = QueryBuilder
        .forAlias("profileResourceNode");
        queryBuilder.createAlias("format");
       
        if (filter.isNarrowed()) {
            for (FilterCriterion criterion : filter.getCriteria()) {
                queryBuilder.add(RestrictionFactory.forFilterCriterion(criterion));
            }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.