Anyone? Il giorno lunedì 11 giugno 2012 16:42:28 UTC+2, Nicanor Babula ha scritto: > > Hi everyone, > > I am experiencing some problems executing a certain query on the > datastore. > > In this particular case, I want to retreieve all TreatmentPlanDetails of > with a certain accountId, having the status = 'done', the category = > 'chirurgia orale' having been set to 'done' between 6 june 2012 and 11 june > 2012 and with deleteStatus = 'notDeleted'. > > For instance, if I execute: > SELECT * FROM TreatmentPlanDetails > WHERE > accountId = 'ag5zfmRvbW9kZW50d2ViMnIRCxIIQWNjb3VudHMYtcjdAQw' AND > status = 'done' AND > setDoneCalendarEventStartTimestamp >= [timestamp for 6 june 2012] AND > setDoneCalendarEventStartTimestamp <= [timestamp for 11 june 2012] AND > deleteStatus = 'notDeleted' > ORDER BY setDoneCalendarEventStartTimestamp ASC > (not filtering by category) > > I will get record A, B and C, where A and B has category = 'chirurgia > orale' and C has category = 'altro'. > If I want to get only the records having category = 'chirurgia orale', I > would simply run: > > SELECT * FROM TreatmentPlanDetails > WHERE > accountId = 'ag5zfmRvbW9kZW50d2ViMnIRCxIIQWNjb3VudHMYtcjdAQw' AND > status = 'done' AND > category = 'chirurgia orale' > setDoneCalendarEventStartTimestamp >= [timestamp for 6 june 2012] AND > setDoneCalendarEventStartTimestamp <= [timestamp for 11 june 2012] AND > deleteStatus = 'notDeleted' > ORDER BY setDoneCalendarEventStartTimestamp ASC > (filtering by category) > > Only that in this case I don't get any result. I struggled around for a > couple of hours and I found out I would have to substract 1 millisecond to > the first timestamp filter and add 1 millisecond to the second one in order > to get record A and B. Why is that happening? It doesn't make any sense. > > Appid: domodentweb2 > datastore: HRD > appengine-java > low-level datastore api. > > Thanks in advance, > Cristian. >
-- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/KFRitvDxAi0J. 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.
