Calculated values

[Alexandru Dovlecel <al...@siemens.com>]

Hi,

I have a table X connected with a toMany relation to an XHistory table. How
can I obtain the first and the last XHistory.changeDate field for each X in
my select? This would be equivalent with getting the "creation date" and
"last changed date".

I want to select all X that belongs to user with ID = 10, and also to
include those two history entries for each X (the first history and the last
history).

In plain sql would be (I think...)
initdate as MIN( XHistory.dateOfChange ) , chgDate as MAX(
XHistory.dateOfChange ) GROUP BY X.id .

How to do this in Torque???
Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org