Question
ai4process
GB
Last activity: 5 Feb 2025 3:41 EST
Using a table for an insight created from a datapage
When I create an insight from a data object I can display my insight as a table. However when I create my insight from a data page I cannot use a normal table. The closest chart to a table is a "summary table".
I want to use a normal table
The image below is a demonstration of my problem
The next image is the datapage were using which is not allowing a "table". Were trying to display external data to an insight so the datapage gets its info from a get request to a rest api.
I just want to use a normal table for this insight. what do I have to do to use a normal table in an insight? Is it even possible. If not, why not? What more information would be helpful?
Extra info (incase its helpful): I'm using constellation and pega infinity 23.1.2,
the datapage works as expected when I run it.
Pegasystems Inc.
CA
Is there a specific reason you're unable to achieve this by creating a Pega Insight? I'm curious to know why you need to achieve through data pages.
Updated: 12 Jul 2024 9:37 EDT
ai4process
GB
@RameshSangili Because we want to make an insight to display external data that we collect with a rest api. we dont want to store the data in anyway. So were just using a datapage to call the api to get the data.
AI4Process Ltd
GB
@RameshSangili We want to understand whether it is a product limitation which is going to be addressed in future releases of constellation or anything missing in the above implementation causing table format to disappear.
ai4process
GB
@JackF17108719 I still really need an answer for this.
Pegasystems Inc.
CA
This can be achieved through Landing Pages since you're using the connector to source the data from External systems.
Insights would be a good option if you're sourcing the data from Pega Database.
ai4process
GB
So just to be clear, Is it actually impossible to use a regular table to present data not stored in a PEGA database? If so, why? What mechanisms prevent this?
Updated: 1 Nov 2024 8:55 EDT
Pegasystems Inc.
GB
@Sam Alexander @MeghanAtkins could you help with this question?
Pegasystems Inc.
US
In the 24.2 release, we addressed this gap by adding support for "Table" as an option in Insight authoring when sourcing directly from a Data Page.
Please note that when using the Table option introduced in 24.2, all filtering, sorting, and aggregation are performed client-side. This means that if your Data Page only returns the first 500 records, any applied filter will only affect those 500 results. As a result, if your external system contains more data, it may appear incomplete or inaccurate in the Table view. We are working to address this limitation in a future release.
EIB
PL
@MeghanAtkins Is there a documentation on how to enable a data page (sourced by a REST connector) in the Insights for version 24.2 ? I created a list data page which is sourced by a REST connector, enabled the query option. But its not appearing in the Objects list in App Studio. Is there anything I should check again ?
Pegasystems Inc.
US
Hi @EngincanY - We currently only surface REST backed data pages for Application Authors in the App Studio version of Explore Data. We don't (yet!) expose them in the End User portal version of Explore Data - since the feature set is rather limited, we didn't want to confuse End Users as to why certain features were missing based on what they are exploring.
If you go to App Studio -> Explore Data, you should see your Data Page under this Data Pages dropdown:
You should be able to create an Insight against your Data Page and include it in your UI (Landing Page or Case View) for your End Users to see. Let me know if you are still running into any issues.
EIB
PL
@MeghanAtkins Thank you for your reply. I was able to create an Insight against my Data Page. I added the Insight to a landing page. But it doesn't display any record in the table. However I see in the browser logs that the data page returns data.