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…