Greetings!
I have a Perspective table that I would like to filter based on a particular column. While the table component has this capability, I can't seem to allow the user to filter on an OR condition with multiple values. The manual doesn't seem to tackle this exact condition unless you use the overall table filter but then you lose column-specific filtering. So before I go modify the view and associated named queries to allow filtering of the the original dataset before displaying in the table, is there something I'm missing?
{
"enabled": true,
"visible": "always",
"string": {
"condition": "contains",
"value": "Dog"
}
}
Result: Good. Filtered to entries that contain "Dog"
{
"enabled": true,
"visible": "always",
"string": {
"condition": "contains",
"value": ["Dog","Cat"]
}
}
Result: Bad. Filter does not appear to work. Entire dataset is displayed.
{
"enabled": true,
"visible": "always",
"string": {
"condition": "contains",
"value": "Dog,Cat"
}
}
Result: Bad. Of course, there are no entries with a single string that says "Dog,Cat"
Thanks!