Using an "Or" operator to filter by multiple fields in a dataset at once for a repeater

Ask the community
,
1

Thanks in advance for the help! I’ve looked around for a simple answer for this, and I’ve struggled to find one that makes sense for a novice coder like me. I have a repeater that displays rows from my dataset, called #profiles. I created a search bar (#iSearch) that, on keypress, I would like to filter my dataset to only rows containing that information. I started with one field, ‘description’, and below is the code. It actually works, and it’s based on this video here.

import wixData from "wix-data";

export function iSearch_keyPress(event) {
filter($w('#iSearch').value);
}

function filter(search) {
$w('#profiles').setFilter(wixData.filter().contains('description',search));
}

What I’d like to do is add an “or” function, so I can see if the provided text is in any field in the dataset, such as another field called ‘institution’ or ‘services’. I tried the code below, but it still only searches the ‘description’ field and ignores the ‘institution’ field.

function filter(search) { $w('#profiles').setFilter(wixData.filter().contains('description' || 'institution',search));
}

Any help would be appreciated!

2

You’ll need to use .or( ). See:
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFilter (the example section)
https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html#or

3

Thanks! How would I integrate that with the code above?

4

See the example in the first link and try to adjust it to your own filter.

5

Thanks for your help! I certainly looked at all the information, but I’m afraid I don’t know how I’d go about adjusting it to my own filter. I’d just like the filter to apply to multiple fields.

6

@shaner try to write the code based on the linked example, and if it doesn’t work, post your code here.

7

Appreciate your patience. I did my best to integrate that or() function, and I can get the code inside the function to work (calling it here to filter the “institution” field), but now the previous filter (for the “description” field) isn’t responding.

import wixData from "wix-data";

export function iSearch_keyPress(event) {
	filter($w('#iSearch').value);
}

function filter(search) {
	$w('#profiles')
	.setFilter(wixData.filter()
		.contains('description',search)
		.or(
$w('#profiles').setFilter(wixData.filter().contains('institution',search))
		)
	);
}
8

@shaner try:

function filter(search) {
	let filter = wixData.filter().contains('description',search)
		.or(wixData.filter().contains('institution',search));
	$w('#profiles').setFilter(filter);
}
9

This is exactly what I needed, thank you. I kinda see how it works, and I’m even able to expand it to include more and more data fields. I appreciate your help, this is exactly what I was hoping for.

10

@shaner you’re welcome:)