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
