筛选多列 [英] Filter on more than one column

问题描述

我有一个可以从一列中过滤的表格:

I have a table that I can filter from one column:

  handleSearch: function(oEvent) {
                var sValue = oEvent.getParameter("value");
                var oFilter = new sap.ui.model.Filter("RAG_SOC_1", sap.ui.model.FilterOperator.Contains, sValue);
                var oBinding = oEvent.getSource().getBinding("items");
                oBinding.filter([oFilter]);
          },

如何从更多列中过滤?

例如，如果我有 A、B、C 和 D 列，如果我在搜索栏中输入你好"，我希望所有在字段 A 或 B 或 C 或 D 中包含你好"一词的结果.

For example if I have the columns A, B, C and D, if I write "hello" in the search bar, I want all results that have in fields A or B or C or D the word "hello".

推荐答案

请看以下代码:

var oFilter1 = new sap.ui.model.Filter("A", sap.ui.model.FilterOperator.Contains, sValue);
var oFilter2 = new sap.ui.model.Filter("B", sap.ui.model.FilterOperator.Contains, sValue);
var oFilter3 = new sap.ui.model.Filter("C", sap.ui.model.FilterOperator.Contains, sValue);
var oFilter4 = new sap.ui.model.Filter("D", sap.ui.model.FilterOperator.Contains, sValue);
var allFilter = new sap.ui.model.Filter([oFilter1,oFilter2,oFilter3,oFilter4]); 
var oBinding = oEvent.getSource().getBinding("items");
oBinding.filter(allFilter);

请参阅文档:

new sap.ui.model.Filter(aFilters, bAnd);

new sap.ui.model.Filter(aFilters, bAnd);

aFilters 是 sap.ui.model.Filter 的其他实例的数组.如果设置了 bAnd，则过滤器中的所有过滤器都将进行 AND 运算，否则它们将进行 OR 运算.

aFilters is an array of other instances of sap.ui.model.Filter. If bAnd is set all filters within the filter will be ANDed else they will be ORed.

这篇关于筛选多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！