Hi Ramiro,
I think you can build your Expression such that the relationship from A to
B is null:
ExpressionFactory.matchExp(A.TO_B_PROPERTY, null)
(change the name of the entity/property as appropriate)
mrg
On Wed, Jan 30, 2013 at 12:01 PM, Ramiro Aparicio <
ramiro.apari...@prot-on.com> wrot
This is from an old Cayenne 1.2 project, so the syntax may be a bit
different now.
Basically, you use an outer join and then noMatchExp() against null.
The joined record will have null for all values if the relationship is
empty.
The plus "+" indicates an outer join at this point.
Express
Hi,
An easy question, I want to know all elements of table A that does NOT
have a relationship with table B
A->B 1:N so A id is stored on B
In plain SQL I am using:
"select * from A where idA not in (select idA from B);"
It is not really nice, but works
But using a Expressions seems a lot har
