On Sun, Jun 14, 2009 at 1:12 PM, NealWalters wrote:
> The one thing I haven't seen discussed though is that you cannot do an
> order-by on fields from both tables.
You do that by copying the relevant fields to the "child" entities
(the "m" side of the 1-m relationship).
Dave.
--~--~-~
In InvoiceDetails add this:
invoice = db.ReferenceProperty(Invoice, collection_name='invoice-
invoicedetails')
For more details see this video and/or slides with full code examples:
http://sites.google.com/site/io/working-with-google-app-engine-models
The one thing I haven't seen discussed th
Thanx for reply adam, the following is the scenario wht i am need.
i have two tables,
1. Invoice Header --> Inv#, po#, invdate, totaltamt, companyID
2. InvoiceDeatils--> Inv#, itemid, qty, desc, qty,tax1, tax2.
the above is my datatables, now i want to to make this tables as 1-M
relationship t
The correct solution to the lack of JOIN depends on the exact nature
of the data that you are modelling. You may need to denormalize your
data, as the normalization that works for a relational database will
make working with the GAE datastore difficult or impossible. You may
need to think about yo