JanmajayA6339 Member since 2018 3 posts
Posted: 1 year ago
Last activity: 1 year 6 months ago

Connect-Sql RULE : Class References in query are not getting evaluated to Schema.TableName

Hi All,

I have a db query, Delete from {class:A} f where f.PXINTERACTIONID in (select interactionid from {class:B} where passedlimit='false' and campaignrunid = '{ASIS : MTemp.CAMPAIGNRUNID}' ).

The problem is when I hard code the schema and table names then only above query runs, else we get an error "ORA-00942: table or view does not exist ". However I when I do Test Connectivity from Connect-Sql rule with class references, the schema and table name are picked up correctly.

Database Table mapping is also in place.

Anyone faced this issue before?? Please help

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Low-Code App Development Dev/Designer Studio Data Integration
Moderation Team has archived post
Share this page LinkedIn