Package org.hibernate.criterion

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

192
193
194
195
196
197
198
199
200
201
202
    // limit the element
    if (node != null) {
      criteria.add(Property.forName("nodeId").eq(node.getId()));
    }
    // get the last trial as first
    criteria.addOrder(Order.desc("id"));

    // find the trials
    trials = (List<Trial>) criteria.getExecutableCriteria(sessionFactory.getCurrentSession()).setMaxResults(maxResults).list();

    return trials;
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
        // limit the element
        if (node != null) {
            criteria.add(Property.forName("nodeId").eq(node.getId()));
        }
        // get the last trial as first
        criteria.addOrder(Order.desc("id"));
       
        // find the trials
        trials = (List<Trial>) getHibernateTemplate().findByCriteria(criteria, 0, maxResults);
       
        return trials;
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
    @Override
    public List<T> findAll(Order order) {
        DetachedCriteria criteria = getDetachedCriteria();
        if (order != null) {
            criteria.addOrder(order);
        }
        return findByCriteria(criteria);
    }

    @Override
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
            final Integer maxResults,
            final Integer start) {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
        criteria.add(Restrictions.eq("editorOwner", userAcc));
        criteria.add(Restrictions.eq("publish", Boolean.TRUE));
        criteria.addOrder(Order.desc("createDate"));
        return (List<Poll>) filterByMaxorStart(criteria, maxResults, start);
    }

    /**
     * Retrieve poll by {@link Account}.
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
            final Integer maxResults,
            final Integer start){
        final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
        criteria.add(Restrictions.eq("owner", account));
        criteria.add(Restrictions.eq("publish", Boolean.TRUE));
        criteria.addOrder(Order.desc("createDate"));
        return (List<Poll>) filterByMaxorStart(criteria, maxResults, start);
    }

    /*
     * (non-Javadoc)
 
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
                                        new String[] { tagName }))));
        final DetachedCriteria criteria = DetachedCriteria.forClass(
                Poll.class, "poll");
        criteria.add(Subqueries.propertyIn("poll.pollId", detached));
        if (filterby.equals(TypeSearchResult.HASHTAG)) {
            criteria.addOrder(Order.desc("poll.createDate"));
        } else if (filterby.equals(TypeSearchResult.HASHTAGRATED)) {
              criteria.addOrder(Order.desc("numbervotes"));
        }
        criteria.add(Restrictions.eq("publish", Boolean.TRUE));
        calculateSearchPeriodsDates(searchPeriods, detached, "createDate");
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
                Poll.class, "poll");
        criteria.add(Subqueries.propertyIn("poll.pollId", detached));
        if (filterby.equals(TypeSearchResult.HASHTAG)) {
            criteria.addOrder(Order.desc("poll.createDate"));
        } else if (filterby.equals(TypeSearchResult.HASHTAGRATED)) {
              criteria.addOrder(Order.desc("numbervotes"));
        }
        criteria.add(Restrictions.eq("publish", Boolean.TRUE));
        calculateSearchPeriodsDates(searchPeriods, detached, "createDate");
        return (List<Poll>) filterByMaxorStart(criteria,limitResults, startResults);
    }
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
                                .add(Restrictions.in("hash.hashTag",
                                        new String[] { tagName }))));
        final DetachedCriteria criteria = DetachedCriteria.forClass(
                Poll.class, "poll");
        criteria.add(Subqueries.propertyIn("poll.pollId", detached));
        criteria.addOrder(Order.desc("poll.createDate"));
        calculateSearchPeriodsDates(period, criteria, "createDate");
        criteria.add(Restrictions.eq("publish", Boolean.TRUE));
        return getHibernateTemplate().findByCriteria(criteria);
    }
View Full Code Here
219
220
221
222
223
224
225
226
227
228
229
                                .add(Restrictions.in("hash.hashTag",
                                        new String[] { tagName }))));
        final DetachedCriteria criteria = DetachedCriteria.forClass(
                Poll.class, "poll");
        criteria.add(Subqueries.propertyIn("poll.pollId", detached));
        criteria.addOrder(Order.desc("poll.createDate"));

        criteria.add(Restrictions.eq("publish", Boolean.TRUE));
        calculateSearchPeriodsDates(period, criteria, "createDate");
        ProjectionList projList = Projections.projectionList();
        projList.add(Projections.groupProperty("createDate"));
View Full Code Here
451
452
453
454
455
456
457
458
459
460
461
            final Integer maxResults,
            final Integer start){
         final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
         criteria.add(Restrictions.eq("publish", Boolean.TRUE));
         criteria.add(Restrictions.eq("editorOwner", userAcc));
         criteria.addOrder(Order.desc("createDate"));
         return (List<Poll>) filterByMaxorStart(criteria, maxResults, start);
    }

    /*
     * (non-Javadoc)
 
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.