It seems to me from first look, that version is a description of invoice - as such the data model is incorrect. Invoice should hang off of job and version should be an attribute of invoice. More of a model issue as opposed to a WO issue.
That would be my sleep deprived red eye flight from SFO view of the issue... Alex Horovitz (978) 808-0808 Sent from my iPhone On Feb 5, 2011, at 7:08 AM, "Theodore Petrosky" <tedp...@yahoo.com> wrote: > 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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/ahorovitz%40brookeside.com > > This email sent to ahorov...@brookeside.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com