Aggregate method using Restheart

Question

I have a remote database on MongoDB and i want to execute an aggregate method for grouping entries w.r.t. a certain field using restheart. My query looks like this

 db.musa.aggregate([{$group:{_id:"$username"}}])

this query returns a list of unique users in my database but i am not sure how to implement it using restheart. Is it even possible to do so?

currently restheart not support aggregate querys. – Fariz Aghayev Oct 20 '15 at 16:07 — Fariz Aghayev, Oct 20 '15 at 16:07
thanks for the answer. – Arsalan Ahmed Oct 21 '15 at 10:53 — Arsalan Ahmed, Oct 21 '15 at 10:53

score 2 · Accepted Answer · edited Jun 20 '20 at 09:12

2

I'm from the restheart.org team...

a similar question has been already asked on github https://github.com/SoftInstigate/restheart/issues/55

I'm pasting here the answer:

currently aggregate queries are not supported.

note that this is in the roadmap and planned for next version

jira task 41: https://softinstigate.atlassian.net/browse/RH-41

as a workaround you can implement a custom application handler: documentation at https://softinstigate.atlassian.net/wiki/x/IoCw

edited Jun 20 '20 at 09:12

Community

1
1

answered Oct 21 '15 at 09:38

Andrea Di Cesare

1,125
6
11

I just updated the documentation page with a full example on how to execute an aggregation query via ApplicationHandler. – Andrea Di Cesare Oct 22 '15 at 10:43
It is supported now – Ilia Shakitko Jan 10 '17 at 11:59

mturatti · Answer 2 · 2019-01-18T08:32:01.700

2

RESTHeart release 1.1 is out and now can manage aggregation operations: both aggregation pipelines and map reduce functions are supported.

Aggregations operations process data records and return computed results. Aggregation operations group values from multiple documents together, and can perform a variety of operations on the grouped data to return a single result.

Please let us know your feedback.

edited Jan 18 '19 at 08:32

answered Dec 08 '15 at 11:33

mturatti

651
5
10

Aggregate method using Restheart

2 Answers2