We have a DataTable control in a Canva app connected to an Azure SQL datasource.
[It gets data from a SQL View via a SortByColumns( Search ( Filter( ViewName, xxx))) construct which is built via nested Switch statements depending on a number of checkboxes which control which fields are used in the query.]
This usually all works fine. There are no delegation warnings and the DataTable control automatically pages to the next 100 items whenever the user scrolls down to the bottom of the list and there are more items to retrieve (currently a few thousand).
However, this paging mechanism is NOT reliable. When I play the app from within the editing studio, the paging seems to always work. i.e. when I scroll to bottom of the list, the next 100 records are always retrieved and the DataTable dynamically updates.
But when the app is run from the web player (i.e. the published app is run outside the editor), sometimes this paging mechanism occurs and sometimes it doesn't. i.e. it shows the first 100 records and then gets stuck, never showing any more even if the user scrolls to the bottom. Sometimes a mouse click on the last row of the DataTable forces a get of the next record but more often than not it doesn't.
Some questions:
* Is there a known bug with the DataTable control that causes this behaviour? Do I need a particular runtime version to avoid this?
* Is there a setting somewhere which I need to alter? (Please don't mention the 500/2000 limit as this has nothing to do with it as the query is fully delegable and only 100 items are retrieved anyway).
* Are there particular query constructs which the SQL connector doesn't parse reliably?
* Are there things to look for in Monitor which might give clue as to what is failing?
Thanks in advance.
