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***