Wow I can't type this morning.
"Your" 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 "are" 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:30 AM, Stephen Johnson <[email protected]>wrote:
> 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 <[email protected]> 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 [email protected].
>> To unsubscribe from this group, send email to
>> [email protected]<google-appengine%[email protected]>
>> .
>> 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 [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.
