Business Object : Data Provider query filters not working

[Former Member]

Hi there,

I have made a BO report out of a DB where query filters in my data provider doesn't seem to work.

My DB contains the following data :

Person -> Value

AN0004N -> ON

AN0004D-> ST OW

AN0004E -> BI--BI-----

... if I do not put any filter on the "Value", all 3 entries are displayed with the correct PErson and Value. But If I enter a query filter on Value "ON", then AN0004N is displayed with Value ON and AN0004D and AN0004E are displayed with an empty field for "Value"

?!?

If I enter a query filter on Value "ST OW", then AN0004D is displayed with Value ST-OW and AN0004N and AN0004E are displayed with an empty field for "Value"

...

in other words the filter is correctly displaying the value I want to filter on, but displays the non filter values as empty instead of just not displaying the lines at all ?!?

Any idea what that could be ? Many thanks !!

[amitrathi239]

Can you please share the screenshot?