Then I don't understand what you are trying to fetch. Could you explain the meaning of the query?

Thanks,
Andrus

On Jan 16, 2009, at 2:17 PM, Sid Ferreira wrote:

select1 = new SelectQuery(UsuariosClientes.class);
select1 .andQualifier (ExpressionFactory.matchDbExp(UsuariosClientes.CD_CLIENTE_PK_COLUMN,
this.cdCliente));

Didn't worked...

On Fri, Jan 16, 2009 at 8:38 AM, Andrus Adamchik <[email protected] >wrote:

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





--
Sidney G B Ferreira
Desenvolvedor Web - Tibox Innovations

Reply via email to