Package org.hibernate.criterion

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

420
421
422
423
424
425
426
427
428
429
430
                                        new String[] { tagName }))));
        final DetachedCriteria criteria = DetachedCriteria.forClass(
                Survey.class, "survey");
        criteria.add(Subqueries.propertyIn("survey.sid", detached));
        if (filterby.equals(TypeSearchResult.HASHTAG)) {
            criteria.addOrder(Order.desc("survey.createDate"));
        } else if (filterby.equals(TypeSearchResult.HASHTAGRATED)) {
              criteria.addOrder(Order.desc("numbervotes"));
        }
        calculateSearchPeriodsDates(searchPeriods, detached, "createDate");
        return (List<Survey>) filterByMaxorStart(criteria, limitResults, startResults);
View Full Code Here
422
423
424
425
426
427
428
429
430
431
432
                Survey.class, "survey");
        criteria.add(Subqueries.propertyIn("survey.sid", detached));
        if (filterby.equals(TypeSearchResult.HASHTAG)) {
            criteria.addOrder(Order.desc("survey.createDate"));
        } else if (filterby.equals(TypeSearchResult.HASHTAGRATED)) {
              criteria.addOrder(Order.desc("numbervotes"));
        }
        calculateSearchPeriodsDates(searchPeriods, detached, "createDate");
        return (List<Survey>) filterByMaxorStart(criteria, limitResults, startResults);
    }
View Full Code Here
452
453
454
455
456
457
458
459
460
461
462
                                   .add(Restrictions.in("hash.hashTag",
                                           new String[] { tagName }))));
           final DetachedCriteria criteria = DetachedCriteria.forClass(
                   Survey.class, "survey");
           criteria.add(Subqueries.propertyIn("survey.sid", detached));
           criteria.addOrder(Order.desc("survey.createDate"));
           calculateSearchPeriodsDates(period, criteria, "survey.createDate");
           return getHibernateTemplate().findByCriteria(criteria);
       }

View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
                .add(Restrictions.in("hash.hashTag",
                    new String[] { tagName }))));
    final DetachedCriteria criteria = DetachedCriteria.forClass(
        Survey.class, "survey");
    criteria.add(Subqueries.propertyIn("survey.sid", detached));
    criteria.addOrder(Order.desc("survey.createDate"));
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.groupProperty("createDate"));
    projList.add(Projections.rowCount());
    criteria.setProjection(projList);
    return getHibernateTemplate().findByCriteria(criteria);
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
    if (tagCriteria.equals("hashTagsCloud")) {
      criteria.add(Restrictions.gt("size", MIN_SIZE_CLOUD));
      // TODO: date?
      // criteria.add(Restrictions.gl("updatedDate",
      // getCurrentdMidnightDate()));
      criteria.addOrder(Order.desc("size"));
      criteria.addOrder(Order.asc("hashTag"));
    } else {
      criteria.addOrder(Order.desc("hits"));
      criteria.addOrder(Order.asc("hashTag"));
    }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
      criteria.add(Restrictions.gt("size", MIN_SIZE_CLOUD));
      // TODO: date?
      // criteria.add(Restrictions.gl("updatedDate",
      // getCurrentdMidnightDate()));
      criteria.addOrder(Order.desc("size"));
      criteria.addOrder(Order.asc("hashTag"));
    } else {
      criteria.addOrder(Order.desc("hits"));
      criteria.addOrder(Order.asc("hashTag"));
    }
    return (List<HashTag>) filterByMaxorStart(criteria, maxResults, start);
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
      // criteria.add(Restrictions.gl("updatedDate",
      // getCurrentdMidnightDate()));
      criteria.addOrder(Order.desc("size"));
      criteria.addOrder(Order.asc("hashTag"));
    } else {
      criteria.addOrder(Order.desc("hits"));
      criteria.addOrder(Order.asc("hashTag"));
    }
    return (List<HashTag>) filterByMaxorStart(criteria, maxResults, start);
  }
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
      // getCurrentdMidnightDate()));
      criteria.addOrder(Order.desc("size"));
      criteria.addOrder(Order.asc("hashTag"));
    } else {
      criteria.addOrder(Order.desc("hits"));
      criteria.addOrder(Order.asc("hashTag"));
    }
    return (List<HashTag>) filterByMaxorStart(criteria, maxResults, start);
  }

  /*
 
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
   */
  public List<HashTagRanking> getHashTagRankingLastPosition(final Date maxDate) { 
    DetachedCriteria criteria = DetachedCriteria
        .forClass(HashTagRanking.class);
    criteria.add(Restrictions.not(Restrictions.eq("rankingDate", maxDate)));
    criteria.addOrder(Order.desc("average"));
    @SuppressWarnings("unchecked")
    List results = getHibernateTemplate().findByCriteria(
        criteria);
    return results;
  }
View Full Code Here
438
439
440
441
442
443
444
445
446
447
448
        }

        final DetachedCriteria criteria = DetachedCriteria.forClass(Hit.class);
        criteria.createAlias("hashTag", "hashTag");
        criteria.add(Restrictions.eq("hashTag.hashTagId", tagId));
        criteria.addOrder(Order.desc("hitDate"));
        criteria.add(Restrictions.between("hitDate", startDate, endDate));
        //define as a VISIT category
        criteria.add(Restrictions.eq("hitCategory", HitCategory.VISIT));
        return getHibernateTemplate().findByCriteria(criteria);
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.