Well, how about that. Learn something new everyday.
I tried this myself in a quick test. Here's the full SQL from my
test fetch specification:
Fetch Spec:
EOQualifier qual = EOQualifier.qualifierWithQualifierFormat("value3 <
50.0", null);
EOFetchSpecification fs = new EOFetchSpecification("Person", qual,
null);
value3 is the derived attribute...
SQL output:
"SELECT t0.first_name, t0.last_name, t0.id, t0.value_1, t0.value_2,
value_1 + value_2 FROM people t0 WHERE value_1 + value_2 < ?"
withBindings: 1:50.0(value3)>
So in the simple case this appears to work as expected. I would
guess that the derived attribute in question may be too complex for
this to work properly. I've run into similar cases where a fetch
that can be performed in memory cannot be translated to SQL. This
may be what's happening in the case in question.
On Apr 16, 2007, at 4:57 PM, John Huss wrote:
It resolves the attribute names to the columns names as you would
expect, so you get
Select ...
Where (inm_productTax1 + inm_productTax2 + inm_productTax3) > 0
John
On 4/16/07, Robert Walker <[EMAIL PROTECTED]> wrote:
Fetch spec qualifier = "totalTaxes > 0"
Interesting. What does the generated SQL look like?
On Apr 16, 2007, at 3:45 PM, John Huss wrote:
Here's an example:
Attribute name = "totalTaxes"
Attribute derived definition = "productTax1 + productTax2 +
productTax3"
(productTax* are attribute names in the same entity, not the
column names)
Fetch spec qualifier = "totalTaxes > 0"
This works for any kind of fetch spec.
John
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/
robertwalker1%40mac.com
This email sent to [EMAIL PROTECTED]
--
Robert Walker
[EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/johnthuss%
40gmail.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/robertwalker1%
40mac.com
This email sent to [EMAIL PROTECTED]
--
Robert Walker
[EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
