Hi Sid,
Two possible approaches:
1. (preferred) matching on a related object. That's the point of ORM
after all to work with objects, not DB keys.
2. If this is not possible, you can use the same approach as with PK
matching. The only difference is that there's no generated constant
for the FK, so you'd specify a string column name. E.g., continuing
with your code example:
select1.andQualifier(ExpressionFactory.matchDbExp("fk_column",
value));
Andrus
On Jan 15, 2009, at 9:34 PM, Sid Ferreira wrote:
qualifier1 =
ExpressionFactory
.matchExp("db:"+UsuariosClientes.CD_CLIENTE_PK_COLUMN,
getCdCliente());select1 = new SelectQuery(UsuariosClientes.class,
qualifier1);
How to make a select using a PFK (primary key AND foreign key) field?
--
Sidney G B Ferreira
Desenvolvedor Web - Tibox Innovations
