Where records from external DB are stored in Pega 7
Hi,
I made Pega 7 connected to an external DB in the way shown in the following article.
https://www.pegaxchange.com/category/integration/interacting-with-an-external-database/
Now how can I find stored records and use them? The article says they are contained in pxResults and run Load Activity, but I'm not sure how.
Best regards
Accepted Solution
Pegasystems Inc.
US
Yukihito - you can look into the attachment as i had created a sample example for your understanding what is meant by load activity into the data page.
Hope this will gives you clear understanding and let me know if you have any further help.
Pegasystems Inc.
US
Hi Yukihito,
If you look into the Connector and Metadata Wizard creation process last step, it specifies the Data model and the activities which are being created for operations like Browse/Open/Save/Delete as shown in attachment. So you can look into this activities how the data is being loaded in Browse activity and how you can use the loaded data in your respective activity.
Let me know if you still need further information.
Regards
Mahesh
Pegasystems Inc.
US
The BrowseFlights activity can now be used in a Pega 7.1.9 application to e.g. populate a data page using its Load Activity. So you can create the Data Page List and use the BrowseFlights activity to source the Data Page content.
Power Solutions, Ltd.
JP
Thank you for your response Mahesh.
I could found properties and activities in the way you mentioned, but could you give me some more details? What I'd really like to know is how I can see each search result or where it's stored. According to the tips from the Internet, it seems I should use Clipboard Viewer to look at pxResults which, as the article says, contains results. Also could you give me a sample of using Load Activity if possible?
Accepted Solution
Pegasystems Inc.
US
Yukihito - you can look into the attachment as i had created a sample example for your understanding what is meant by load activity into the data page.
Hope this will gives you clear understanding and let me know if you have any further help.
Power Solutions, Ltd.
JP
Mahesh,
Thank you so much. I'm trying Step 1 but facing the problem, which I can't find BrowseEQUIT_DETAILS Activity. Could you check my procedure? Sorry for bothering you.
Power Solutions, Ltd.
JP
Mahesh, I managed to run D_LoadDataUsingActivity and looks I got records. (I got the error "This XML ..." and results are not displayed well. I'm not sure why. Because this Pega 7 is for on-line training? Or I'm using Google Chrome? But it's not a big deal for now.)
... anyway, I can't see D_LoadDataUsingActivity in Clipboard while running.
Pegasystems Inc.
US
Yukihito - In your BrowseDataActivity you are trying to call BrowseEQUITY_DETAILS activity but your business logic activity name is Activity1 as shown in the attachments. Try to call Activity1 from your BrowseDataActivity so that you will get the data.
Power Solutions, Ltd.
JP
Hahesh, I finally found pxResults in Clipboard. I should have selected 'Standard' as shown on top left in your screenshot. Thank you so much for your help again!