Issue with filtering when using multiple words

bryant.st39 over 8 years ago

We have a grid that has several columns of data. We would like for the user to be able to enter a text string to filter the results in the grid. If the user enters one word, the filter works as expected. However, if the user enters multiple words, the query fails. Any recommendations?

Discussion posts and replies are publicly visible

Parents

0 bryant.st39 over 8 years ago

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
)

}
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 bryant.st39 over 8 years ago

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
)

}
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data