Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 deleep nossam (deleepn3218)
Wipro

Wipro
US
deleepn3218 Member since 2016 3 posts
Wipro
Posted: Sep 20, 2016
Last activity: Sep 20, 2016
Posted: 20 Sep 2016 0:15 EDT
Last activity: 20 Sep 2016 3:26 EDT
Closed

How to select multiple records from external table

Dear All

Need help to solve my situation

I am using MSOParseExcelFile to upload the Excel data to a clipboard page list(For example: EmpNum,EmapName and EmpCity). Upto this it's working fine. Next I need to Query external table in an activity to fetch all the records matching the clipboard values Along with other fields. What's the optimal way to achieve this. Please help me in this regard

Thanks

 

 

To see attachments, please log in.
Java and Activities

Posted: 8 years ago
Posted: 20 Sep 2016 0:40 EDT
SatishKumar Tanappa (Satish)
Optus
Lead Developer
Optus
AU

Hi Deleep,

I assume you mapped the external table to a class in Pega (if not use connector and meta data accelerator wizard to map external table to Pega class). To achieve your scenario, loop through each page list and do Obj-browse (You can use RDB-List as well) by passing EmpNum,EmapName and EmpCity to get the additional fields.

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice