Question
TCS
IN
Last activity: 28 Nov 2016 5:58 EST
Read non Existent properties dynamically
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.
***Updated by Moderator: Vidyaranjan| Included categories***
Pegasystems Inc.
IN
>> I need to read the rows and column and display them
I think one of the best approach could be to use report definition. And if you are not sure which class table it has to read then you can create an activity pass the required parameter to set the right class name and then trigger the report definition .
TCS
IN
Thanks. I am not using class table. I am querying database directly using connect sql. And the return can be between any of 1000 tables that exist in Database. So i am not creating class for each table.
Pegasystems
IN
And the return can be between any of 1000 tables that exist in Database. So i am not creating class for each table.
So at runtime when executing the connect SQL rule, how will you know which table to run this query against?
Assuming you can pass this as a parameter or a value in a property of a named clipboard page, you can reference that in the connect SQL rule using the {ASIS: Page.propertyname} syntax. The output page will have the total number of records in pxResultCount property.