On Feb 24, 2:29 am, Bill <[email protected]> wrote: > This is a brain dump (LONG) as I work through this problem. Hope it > > We could use an equality filter that pretty much removes all entities > with last_vote_time more than an hour ago. One solution would be to > add a StringListProperty, call it last_vote_hours, that contains > strings corresponding to the last vote's hour in 00-23 format and its > hour + 1. So a vote at 7:45 pm would store ['19', '20] in > last_vote_hours. > > Back to our query at 8:38 pm: > > q = URLModel.gql('WHERE last_vote_hours = '20' ORDER by votesum_40_min > DESC') > urls = q.fetch(...)
To avoid past days from getting into results, the last_vote_hours would have a full date stamp + the hour, something like "2009-02-23 19" and "2009-02-23 20." Any alternatives or questions? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
