Table “and” Filters not working

[nitroplonker]

The issue I am having is that when the filters are run the table always treats the condition as ‘or’ between the columns when it is set to ‘and’.

Here is an example of what is always being treated as ‘or’

 const filterGroup1 = new w.Smart.Utilities.FilterGroup();
const filterObject1: object = filterGroup1.createFilter('string', 'x', 'CONTAINS');
filterGroup1.addFilter('and', filterObject1);
this.table.addFilter("ContactName", filterGroup1);

const filterGroup2 = new w.Smart.Utilities.FilterGroup();
const filterObject2: object = filterGroup2.createFilter('string', 'm', 'CONTAINS');
filterGroup2.addFilter('and', filterObject2);
this.table.addFilter('CustomerID', filterGroup2);

This results in rows being returned if they match either condition of:

“Contact Name” containing X”

or

“CustomerID” containing “M”.

What I want is for only rows that match both conditions to be returned

[admin]

Hi,

At present, filters with addFilter are using ‘or’ between the different filter groups in the Table. We will add an option in a further version to set it to ‘and’, too.

Best regards,
Peter Stoev

Smart UI Team
https://www.htmlelements.com/

[Author]

Posts