Skip to Content
0
Former Member
Nov 12, 2016 at 04:13 PM

odata fillter query

69 Views

I need to make query like this (house eq '54' or house eq '11' and ogrn eq '5147746334160')

but my code my only (house eq '54' and ogrn eq '5147746334160') why?

      oTable.bindRows({
         path: "/Main",
        filters: [new sap.ui.model.Filter([
          new sap.ui.model.Filter({
            path: 'house',
            operator: sap.ui.model.FilterOperator.EQ,
            value1: '54',
            filters: new sap.ui.model.Filter([
              new sap.ui.model.Filter({
                path: 'house',
                operator: sap.ui.model.FilterOperator.EQ,
                value1: '11',
              })
            ], false),
          }),
          new sap.ui.model.Filter({
            path: 'ogrn',
            operator: sap.ui.model.FilterOperator.EQ,
            value1: '5147746334160',
          })
        ], true)],
        events: {
          dataReceived: function (oData) {
            }
          }.bind(this),
          change: function () {
          }.bind(this)
        }
      });