I could fairly easily do this in SQL with a join but i am lost in WO.
I have two entitiesVersion 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
Hi Ted,
I'm not 100% clear on exactly what you want. It sounds like you want to get a
list of all Versions, regardless if they have an invoice or not. Is that
correct? If so:
In SQL you'd use an outer join if you wanted both Version and Invoice
information in one result and you wanted to see
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
...@avendasora.com wrote:
From: David Avendasora webobje...@avendasora.com
Subject: Re: inner join query help
To: Theodore Petrosky tedp...@yahoo.com
Cc: webobjects-dev@lists.apple.com
Date: Saturday, February 5, 2011, 7:33 AM
Hi Ted,
I'm not 100% clear on exactly what you want. It sounds
it my full attention.
Ted
--- On Sat, 2/5/11, David Avendasora webobje...@avendasora.com wrote:
From: David Avendasora webobje...@avendasora.com
Subject: Re: inner join query help
To: Theodore Petrosky tedp...@yahoo.com
Cc: webobjects-dev@lists.apple.com
Date: Saturday, February 5, 2011, 7
.
Ted
--- On Sat, 2/5/11, David Avendasora webobje...@avendasora.com wrote:
From: David Avendasora webobje...@avendasora.com
Subject: Re: inner join query help
To: Theodore Petrosky tedp...@yahoo.com
Cc: webobjects-dev@lists.apple.com
Date: Saturday, February 5, 2011, 7:33 AM
Hi Ted,
I'm