Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: error (athena.apache.org: local policy)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1283)
Subject: Re: Get the 20 posts, of the last seven days,
 ordered by number of hits
From: Filippo Fadda <filippo.fadda@programmazione.it>
In-Reply-To: <1EC6F8E4-19BE-4368-9B8E-9B9EA317BAD6@calftrail.com>
Date: Tue, 23 Jul 2013 00:53:47 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <4BF6C96C-E49A-44BB-826C-A5BB7B35B0AA@programmazione.it>
References: <F5E952A2-1B2B-4338-8A2D-84667B7B5E77@programmazione.it>
 <565CA793-C9DA-4BFE-AB3E-17D9E9287A69@programmazione.it>
 <1EC6F8E4-19BE-4368-9B8E-9B9EA317BAD6@calftrail.com>
To: user@couchdb.apache.org

Thanks for your answer. Unfortunately the post date can change, because =
a document can be updated or revert to a draft state and then published =
again.
Anyway I can still map with emit(post.publishingDate, NULL) all the =
posts, then I can get the posts of the last week, using startkey =
parameter. Finally I can query another view emit(hit.postId, NULL) using =
reduce =3D _count using as keys all the doc ids from the first query and =
stale=3Dok. I can sort the results and limits them to 20. In a week I =
will have maybe 300 posts, so I think should be fast enough.

-Filippo

On Jul 23, 2013, at 12:11 AM, Nathan Vander Wilt wrote:

> If your "hit" document includes the post date, you could map with =
`emit([hit.post_date, hit.post_id])` and reduce with `_count`. Then you =
when queried with `?group=3Dexact` you would have total hits per post =
and you could prune the results using startkey to last 7 days. You would =
still need to order all the recent matches yourself before limiting to =
20 posts however. Assuming the number of posts in a week is not enormous =
it seems reasonable.
>=20
> hth,
> -nvw
>=20
>=20
> On Jul 22, 2013, at 10:32 AM, Filippo Fadda wrote:
>=20
>> OK, this answered to my question:
>>=20
>> =
http://stackoverflow.com/questions/5571459/couchdb-view-query-with-multipl=
e-key-values
>>=20
>> It is never possible to query by criteria A and then sort by criteria =
B in CouchDB.
>>=20
>> So I have to get posts in a data range, then sort them by number of =
hits myself.
>>=20
>> -Filippo
>>=20
>>=20
>>=20
>> On Jul 22, 2013, at 6:25 PM, Filippo Fadda wrote:
>>=20
>>> Let's suppose I have a blog and I want display the popular posts, =
where popular means: the 20 posts, of the last seven days, ordered by =
number of hits.
>>> To avoid conflicts I don't save the number of hits in the post =
itself, but I emit a new document every time a generic user displays a =
post.
>>> Even using view collation I don't get a solution for this problem.
>>>=20
>>> -Filippo
>>=20
>=20