I have been trying to filter table data with the "setFilter" command. I managed to figure out 1 condition filtering but how do i filter a table by using a search field which looks for matching string of 2 columns?
Here is what my table looks like
Here is the command i am sending, but if i do this, no filtering works. If i use either 1, it works
Blockquote
msg.payload =
{
"command": "setFilter",
"arguments": [
[
"Location",
"like",
msg.selection
],
[
"State",
"like",
msg.selection
]
],
"returnPromise": true
}
return msg;
Hope someone can help me out on this