Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
685
filters column in or instead of and
posted

Hi,
I need to apply multiple filter to a column but in or condition,

for example col == "aaa" or col == "bbb" or col == "ccc"

i try to add filters using FilterConditions.Add but all filters are in "and" : col == "aaa" AND col == "bbb" AND col == "ccc"

There is a way to use multiple filter in OR ?

Thank you very much.

Andrea

  • 23930
    Offline posted

    Hi Andrea,

    Thank you for contacting Infragistics Developer Support.

    You can change the column filter to OR by setting the LogicalOperator property to “FilterLogicalOperator.Or”. This property is part of the ColumnFilters of each column so in order to set you could use code like:

    ultraGrid1.DisplayLayout.Bands(0).ColumnFilters(0).LogicalOperator = FilterLogicalOperator.Or

    Please let me know if you have any additional questions.