# \[Bug-13951\] Perspective Table Filters

**URL:** <https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109>\
**Category:** Ignition Early Access\
**Created:** [May 17, 2019, 6:22pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109 "2019-05-17T18:22:12Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [May 17, 2019, 6:22pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/1 "2019-05-17T18:22:12Z")

</div>

I was trying to switch a screen over from using a custom filter textbox to the filter built into the table component, but I’m running into some issues. I can type any string into the box as long as it wouldn’t return any values. If The string I enter would return a value, the page locks up and crashes.

The only line in the logs shows:  
Websocket connection closed unexpectedly. code=1006, reason=WebSocket Read EOF

I attached a video below  
https:/uploads/iatesting/original/2X/a/a390e889945aed72de9d82c16caba1b75b3b1bbb.mp4

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [May 17, 2019, 6:26pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/2 "2019-05-17T18:26:23Z")

</div>

Made too many changes at once and missed something. Issue occurs when results is enabled. Regardless of what I mentioned in the previous revision of this post.

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [May 17, 2019, 9:14pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/3 "2019-05-17T21:14:34Z")

</div>

While it’s clear that there is an issue in play here, I’m not able to replicate locally (Filtering arguably works better than expected for me). What are you attempting to supply in the filter when it breaks?

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [May 20, 2019, 11:48am UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/4 "2019-05-20T11:48:28Z")

</div>

> [@cmallonee](#):
>
> While it’s clear that there is an issue in play here, I’m not able to replicate locally (Filtering arguably works better than expected for me). What are you attempting to supply in the filter when it breaks?

I enter some of my generic part numbers. PN1, PN2 or PN3. The data comes from a named query, that is providing a large number of rows(140k), which may play into it as well.

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [May 20, 2019, 2:47pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/5 "2019-05-20T14:47:50Z")

</div>

I’m still trying to replicate, but it’s very likely that the dataset size is the issue as storing those results with that search string would in essence double your dataset (_every_ entry will be stored in results for key press “P”, and then results will be wiped and re-populated when “N” is pressed). It isn’t until you actual supply the numeric value of the part number where `props.filter.results` would be anything smaller than the original dataset. Right, @ynejati?

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [May 20, 2019, 2:55pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/6 "2019-05-20T14:55:24Z")

</div>

I narrowed it down to 200 records and it seems to work every time now, so I am guessing the size is the issue. When it happens I usually can’t get past the first letter before it locks up and chrome displays the error.

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [May 20, 2019, 3:00pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/7 "2019-05-20T15:00:31Z")

</div>

> [@grietveld](#):
>
> I usually can’t get past the first letter before it locks up

Yah, that's what I would expect would be the case if the size of the matching Dataset is indeed the issue. I'll open up an internal ticket, but I wouldn't expect a quick fix for this one as we'll need to determine how to handle the `results` property when the dataset which "matches" is very large.

---

<div class="post-metadata">

**Author:** ![ynejati](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ynejati/32/6093_2.png) [@ynejati](https://forum.inductiveautomation.com/u/ynejati)\
**Post date:** [May 20, 2019, 9:27pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/8 "2019-05-20T21:27:09Z")

</div>

Well, I did explicitly say in the `results` prop tooltip

> Enable filter results to be written back to props. Warning, doing so may cause performance decline.

Sounds like the websocket is choking, which I would expect at this time. That's a heck of a lot of data.

---

<div class="post-metadata">

**Author:** ![travism](https://avatars.discourse-cdn.com/v4/letter/t/0ea827/32.png) [@travism](https://forum.inductiveautomation.com/u/travism)\
**Post date:** [October 20, 2020, 5:24pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/9 "2020-10-20T17:24:00Z")

</div>

Any resolution to this? We have the same web socket error and all of our project screens turn black for approx 1-2 seconds.

---

<div class="post-metadata">

**Author:** ![mperkins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mperkins/32/71722_2.png) [@mperkins](https://forum.inductiveautomation.com/u/mperkins)\
**Post date:** [November 11, 2021, 4:28pm UTC](https://forum.inductiveautomation.com/t/bug-13951-perspective-table-filters/25109/10 "2021-11-11T16:28:37Z")

</div>

Hi travism, A fix is under investigation, but I can’t promise a timeline.
