Issue with filtering when using multiple words

What function are you using to filter? On how many number of columns do you apply the filter function?

I would recommend use like() function in conjunction with filter on array of cdts.

Here is the code we are using, it works fine if the user enters 1 word. We would like the user to be able to enter multiple words and return results for any word:
logicalExpression: a!queryLogicalExpression(
operator: "OR",
filters: {
a!queryFilter(
field: "title",
operator: if(
isnull(
local!searchTerm
),
"not null",
"includes"
),
value: local!searchTerm
),
a!queryFilter(
field: "description",
operator: if(
isnull(
local!searchTerm
),
"not null",
"includes"
),
value: local!searchTerm
)

}
),

Try replacing 'value: local!searchTerm' with 'value: split(local!searchTerm, " ")'

Joshl, Thanks...this is what I did and it works:
logicalExpression: a!queryLogicalExpression(
operator: "OR",
filters: {
apply(rule!MRT_BuildTitleQueryFilter, split(local!searchTerm, " ")),
apply(rule!MRT_BuildDescriptionQueryFilter, split(local!searchTerm, " "))

}
)

Hi, can you share the contents of your MRT rule please. Thanks

Here are the contents:

a!queryFilter(
field: "title",
operator: if(
isnull(
ri!term
),
"not null",
"includes"
),
value: ri!term
)

We are planning to make the number of fields dynamic by building an expression that we can pass the search fields and search terms to, that will build the query filters dynamically.

great - thank you