title: How to filter odata service with mutiple filter input values from Filterbar control & bind the filtered result set to Table
body: <p>I need to filter the odata service with multiple filter items and bind result set to table. This whole action will take place on click of search button. Below is my Onsearch event code which is failing in read function and not returning a result and not able to bind it to table. Can anyone please me help on this?</p>
  <h3>Controller Code</h3>
  <pre class="lang-js prettyprint-override"><code>onFinalFilter: function (oEvent) {
  
  debugger; 
  var oPlant = this.getView().byId(&quot;plant&quot;).getValue();
  
  var oName1 = this.getView().byId(&quot;name1&quot;).getValue();
  
  var oName2 = this.getView().byId(&quot;name2&quot;).getValue();
  
  var oState = this.getView().byId(&quot;State&quot;).getValue();
  
  var oCity = this.getView().byId(&quot;city&quot;).getValue();
  
  var oZip = this.getView().byId(&quot;zip&quot;).getValue();
  
  var oCompanyCode = this.getView().byId(&quot;companyCode&quot;).getValue();
  
  var p = new Filter(&quot;WERKS&quot;, FilterOperator.EQ, oPlant);
  
  var n1 = new Filter(&quot;NAME1&quot;, FilterOperator.EQ, oName1);
  
  var n2 = new Filter(&quot;NAME2&quot;, FilterOperator.EQ, oName2);
  
  var s = new Filter(&quot;STATE&quot;, FilterOperator.EQ, oState);
  
  var c = new Filter(&quot;CITY&quot;, FilterOperator.EQ, oCity);
  
  var cc = new Filter(&quot;BUKRS&quot;, FilterOperator.EQ, oCompanyCode);
  
  var zip = new Filter(&quot;PSTCODE&quot;, FilterOperator.EQ, oZip);
  
  var finalFilter = new Filter({filters:[p,n1,n2,c,s,zip,cc], and:true});
  
  var oModel = new sap.ui.model.odata.v2.ODataModel(&quot;/sap/opu/odata/sap/ZSM_PLANTSRCH_SRV/&quot;); sap.ui.getCore().setModel(oModel);
  
  var oModel2 = new sap.ui.model.json.JSONModel();
  
  oModel.read(&quot;/PLANTSRCHSet&quot;, {
  
  filters: finalFilter, 
  
  success: function (oData, oResponse)
  
  { var data = oData; oModel2.setData(data); this.getView().byId(&quot;table1&quot;).setModel(oModel2, &quot;key2&quot;); },
  
  error: function (oError) { //alert(&quot;error&quot;); } });
  
  }
  </code></pre>
  <h3>View</h3>
  <p><img src="https://i.stack.imgur.com/Idji5.png" alt="view" /></p>
  <h3>Console Log</h3>
  <p><img src="https://i.stack.imgur.com/TiQSY.png" alt="Console Log:" /></p>
  <h3>Filterbar Fragment</h3>
  <p><img src="https://i.stack.imgur.com/ipntk.png" alt="Filterbar Fragment" /></p>