cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wout <w.maask...@tsi-solutions.nl>
Subject Re: Retrieve extra, generated column when loading objects
Date Mon, 21 Jul 2008 07:39:14 GMT
Mike Kienenberger schreef:
> Wout wrote:
>> I am building a complaint management system. When I'm loading a
>> list of complaints, I'd like to retrieve an extra column that
>> contains some information that is determined in SQL on the fly.
> 
> 2) Create a view in oracle so that the computed value of TOO_LATE 
> looks like a column.
> 
> You might need to use method 2) since your value is dependent on 
> SYSDATE.  If you were willing to switch it to depend on the system 
> date of the client, you could use method 1).

Thanks for the tip! I hadn't even thought of views. I'm now using views, 
because I need to be able to sort and filter my results on the extra column.

Best regards,

  Wout

Mime
View raw message