strict filtering for lists

[aakashpolra]

There seems to be a filtering issue when the column filter type is set to 'list' and no custom filters are used, it does not filter "strictly".

For example, if the filter items in the list contain: "Car" and "Cardboard", selecting Car would also display Cardboard items.

The workaround here, of course, is to use a custom filter but I believe it makes sense to have the default behaviour to perform strict matches when using 'list' filter type. Alternatively, there could be an option to enable strict filtering.

[OwenLin-lwc]

I use filterFunction to solve this problem.

export const TableConfig = {
columns: {
Item: {
filter: {
type: 'list'
config: {
selectText: 'All',
list: ['Car', 'Cardboard'],
}
},
filterFunction(cell?: string, search?:string): boolean {
return cell === search;
}
}
}
}

[renanaribeiro]

I use filterFunction to solve this problem.

export const TableConfig = {
columns: {
Item: {
filter: {
type: 'list'
config: {
selectText: 'All',
list: ['Car', 'Cardboard'],
}
},
filterFunction(cell?: string, search?:string): boolean {
return cell === search;
}
}
}
}

This worked for me, thanks. Use the following as example:

columnName: {
title: 'Type',
type: 'list',
valuePrepareFunction: (type) => type.name, (if retrieved from nested json)
filterFunction(cell?: any, search?: any): boolean {
return cell.id === Number(search);
},
filter: {
type: 'list',
config: {
selectText: 'Select a type...',
list: [
{ value: 1, title: 'Type 1'},
{ value: 2, title: 'Number 2'},
{ value: 3, title: 'Others'},
],
},
},