Skip to Content

Exclude Option in ValueHelpDialog

Mar 14, 2017 at 12:03 PM


avatar image

Hi All,

As per the requirement, I have to use the value help dialog control for a field Order with exclude option. I have a range table as input and the filter string need to be passed is $filter=not(order eq ‘value’). Can we achieve this using sap.ui.model.filter?

Please let me know your valuable inputs.


Jeffin George

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Emanuele Ricci Mar 14, 2017 at 03:54 PM

Hi @Jeffin you can do something like this:

new sap.ui.model.Filter(
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Emanele,

Thanks for your replay.

I tried that it works if we have only one condition. I have range table as input and when I use the operator NE as mentioned, the values will be inclusive in the range table, SIGN field will be I. It works fine if there is no other condition.

Suppose I have 2 conditions i.e. Order BT 1 and 3, Order NE 3 and the expected output is Order 1 and 2, but in this scenario it fails. If we are using NE with other condition then it should be exclusive (SIGN = ‘E’) in the range table to get the expected result.


Jeffin George


Hi Jeffin, sorry but I don't get the SIGN field which you are referring to.

Anyway, if you have those two filters you should correctly get the expected result.