How to write a query with a specific range and the group by clause.
I have an ecommerce site.
I basically have to get the list of pages along with its page view count over a specific period of time.
So i have to have a query with a GROUP BY of only the 'Page name' and specific date range.
Can someone please help
Can you give some data sample? As I tried to explain in this post:http://www.couchbase.com/communities/q-and-a/how-specify-startkeywhere-k... it is something complex to do since the range query is reading the full index and we read the startkey from left to right only (as a full key)
This is one of the reason we are building a more powerfull query engine that is available as developer preview: http://query.couchbase.com/
And you can even test it online:
to see what could be done