Hi

we use a set of filters to define a customer specific view on BO/table. If we enable more than one filter per BO the filters are bound via AND.

Is there a way to enable additional filters that will be OR combined?

We tried to dynamically create the sql where clause but this fails as the parameter are injected as string parameters and won't be executed.

i.e.
-------------------------------------------------------------
<filter name="UserAccountBo_Generic"><![CDATA[(:dynamic) ]]></filter>

<filter-def name="UserAccountBo_Generic">
<filter-param name="dynamic" type="string" />
</filter-def>
-----------------------------------------------
String dynamicSql = "( ( 'Horst' = LOGIN_NAME)) OR ( ( 'Horst' = PASSWORD))" ;

filter.setParameter("dynamic", dynamicSql );
--------------------------------------------------------------
translates to
select * ... where ( ' ( ( 'Horst' = LOGIN_NAME)) OR ( ( 'Horst' = PASSWORD)) ' )
--------------------------------------------------------------


Any hints appreciated
Cheers
Wilko