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

 Karthik Kummera (Karthik K)
Pegasystems Inc.
Senior Demo Engineer, Support
Pegasystems Inc.
IN
Karthik K Member since 2016 36 posts
Pegasystems Inc.
Posted: Nov 16, 2017
Last activity: Nov 22, 2017
Posted: 16 Nov 2017 15:00 EST
Last activity: 22 Nov 2017 23:29 EST
Closed

Purge the Cases - which are older than one year ?

Hi,

We need to delete/remove the cases(criteria: current date - casecreatedate > 1 year), irrespective of case status using an agent.

Could you please tell me, which one to use RDB or Obj ?

Please suggest a Best Approach, such that application performance wont be impacted.

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Case Management
Data Integration

Posted: 7 years ago
Posted: 22 Nov 2017 23:29 EST
Karthik Kummera (Karthik K)
Pegasystems Inc.
Senior Demo Engineer, Support
Pegasystems Inc.
IN

Thanks Arnab!!. 

But, In my project, RDB methods are used, that will call a Stored Proc -- It will delete the records and returns the number of records deleted.

I am not sure how they implemented, can we create stored procs for the pega internal tables also ? If so, is it similar, how we create for mysql or any other db ?

Excuse me, If the above question seems to be stupid ?

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