Database Search Against Multiple Fields

Ask the community
,
9

@cwvega76 , thanks for sharing! :blush:
It was helpful for me with a repeater filtering multiple fields:

let lastSearchValue;
function filter(searchValue) {
    if(searchValue !== lastSearchValue) {
        $w('#contactsDataset').setFilter(
            wixData.filter().contains('title', searchValue)
            .or(wixData.filter().contains('position', searchValue))
            .or(wixData.filter().contains('department', searchValue))
        );
        lastSearchValue = searchValue;
    }
}