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
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-key-compound-where-one-keys-could-take-any-value-couchbase 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:
http://query.pub.couchbase.com/tutorial/#1
to see what could be done
Regards
Tug