Re: criteria on calculated columns

[Raymond Barlow]

Thanks for the reponse Jakob. Now, at least, I know I was doing things 
the right way!

-Raymond

Jakob Braeuchi wrote:

hi raymond,

the short answer is 'NO'. ojb does not know that totalDays can be 
calculated.
you could try to use Criteria#addSql() but then you have to specify 
the column names not the attribute names.

jakob

Raymond Barlow wrote:

Hi guys,

I have an object that is persisted, but not all of the columns exist 
in the database. Some of the columns are calculated in the object and 
are read only. As an example, lets say that the object is a Period 
object with 3 fields: dateFrom, dateTo and totalDays. totalDays here 
can be calculated as dateTo-dateFrom (or some other business logic).

Is it possible to use OJB's QueryByCriteria to retreive where (for 
example) totalDays < 10? If so, how?

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

--
Regards,
Raymond Barlow


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]