I could fairly easily do this in SQL with a join but i am lost in WO.
I have two entities Version Invoice
my full schema looks like:
ParentCompany toMany
Client toMany
Project toMany
Job toMany
Version toOne
Invoice
The Version may have many invoices because the version may be partially billed.
in my Invoice report, I will see:
Version 1 partial 01-01-2011
Version 1 final 01-30-2011
Version 3 final 01-05-2011
So what happened to version 2. The version was killed in production. there will
be no version 2 invoice. (Let's also add that there could be a version 2.1 or
even 2.1 subversion 1 and any of these could be killed.)
Invoice only records the versions that are invoiced. so indeed there could be
versions not included in the invoice list.
Normally I would join the invoice list against the version list. Then I would
have a complete list of invoices and versions. There would be no 'holes' where
a version was killed.
Version 1 partial 01-01-2011
Version 1 final 01-30-2011
Version 2 killed
Version 2.1 final 01-30-2011
Version 3 final 01-05-2011
How to do this the WO way?
I hope I am clear.
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
