Package org.hibernate.criterion

Examples of org.hibernate.criterion.ProjectionList

142
143
144
145
146
147
148
149
150
151
152
153
        criteria.add(Restrictions.eq("restaurant.id", restaurant.getId()));
        criteria.add(Restrictions.ge("date", startDate));
        criteria.add(Restrictions.le("date", endDate));
        criteria.add(Restrictions.isNotNull("menu.id"));

        ProjectionList projectionList = Projections.projectionList();
        projectionList.add(Projections.distinct(Projections.property("menu").as("menu")));
        projectionList.add(Projections.groupProperty("uuid"));

        criteria.setProjection(projectionList).setResultTransformer(new AliasToBeanResultTransformer(OrderStatsDto.class));
        return criteria.list();
    }
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
184
185
186
        criteria.add(Restrictions.eq("restaurant.id", restaurant.getId()));
        criteria.add(Restrictions.ge("date", startDate));
        criteria.add(Restrictions.le("date", endDate));
        criteria.add(Restrictions.isNotNull("menu.id"));

        ProjectionList projectionList = Projections.projectionList();
        projectionList.add(Projections.distinct(Projections.property("menu").as("menu")));
        projectionList.add(Projections.groupProperty("uuid"));
        projectionList.add(Projections.groupProperty("theme").as("theme"));

        criteria.setProjection(projectionList).setResultTransformer(new AliasToBeanResultTransformer(OrderStatsDto.class));
        List<OrderStatsDto> result =  criteria.list();
        for (OrderStatsDto tmp : result) {
            System.out.println(tmp.getTheme().getName());
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
210
211
        criteria.add(Restrictions.ge("date", startDate));
        criteria.add(Restrictions.le("date", endDate));
        criteria.add(Restrictions.isNull("menu.id"));
        criteria.createAlias("product", "p");

        ProjectionList projectionList = Projections.projectionList();
        projectionList.add(Projections.sum("p.price").as("sum"));
        projectionList.add(Projections.groupProperty("theme").as("theme"));

        criteria.setProjection(projectionList).setResultTransformer(new AliasToBeanResultTransformer(OrderStatsDto.class));

        return criteria.list();
    }
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
234
        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"));
        projList.add(Projections.rowCount());
        criteria.setProjection(projList);

        return getHibernateTemplate().findByCriteria(criteria);
    }
View Full Code Here
715
716
717
718
719
720
721
722
723
724
725
726
727
        final DetachedCriteria criteria = DetachedCriteria.forClass(
                TweetPoll.class, "tweetPoll");
        criteria.add(Subqueries.propertyIn("tweetPoll.tweetPollId", detached));
        criteria.addOrder(Order.desc("tweetPoll.createDate"));
        criteria.add(Restrictions.eq("publishTweetPoll", Boolean.TRUE));
        ProjectionList projList = Projections.projectionList();
        projList.add(Projections.groupProperty("createDate"));
        projList.add(Projections.rowCount());
        criteria.setProjection(projList);
       // calculateSearchPeriodsDates(period, criteria, "createDate");

        return getHibernateTemplate().findByCriteria(criteria);
    }
View Full Code Here
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
        final DetachedCriteria criteria = DetachedCriteria.forClass(
                TweetPoll.class, "tweetPoll");
        criteria.add(Subqueries.propertyIn("tweetPoll.tweetPollId", detached));
        criteria.addOrder(Order.desc("tweetPoll.createDate"));
        criteria.add(Restrictions.eq("publishTweetPoll", Boolean.TRUE));
        ProjectionList projList = Projections.projectionList();
        projList.add(Projections.groupProperty("createDate"));
        projList.add(Projections.rowCount());
        criteria.setProjection(projList);
        calculateSearchPeriodsDates(period, criteria, "createDate");

        return getHibernateTemplate().findByCriteria(criteria);
    }
View Full Code Here
476
477
478
479
480
481
482
483
484
485
486
                    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
465
466
467
468
469
470
471
472
473
474
475
476
477
478
    criteria.addOrder(Order.desc("hitDate"));

    // define as a VISIT category
    criteria.add(Restrictions.eq("hitCategory", HitCategory.VISIT));

    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.groupProperty("hitDate"));

    projList.add(Projections.rowCount());
    criteria.setProjection(projList);

    return getHibernateTemplate().findByCriteria(criteria);

  }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
    {
        // create our query
        Criteria criteria = getHibernateSession().createCriteria(DomainGroup.class);

        // tell hibernate which fields we want back
        ProjectionList fields = Projections.projectionList();

        fields.add(getColumn("id"));
        fields.add(getColumn("shortName"));
        fields.add(getColumn("name"));
        fields.add(getColumn("description"));
        fields.add(Projections.property("publicGroup").as("isPublic"));

        fields.add(Projections.property("createdBy.id").as("personCreatedById"));

        fields.add(getColumn("dateAdded"));

        criteria.setProjection(fields);

        // add restrictions (where clauses)
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
        // One or more of the activities were missing in the cache so go to the database
        if (unCachedIds.size() != 0)
        {
            Criteria criteria = getHibernateSession().createCriteria(Comment.class);
            ProjectionList fields = Projections.projectionList();
            fields.add(getColumn("id"));
            fields.add(getColumn("body"));
            fields.add(getColumn("timeSent"));
            fields.add(Projections.property("author.id").as("authorId"));
            fields.add(Projections.property("target.id").as("activityId"));
            criteria.setProjection(fields);

            criteria.setResultTransformer(resultTransformer);

            criteria.add(Restrictions.in("this.id", unCachedIds));
View Full Code Here
TOP

Related Classes of org.hibernate.criterion.ProjectionList

  • com.abiquo.server.core.infrastructure.network.IpPoolManagementDAO
  • com.abiquo.server.core.statistics.CloudUsageDAO
  • com.abiquo.server.core.statistics.EnterpriseResourcesDAO
  • com.logic
  • com.main
  • com.os
  • com.supinfo.youfood.dao.hibernate.HibOrderDao
  • de.sub.goobi.forms.ProjekteForm
  • de.sub.goobi.helper.ProjectHelper
  • it.pdor.contabilita.dao.ContabilitaDaoHibernateImpl
    • Copyright © 2018 www.massapicom. 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.