http://cayenne.apache.org/doc30/building-expressions.htmlThat looks right
according to this page:
Character constants should be enclosed in single or double quotes:
// e1 and e2 are equivalentExpression e1 = Expression.fromString("name
= 'ABC'");
Expression e2 = Expression.fromString("name = \"ABC\"");
One link the to formal grammer that I see in a couple places is broken:
formal
grammar<http://incubator.apache.org/cayenne/1_2/grammar/ExpressionParser.html>
But this one works:
http://cayenne.apache.org/doc30/bnf-for-expressionparser.html
It says:
simpleCondition ::= scalarExpression ( simpleNotCondition |
( "=" | "==" ) scalarExpression |
( "!=" | "<>" ) scalarExpression |
I would check the SQL that is outputted and run it against the database
manually - it may be your expectation that is wrong.
John
On Thu, Sep 29, 2011 at 1:23 PM, Richard Frovarp <[email protected]>wrote:
> I'm trying to figure out how to model a couple of named queries, preferably
> in the object modeler:
>
> I've got this working
>
> Qualifier: status = $status
>
> I can't get this working
>
> Qualifier: status = "Completed"
>
> In fact, that query returns nothing, but
>
> status != "Completed"
>
> Returns everything, including objects where status = "Completed".
>
