Question

1
Replies
1267
Views
SainathV6852 Member since 2016 4 posts
Virtusa
Posted: August 27, 2016
Last activity: September 9, 2016
Closed

Saving the DataPage(List) values to External DB

Scenario:

There is a table called ProductDetails with columns P_ID, P_Name, Price in PostgreSQL. I have linked the table through DataBase Class Mapping.I have created one datapage(D_ProductList) of type List which has a DataSource of Report Definition.

UI: An auto complete who source is data page to populate the Product Name(P_Name).Based on the Product name (Which acts as a parameter to the datapage D_ProductList and Report Definition) there is repeating grid to populate the list of items.

Whenever user selects a particular column and clicks submits the particular column record should be saved to the another table called transaction details.

I have written an post processing  activity in the flow action for saving the details of an particular product to the table. As I'm passing the product name as a parameter to the dataPage and ReportDef in Clipboard for every parameter a DataPage is dynamically generate.

For Example: D_ProductList[“ABC”] (code-pega-list).

D_ProductList[“PQR”] (code-pega-list).

In Page and Class tab of activity I have written the class name and for the page Name D_ProductList.pxResults.

In Steps tab: I’m using ”Property-Set” method and getting the  values from clipboard.As it is pxResults its asking for index I have passed it as D_ProductList.pxResults(1) for setting the Price property. But it works only for the 1st line in the repeating-grid how can I make it dynamically (If user 2nd row in the grid) and save it to the table.

Help appreciated !

Thanks & regards,

Sainath Vallpu

***Updated by moderator: Marissa to update ctaegories***

Reporting User Interface
Moderation Team has archived post
Share this page LinkedIn