# Multiple Values Filter on Power Table

**URL:** <https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138>\
**Category:** Ignition\
**Created:** [November 16, 2021, 5:19pm UTC](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138 "2021-11-16T17:19:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chris\_Mehan](https://avatars.discourse-cdn.com/v4/letter/c/47e85d/32.png) [@Chris\_Mehan](https://forum.inductiveautomation.com/u/Chris_Mehan)\
**Post date:** [November 16, 2021, 5:19pm UTC](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138/1 "2021-11-16T17:19:26Z")

</div>

I am currently working with filters on a power table and found a script that works for a single value, but I have not found a way to use jidesoft MultipleValuesFilter in it’s place; I also haven’t been able to find any good documentation or examples of this.

def setFilter(self, filters):  
model = self.getTable().getModel().getActualModel()  
model.clearFilters()  
from com.jidesoft.grid import MultipleValuesFilter

```
for f in filters:
	class newFilter(MultipleValuesFilter):
		def isValueFiltered(self, value):
			return bool( value != f ) 
	model.addFilter(0, newFilter())
	
model.setFiltersApplied(True)
model.refresh()	

```

This is what I have attempted to put together so far, using the script that I already was using for singlevaluefilter. I pass through an array as the parameter “filters” in a propertyChanged event script, but it creates a new filter that overwrites the last one for each element of the array/list rather than adding it together. I’m not quite sure where to go from here, so any help would be appreciated!  
Thank you.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 16, 2021, 5:43pm UTC](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138/2 "2021-11-16T17:43:02Z")

</div>

I think you’re trying to use MultipleValuesFilter in the wrong way.

Reading the [Javadoc](http://www.jidesoft.com/javadoc/com/jidesoft/grid/MultipleValuesFilter.html), it looks like it just expects you to provide a list of allowed values when you construct it. It’s not OR-ing together multiple filters.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 16, 2021, 5:47pm UTC](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138/3 "2021-11-16T17:47:16Z")

</div>

From the Javadoc on [`IFilterableTableModel`](http://www.jidesoft.com/javadoc/com/jidesoft/grid/IFilterableTableModel.html#setAndMode(boolean)), it looks like it should be fine to directly apply multiple filters to one column; you can just set the `setAndMode(boolean)` to choose AND vs OR behavior for the filters.

---

<div class="post-metadata">

**Author:** ![will\_d](https://avatars.discourse-cdn.com/v4/letter/w/3d9bf3/32.png) [@will\_d](https://forum.inductiveautomation.com/u/will_d)\
**Post date:** [March 13, 2022, 7:02pm UTC](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138/4 "2022-03-13T19:02:11Z")

</div>

@PGriffith  
Apologies for resurrecting an old thread, but the link to the JIDE javadoc is now 404. Is there any other way Ignition (Vision) users can access that documentation?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 14, 2022, 3:03pm UTC](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138/5 "2022-03-14T15:03:12Z")

</div>

I can’t vouch for the legitimacy of the site, but searching `IFilterableTableModel` led me to a third party archive of Jide’s Javadocs:  
[https://www.mvndoc.com/c/org.bidib.com.jidesoft/jide-grids/com/jidesoft/grid/IFilterableTableModel.html](https://www.mvndoc.com/c/org.bidib.com.jidesoft/jide-grids/com/jidesoft/grid/IFilterableTableModel.html)