Re: inner join query help
Re: inner join query help
- Subject: Re: inner join query help
- From: "Alex Horovitz" <email@hidden>
- Date: Sat, 5 Feb 2011 07:50:14 -0500
- Thread-topic: inner join query help
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" <email@hidden> 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 (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden