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 mikhail.pokidko@gmail.com
 designates 209.85.212.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=Z1I0nAw3qG81ECb5ygQGujrqe6Ctb+zk8cVYkHLZAd+40QoZZcuysrOYkhKEIgRIJy
         A9yGs2jII1owZjj424xdlRFBrIdl/Nn+fZtrVshhIOjk5E3HCkUWTR9GwJgHijgXAY3R
         gx8EbeGnUkUEvuzEH+oWsCmnoHXEAS+VPWrMc=
MIME-Version: 1.0
Date: Thu, 2 Sep 2010 14:06:46 +0400
Message-ID: <AANLkTikdQ4Jnpx1Z0BTcE33f4jc25jgWDmj2CdOmhiBW@mail.gmail.com>
Subject: searching for something like AND clause
From: "Mikhail A. Pokidko" <mikhail.pokidko@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hello all!

I have docs with such fields : {'type':'offer', 'city':''Moscow',
'expires':'2010/08/30 22:54:00',}
And now i`m stuck finding the way how to get unexpired offers for certain city.

My first attempt was writing view like this:
function(doc) {
    var today = new Date();
    if (doc.type == 'offer') {
        var created = new Date(doc.expiration_full);
        if (created > today) {
                emit(doc.city, doc);
        }
    }
}

But "today" stays as defined at the moment of view save. (Yes, i
understand that other way indexes should be recalculated every time)

So is there any clever way to get unexpired offers for certain city
without writing view-per-city?startkey=%{today_date} ?

-- 
xmpp: pma AT altlinux DOT org