Exclude Option in ValueHelpDialog

[former_member220538]

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.

Regards,

Jeffin George

[ericci]

Hi @Jeffin you can do something like this:

new sap.ui.model.Filter(
    "order",
    sap.ui.model.FilterOperator.NE,
    "value"
)

[former_member220538]

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.

Regards,

Jeffin George

[ericci]

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.