和/或过滤器阵列之间

Question

所以我有两个滤波器数组，而不仅仅是与和/或运算符兼容和让UI5选择/将相应的属性分组，我想在两个滤波器阵列之间执行AN和。

我尝试将两个过滤器数组和添加和。但这无效。

var kFilter = new Filter({
  filters: [
    dFilters,
    bFilters
  ],
  and: true
});

Answer 1

var aFilter = [];
var aOrFilter = [];
var aAndFilter = [];
//Create filter array for OR condition
aOrFilter[
    new sap.ui.model.Filter("Property1", sap.ui.model.FilterOperator.EQ, sValue),
    new sap.ui.model.Filter("Property2", sap.ui.model.FilterOperator.EQ, sValue)
];
//Create filter array for AND condition
aAndFilter[
  new sap.ui.model.Filter("Property3", sap.ui.model.FilterOperator.EQ, sValue),
  new sap.ui.model.Filter("Property4", sap.ui.model.FilterOperator.EQ, sValue)
];
//Concatinating both filter arrays with AND condition
aFilter = new sap.ui.model.Filter([
    new sap.ui.model.Filter(aOrFilter, false), //Filters get OR codition
    new sap.ui.model.Filter(aAndFilter, true) //Filters get AND condition
], true); //Concatinating both with AND condition

结果：

(Property1 EQ "XXX" OR Property2 EQ "XXX") AND (Property3 EQ "XXX" AND Property4 EQ "XXX")