Equivalent of "select in, order by"

[Pankaj Jangid]

Hi,

I have documents with fields 'date' and 'group'. And this is my view:

byDateGroup: {
  map: function(doc) {
    if (doc.date && doc.group) {
      emit([doc.date, doc.group], null);
    }
  }
}

What would be the equivalent query of this:

select * from docs where group in ("group1", "group2") order by date desc


--

Thanks and regards

Pankaj