CODEWITHSUNDEEP
filterbindingsapui5operation
iach
iach

Reputation: 247

SAPUI5 filter with and-operation over multiple arguments

I would like the implement multiple filter for the search on a table binding. The requirement is to associate multiple filter with an and-condition:

Pseudo code: 

if(filterA && filter1 || filterB && filter1 || filterC && filter1 ){...}

How can I achieve it?

I tried with the following:

var filter1 = [ new sap.ui.model.Filter("desc", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flag", FilterOperator.NE, 'X')];
                var filter2 = [ new sap.ui.model.Filter("costnr", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flag", FilterOperator.NE, 'X')];
                var filter3 = [ new sap.ui.model.Filter("location", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flag", FilterOperator.NE, 'X')];
                var filter4 = [ new sap.ui.model.Filter("location2", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flag", FilterOperator.NE, 'X')];
                var filter5 = [ new sap.ui.model.Filter("street", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flag", FilterOperator.NE, 'X')];
                var filter6 = [ new sap.ui.model.Filter("houseno", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flag", FilterOperator.NE, 'X')];
                var filter7 = [ new sap.ui.model.Filter("customer", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flag", FilterOperator.NE, 'X')];
                var filter8 = [ new sap.ui.model.Filter("ordernr", FilterOperator.Contains, sQuery), new sap.ui.model.Filter("flaga", FilterOperator.NE, 'X')];
                var oFilterExt = new sap.ui.model.Filter({filters: [filter1,filter2, filter3, filter4, filter5, filter6, filter7, filter8], and: false}); 

                //binding
                binding.filter(oFilterExt, sap.ui.model.FilterType.Application);

Upvotes: 0

Views: 4245

Answers (1)

schnoedel
schnoedel

Reputation: 3948

You were on the right track with the and property:

new sap.ui.model.Filter({ 
   and:false, 
   filters: [
      new sap.ui.model.Filter({
         and: true,
         filters: [
            new sap.ui.model.Filter("property1", FilterOperator.Contains, sQuery),
            new sap.ui.model.Filter("property2", FilterOperator.Contains, sQuery)
         ]}),
      new sap.ui.model.Filter({
         and: true,
         filters: [
            new sap.ui.model.Filter("property3", FilterOperator.Contains, sQuery),
            new sap.ui.model.Filter("property4", FilterOperator.Contains, sQuery)
         ]}),
      new sap.ui.model.Filter({
         and: true,
         filters: [
            new sap.ui.model.Filter("property5", FilterOperator.Contains, sQuery),
            new sap.ui.model.Filter("property6", FilterOperator.Contains, sQuery)
         ]})
   ]});

Upvotes: 4

Related Questions