# Perspective Table - Column filter with multiple entries

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-multiple-entries/91819>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 13, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-multiple-entries/91819 "2024-06-13T13:10:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dhiren.naidoo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhiren.naidoo/32/19485_2.png) [@dhiren.naidoo](https://forum.inductiveautomation.com/u/dhiren.naidoo)\
**Post date:** [June 13, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-multiple-entries/91819/1 "2024-06-13T13:10:11Z")

</div>

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?

```python
{
  "enabled": true,
  "visible": "always",
  "string": {
    "condition": "contains",
    "value": "Dog"
  }
}

```

Result: Good. Filtered to entries that contain "Dog"

```python
{
  "enabled": true,
  "visible": "always",
  "string": {
    "condition": "contains",
    "value": ["Dog","Cat"]
  }
}

```

Result: Bad. Filter does not appear to work. Entire dataset is displayed.

```python
{
  "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!

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [June 13, 2024, 5:26pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-multiple-entries/91819/2 "2024-06-13T17:26:31Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dhiren.naidoo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhiren.naidoo/32/19485_2.png) [@dhiren.naidoo](https://forum.inductiveautomation.com/u/dhiren.naidoo)\
**Post date:** [June 19, 2024, 1:49pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-multiple-entries/91819/3 "2024-06-19T13:49:13Z")

</div>

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.