Question
HSBC
IN
Last activity: 5 Mar 2019 5:25 EST
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****
Pegasystems Inc.
IN
Hi,
When you are using Connect SQL rule you need to give complete class name as below:
Select POSTALCODE as ".Postalcode" from (Class:ADV-Purchasing-Int-PostalCode) where CITY like '%{Asis:SearchPage.City}%' and COUNTRY = {.Country}
Here Asis is a step page
Please Note the Class has 'C'.
Regards,
Vikash
Areteans Technologies
IN
Hi @JanmajayA6339,
Did you try re-saving the DB table instances associated with the classes mentioned in the query and run again?
Please comment if you have already tried this and still facing the issue.