Progressive Loading for data sourced from external tables using Connect SQL

General
1

Hi, I am aware of 2 ways in which Constellation supports pagination. One using Report Definition if the data is stored inhouse in pega tables and the other is using REST API if the data is stored in external tables.

I am however trying to achieve pagination using Connect SQL by connecting to an external database. I dont see the data pages using the query parameter once it is loaded on the UI. It is pulling all the records at once.

Is there a way to achieve pagination via progressive loading for such kind of data sourced from external tables using connect SQL? If not then is there a roadmap to add this feature?

2

As far as I know, there is no configuration to do pagination in Constellation. Do you see any specific challenges wtih Progressive loading with Connect-SQL?

3

Progressive loading is not available with Connect SQL. that was my initial concern on how to do progressive loading with connect sql. I understand that traditional pagination is not available but even progressive loading is available via 2 methods i.e. Report definition and Connect REST.

4

you can pass the pagination query with Rest or Report Definitions. @taoj1 created a great Constellation 101 on it Infinite Scrolling in Constellation Table for REST API

I’m unaware of the same for Connect-SQL