Group property into elasticsearch


(Ha Lan Quyen) #1

Hi everyone,

I have a query in SQL like this:
Criteria crit = session.createCriteria(SignupLog.class);
if (start != null) {
crit.add(Restrictions.ge("reqDate", start));
}
if (finish != null) {
crit.add(Restrictions.le("reqDate", finish));
}
if (website != null) {
crit.add(Restrictions.eq("website", website));
}
if (org != null) {
crit.add(Restrictions.eq("organisation", org));
}
crit.setProjection(Projections.projectionList()
.add(Projections.min("reqDate"))
.add(Projections.rowCount())
.add(Projections.groupProperty("groupEntity"))
.add(Projections.groupProperty("reqYear"))
.add(Projections.groupProperty("reqMonth"))
.add(Projections.groupProperty("reqDay")));

And for now I want to do it by using elasticsearch? How can I do it?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/66e48265-1ae1-4bf0-b7cb-962ec6efd9a9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #2