Due to the limitation of GAE's datastore "Inequality Filters Are Allowed On One Property Only", a simple date range overlapping query become a problem.
I have a Kind which contains 2 properties: date_begin, date_end, I need to run a query to find out all rows which overlapping the date range given (datebegin2, dateend2). in a SQL query it just simple "@StartDate1 <= @EndDate2 AND @StartDate1 <= @EndDate1 " in WHERE clause, however in GQL, we have a problem. Does anyone have a solution for this? Thanks ! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
