Perspective Table - Column filter with multiple entries

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!

I don't think you are missing anything. The Table component's built-in filters are limited in capability. You've got two main options:

  • Modify the query binding based on some selection criteria.
  • Have a standard query (returning all the data) and a script transform to do the filtering.
1 Like

Thanks, we're probably going to pass the parameters to the query and use a WHERE clause. Just making sure there's not some property I'm missing.