Where where clause is filtering on the __key__ field of the ActivityCompletion entity and not the User field. I assume it should look something like:
where user = Key('User',9122) if user keys or numbers and not strings otherwise where user = Key('User',9122) Also, I'm assuming ActivityCompletion is not the parent of User in which case the key would need that information but that would be a strange design On Wed, Dec 22, 2010 at 10:17 AM, stace <mspan...@gmail.com> wrote: > I am using Google App Engine for the backend to my elearning app. I am > trying to to a GQL query in the admin dashboard, in order to find > ActivityCompletion records for a certain user. The user field (or whatever > the non relational equivalent to 'field' is!) is called user, and uses a KEY > for the value. > > From my research this seems like it should work, but it does not: > > select __key__ from ActivityCompletion where __key__ = Key('User', '9122') > > I also tried: select __key__ from ActivityCompletion where __key__ = > Key('User', 9122) > > This does not work to pull up the user whose Entity key (after decoding) is > 9122. Any GAE experts out there with any idea how to do this query > successfully? 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 google-appeng...@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine+unsubscr...@googlegroups.com<google-appengine%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.