Hi Andy,
The datastore is not a relational database. You probably need to
denormalize the data a little. I would suggest you store some of the
information from the parent on the child entities. Or, in this case
perhaps on the parent kind you can add another property, such as
"all_children_applied = db.BoolenProperty()", to query on. You just
need to keep it updated when you modify the children statuses.
You might also check out:
http://code.google.com/appengine/articles/modeling.html
Robert
On Wed, Mar 2, 2011 at 23:06, andy <[email protected]> wrote:
> I have Employee and Leave Transactions Details entities in one to many
> relation when i execute a query against Employee(parent) i am getting
> the result of employee and its responding leave transaction but if i
> need the information based on child properties (like 'Status' if
> Status is "Applied" ) then only retrieve the specific properties
> (rather than all details) of employee and leave transaction details.
> what you have suggested is right but using that i only get the
> child information but i want to include the parent also.
> one more can include more than one entity in query, like joining two
> tables/entity
>
> On Mar 3, 5:08 am, Robert Kluin <[email protected]> wrote:
>> Hey Andy,
>> One way would be to include information from the parent on the child
>> entities, then you'll only have to query against the child entities.
>> There may be other ways too, depending on exactly what you're doing.
>> If you include your model definitions and some details about the
>> queries someone can probably give more details.
>>
>> Robert
>>
>> On Wed, Mar 2, 2011 at 06:29, andy <[email protected]> wrote:
>> > I have created the one to many relation for Employee(parent) and his
>> > leave transaction details(child).
>> > I can give a query based on parent properties but i m not getting how
>> > to fetch data based leave details?
>> > Means i wants to fetch the data which satisfies the both conditions of
>> > parent field and child field. can it b possible ?
>>
>> > --
>> > 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
>> > athttp://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.
>
>
--
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.
