|
I have an Application object and a User object
which have a many to many relation.
The Application object has a many to many
relationship with the User object and the
collection of users is stored in an attribute of
the Application object called "customers".
I want to specify an OQL query that will return the
list of applications for a given user.
I have tried the following queries but get an
exception saying "invalid column type" due to the generated
SQL.
SELECT a FROM
com.littlecatz.silverback.business.Application a WHERE a.customers.id =
$1
or
SELECT a FROM
com.littlecatz.silverback.business.Application a WHERE a.customers =
$1
Can anyone tell me the correct OQL syntax to use here? |
