# Table Query Binding not clearing on empty dataset

**URL:** <https://forum.inductiveautomation.com/t/table-query-binding-not-clearing-on-empty-dataset/3326>\
**Category:** General Discussion\
**Created:** [September 23, 2011, 4:08pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-not-clearing-on-empty-dataset/3326 "2011-09-23T16:08:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jconnor34](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@jconnor34](https://forum.inductiveautomation.com/u/jconnor34)\
**Post date:** [September 23, 2011, 4:08pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-not-clearing-on-empty-dataset/3326/1 "2011-09-23T16:08:03Z")

</div>

I have a table that has the DATA property bound by a Query. Here is the query:

SELECT active\_TimeStamp AS DATE\_AND\_TIME,  
displayPath AS ALARM  
FROM test.alert\_log  
WHERE active\_TimeStamp between date(’{Root Container.fromDate.date}’) and date(’{Root Container.toDate.date}’)

The problem is that when the query returns an empty dataset the table doesn’t update. All the data from the previous query still remains in the table. For example, I set the calendar fromDate and toDate to days in the future which returns an empty dataset, but the table still shows data from a previous query that did return data.

I used the Query browser to verify that the query is valid and it does work correctly.

I am missing something…

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [September 23, 2011, 9:26pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-not-clearing-on-empty-dataset/3326/2 "2011-09-23T21:26:58Z")

</div>

Do you get a red overlay or an error that pops up?

---

<div class="post-metadata">

**Author:** ![jconnor34](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@jconnor34](https://forum.inductiveautomation.com/u/jconnor34)\
**Post date:** [September 25, 2011, 1:39am UTC](https://forum.inductiveautomation.com/t/table-query-binding-not-clearing-on-empty-dataset/3326/3 "2011-09-25T01:39:07Z")

</div>

No overlays and no errors.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [September 25, 2011, 10:40pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-not-clearing-on-empty-dataset/3326/4 "2011-09-25T22:40:24Z")

</div>

Drag in a new table component and try binding the data to the same query. Do you get the same results?