Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 518 invoked from network); 21 Jul 2008 07:40:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Jul 2008 07:40:19 -0000 Received: (qmail 81643 invoked by uid 500); 21 Jul 2008 07:40:19 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 81633 invoked by uid 500); 21 Jul 2008 07:40:19 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 81622 invoked by uid 99); 21 Jul 2008 07:40:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Jul 2008 00:40:18 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of w.maaskant@tsi-solutions.nl designates 217.119.231.78 as permitted sender) Received: from [217.119.231.78] (HELO mail.tsi-solutions.nl) (217.119.231.78) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Jul 2008 07:39:24 +0000 Received: by mail.tsi-solutions.nl (Postfix, from userid 99) id 583C41A54006; Mon, 21 Jul 2008 09:39:17 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on mail.tsi-solutions.nl X-Spam-Level: Received: from [192.168.168.120] (gw.neptunusstraat.xentaur.nl [77.222.64.84]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mail.tsi-solutions.nl (Postfix) with ESMTP id 0461E1A54005 for ; Mon, 21 Jul 2008 09:39:16 +0200 (CEST) Message-ID: <48843D22.8070106@tsi-solutions.nl> Date: Mon, 21 Jul 2008 09:39:14 +0200 From: Wout User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: user@cayenne.apache.org Subject: Re: Retrieve extra, generated column when loading objects References: <487B382A.8080302@tsi-solutions.nl> <8f985b960807140812v7de4370eo14a0a72cd5014ab0@mail.gmail.com> In-Reply-To: <8f985b960807140812v7de4370eo14a0a72cd5014ab0@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, score=-100.0 required=5.0 tests=USER_IN_WHITELIST autolearn=failed version=3.2.4 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