Hi All,
I have been looking into the mailing list and docs but I am a bit
confused about what I am supposed to use.
This is my problem.
I have a 1:m relationship between a property and propertyDates.
The property Dates contain a startDate and a endDate and describes a
period that is busy.
I need to make a search and find out ALL the properties that do not have
a busy period.
IN SQL it would look something like this.
SELECT * FROM PROPERTY WHERE NOT EXISTS
(SELECT * FROM PROPERTY_DATES WHERE
PROPERTY_DATES.PROPERTY_ID=PROPERTY.ID
START_DATE < 01/01/04 and
END_DATE < 01/01/04).
However I really don't want to use SQL to do this, I really want to use
OJB. I have seen some things in a thread 'NOT EXISTS CRITERIA' and
explaining the use of a reportQuery but I could not see how to adapt it
to my problem.
Thank you for taking the time to read this.
Frederick Tsang
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
