# Reporting module: Table filter key

**URL:** <https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649>\
**Category:** Ignition\
**Created:** [October 22, 2015, 12:12pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649 "2015-10-22T12:12:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rinze.oost](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@rinze.oost](https://forum.inductiveautomation.com/u/rinze.oost)\
**Post date:** [October 22, 2015, 12:12pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649/1 "2015-10-22T12:12:29Z")

</div>

I am building a new report in the reporting module.  
I want to filter the data in a table with a key word. (the query selects all data and i want to display this data per engine in a separate table)

Displaying all the data is no problem but when i use the Filter key i cant filter the data.  
Example data collected with query:  
Engine 1  
Engine 2  
Engine 3

Filter key: Engine 1

Result: No data displayed.

See also the attachment.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/cf9b5e02d3e46b40607df4cc38392a198ddf9828.jpg)

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [October 22, 2015, 2:08pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649/2 "2015-10-22T14:08:43Z")

</div>

Thanks for the detailed picture. If only every question was so clearly illustrated! ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")

The Filter Key is an expression that evaluates to true/false (see [the docs on tables](https://docs.inductiveautomation.com/display/DOC/Report+Tables)). I would try using something along the lines of `engine = "Engine 1"`

---

<div class="post-metadata">

**Author:** ![rinze.oost](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@rinze.oost](https://forum.inductiveautomation.com/u/rinze.oost)\
**Post date:** [October 22, 2015, 2:46pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649/3 "2015-10-22T14:46:07Z")

</div>

[quote=“KathyApplebaum”]Thanks for the detailed picture. If only every question was so clearly illustrated! ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")

The Filter Key is an expression that evaluates to true/false (see [the docs on tables](https://docs.inductiveautomation.com/display/DOC/Report+Tables)). I would try using something along the lines of `engine = "Engine 1"`[/quote]

Thanks for the response and the manual lookup.  
I tried your suggestion but the filtering still does not work.  
With the filter setup to:  
engine = “Engine 1”  
I get the same data as without the filter.

---

<div class="post-metadata">

**Author:** ![PerryAJ](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/perryaj/32/3281_2.png) [@PerryAJ](https://forum.inductiveautomation.com/u/PerryAJ)\
**Post date:** [October 22, 2015, 3:49pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649/4 "2015-10-22T15:49:51Z")

</div>

Think Kathy forgot an “=” sign. Just tried out a filter on a table and it worked using standard Java style notation. The [keychain expression docs](https://docs.inductiveautomation.com/display/DOC/Key+Calculations) have a breakdown of the different operators.

Give this a shot:

```auto
engine == "Engine 1"
```

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [October 22, 2015, 4:13pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649/5 "2015-10-22T16:13:42Z")

</div>

Sorry, that’s what I get for posting code before sufficient caffeine intake. 😊

---

<div class="post-metadata">

**Author:** ![rinze.oost](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@rinze.oost](https://forum.inductiveautomation.com/u/rinze.oost)\
**Post date:** [October 22, 2015, 5:40pm UTC](https://forum.inductiveautomation.com/t/reporting-module-table-filter-key/10649/6 "2015-10-22T17:40:27Z")

</div>

Thanks all for the support.  
The last tip did the trick.