You need to denormalize.  See my prior response for some ideas.
On May 11, 2011 10:32 PM, "Ekta Ganguly" <[email protected]>
wrote:
> I have 2 models:
> class UserRequest(db.Model):
> RequestID = db.StringProperty()
> ApproverSets = db.ListProperty(db.Key) #reference ApproverSet
>
> class ApproverSet(db.Model):
> RequestID = db.StringProperty()
> ApproverUser = db.UserProperty()
> ApproverStatus = db.StringProperty() #Approved, Pending, Rejected
>
> I want to fetch all the records from UserRequest where ApproverStatus
> = Pending for ApproverUser = 'abc'. How can i do it efficiently?
>
> --
> 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.
>

-- 
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.

Reply via email to