Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of pankaj.jangid@gmail.com
 designates 209.85.160.180 as permitted sender)
MIME-Version: 1.0
From: Pankaj Jangid <pankaj.jangid@gmail.com>
Date: Fri, 13 Apr 2012 20:32:18 +0530
Message-ID: 
 <CAAEmGMcawdoC8GFRSV3iz9J7iZvVuocTGYrDSuzcQhgwsb16xQ@mail.gmail.com>
Subject: Equivalent of "select in, order by"
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=20cf303bf54e6a8cf104bd90c391

--20cf303bf54e6a8cf104bd90c391
Content-Type: text/plain; charset=UTF-8

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

--20cf303bf54e6a8cf104bd90c391--