Question

2
Replies
38
Views
SoumikK1 Member since 2015 4 posts
Ernst & Young LLP
Posted: 1 month ago
Last activity: 1 month 2 weeks ago

I have a requirement to where I have a list of work classes, I need to run a connect sql from RDB-List to fetch last 30 days cases

I have a requirement, where I have a list of work classes, I need to run a connect sql from RDB-List to fetch last 30 days cases created.  I need to pass the table name dynamically each time.

I have written this:

select pyID from {class:'{ASIS:ClassName.pxInsId}'} where where pxCreateDateTime >= CURRENT_TIMESTAMP -30

Can anyone help ? My class should be dynamic each time, so I'm setting this property before calling RDB-List, but it's not working.

 

***Edited by Moderator Marissa to change type from Pega Academy to Product***

Pega Platform 8.3.2 Cloud Services Technology Services System Architect
Share this page LinkedIn