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

 chunliang liu (chunliangl)
Accenture
Manager
Accenture
CN
chunliangl Member since 2015 25 posts
Accenture
Posted: Aug 23, 2021
Last activity: Aug 26, 2021
Posted: 23 Aug 2021 22:42 EDT
Last activity: 26 Aug 2021 23:21 EDT
Closed

Can I Segmented reading records

hello everyone,

because the records is numerous. I want read first 10000 records. Then get more 10000 records when first 10000 record was resolved . Is there any OOTB setting can fix? 

Thank you very much!~ 

***Edited by Moderator: Pooja Gadige to move from Pega Academy to Product, add platform capability tag***
To see attachments, please log in.
Pega Platform 8.5.4
Case Management
Data Integration
Financial Services
Senior System Architect

Posted: 3 years ago
Posted: 24 Aug 2021 7:59 EDT
Venkata Surya Prakash Mallarapu (SuryaMallarapu)
EvonSys India Pvt Ltd
Lead Consultant
EvonSys India Pvt Ltd
AU

@chunliangl ,

If it is for migration point of view, run an agent and brows the max record count(100000) and add one flag to each record(set to true after processing) and save back to db such that each time agent will fetch new records.

 

To see attachments, please log in.
Posted: 3 years ago
Posted: 26 Aug 2021 23:21 EDT
chunliang liu (chunliangl)
Accenture
Manager
Accenture
CN

@SuryaPrakash

Thanks for your suggestion！

My requirement is export to excel, but it is very slowly because too large records. so I want to read 10000 records one time and create an excel file. At last create multiply excels which have 10000 records.

DB data is not my data so I can't update it.

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