Expressions are immutable, so "qualifier4.orExp(qualifier3)" does nothing. You need to do something like qualifier4 = qualifier4.orExp(qualifier3);
2009/1/16 Sid Ferreira <[email protected]> > Ok, worked and fixed, but not 100%... Now Im using: > > qualifier1 = ExpressionFactory.matchDbExp("cd_cliente", 10); > qualifier2 = > ExpressionFactory.likeIgnoreCaseExp(UsuariosClientes.NM_PESSOA_PROPERTY, > "%"+dsQuery+"%"); > qualifier3 = > ExpressionFactory.likeIgnoreCaseExp(UsuariosClientes.DS_CARGO_PROPERTY, > "%"+dsQuery+"%"); > qualifier4 = > > ExpressionFactory.likeIgnoreCaseExp(UsuariosClientes.DS_DEPARTAMENTO_PROPERTY, > "%"+dsQuery+"%"); > qualifier4.orExp(qualifier3); > qualifier3.orExp(qualifier2); > qualifier1.andExp(qualifier2); > select1 = new SelectQuery(UsuariosClientes.class); > select1.orQualifier(qualifier2); > > But the SQL: > SELECT * > > FROM public.usuarios_clientes t0 > WHERE t0.nm_pessoa ILIKE ? > > What is wrong? Seem that it takes only one of the parameters... > > On Fri, Jan 16, 2009 at 11:52 AM, Sid Ferreira <[email protected]> wrote: > > > Cache... seem that I wasn't refreshing properly my application...Anyway, > > trying again the pk field... > > > > > > On Fri, Jan 16, 2009 at 11:38 AM, Andrus Adamchik < > [email protected]>wrote: > > > >> > >> On Jan 16, 2009, at 3:35 PM, Sid Ferreira wrote: > >> > >> a long > >>> > >> > >> And what SQL did it generate? Was there an exception? > >> > >> Andrus > >> > > > > > > > > -- > > Sidney G B Ferreira > > Desenvolvedor Web - Tibox Innovations > > > > > > > -- > Sidney G B Ferreira > Desenvolvedor Web - Tibox Innovations >
