cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: How to?
Date Fri, 16 Jan 2009 10:38:43 GMT
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


Mime
View raw message