Inequality and sort

59 views

Skip to first unread message

PanosJee

unread,

Jan 4, 2012, 2:02:14 PM1/4/12

to google-a...@googlegroups.com

Hey guys I know this is an old issue but I am wondering if there any news about it:

I have a simple query where I want to do:

filter('created >=', somedatetime).order('-counter')

I tried: filter('created >=', somedatetime).order('-created').order('-counter') but because created is a datetime the results are pretty bad.

A user can go through a list with infinite scrolling and we can choose a time window of 7,30,90 days but it seems I cannot this very simple query.

I was thinking of break created to two attributes (dayofyear, year) so that I could use the IN operator but this could be hard as I have about 2M entries.