I want to group filtered result, not all, only filtered. Something like this:
r.table(TABLE_NAME).filter(...).group("supplier").max("ts").run(...)
Asked
Active
Viewed 206 times
0
okuznetsov
- 278
- 1
- 5
- 12
-
1may be: `r.table(...).group(...).max("ts").ungroup().filter` – okuznetsov Mar 30 '14 at 21:31
1 Answers
1
The query you wrote
r.table("orders").filter({company: "bar"}).group("supplier").max("ts").run(...)
Retrieve all the documents where company is "bar", then group them by supplier, and then for each group, it compute the maximum value for the field "ts". So what you want is what you wrote (except if I misunderstood your question).
