Hello, I am receiving an error on an interactive table widget while running an app.
The table results are filtered against a variable that is populated by a query.
There is no error when a different query is submitted.
Have you seen this error before? Does it occur due to a specific reason?
Hi @kkl -
If you display the variable populated by the query (with a text variable widget) while running the app, do you see a value that is expected for that variable? Perhaps the query is returning something unexpected and that is why you are seeing the error.
Hi Beth,
So, the table is filtered to show records whose ID are present in a variable list. The variable list is populated by a query. The variable list is populating as expected (checking while running test mode).
Best,
Kevin
Hi @Beth , a couple of more bits of info. When the error is encountered in the app, it also appears that there is an error in the app editor (the in-app and app editor errors seem to coincide).
As I mentioned, the error is not encountered in some cases. I am realizing that in the error case, there are a large number of records to sort thru. I am wondering if that is the issue.
To recap - the table is filtered such that records with an ID in a list variable are displayed.
The list variable is populated via a query/aggregation.
In the failure case, there are 7176 records that match the filter criteria.
There are 688 items in the list variable.
So, the table filter is trying to check which of the 7176 records are in the 688 item list.
Is it a capacity issue?
I don’t have a complete idea of what the record/list count numbers are when the table is not encountering an error. I checked one situation and the numbers are less. I can get more info if required.
I submitted a ticket for this as the situation is quite critical.
Let me know what you think.
