Question
TCS
IN
Last activity: 16 Mar 2018 19:46 EDT
Read Dynamic pages and display them
I have a scenario, where i need to read dynamic pages. Say for example, i have to pass an SQL query and need to display the output.
Problem is i do not know which table will be queries and how many rows will be returned. I need to read the rows and column and display them. What is the best approach to achieve it. For testing i am using Show-Page and can view the values in XML format. But I want to display them in the Section.
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
The table depends on the class of record you are trying to retrieve. Did you try using report definitions instead of custom sql for running your query?
You could create a data page source it from either report definition or custom sql and use this data page in a grid in a section for display.
Pegasystems Inc.
US
You may get a more responses posting questions that are not specific to Pega Express in the product support forum:
https://collaborate.pega.com/question/pega-product-support-webhook-api
Apple India Pvt Ltd
IN
Use Report definitions if you didn't apply to your scenario. Create a repeating grid configure your report-definition under that.
Accenture Australia
AU
Hi Venkat,
You can use the report definition for your scenario and if you want to get the data from more tables class joins concept is also provided and sub reports.
For the no.of colums and rows there is a filter condition in the report definition, go through that.So that it will retreive only rows and colums based on the filter value.