Question

2
Replies
77
Views
 Rajendra Prasad Adepalli (RajendraPrasadA8799)
Social Security Administration

Social Security Administration
US
RajendraPrasadA8799 Member since 2019 2 posts
Social Security Administration
Posted: March 17, 2020
Last activity: June 14, 2021
Posted: 17 Mar 2020 22:42 EDT
Last activity: 14 Jun 2021 7:38 EDT
Closed

Connect SQL

Hi All, We have a requirement to pass schema name as parameter in the connect-sql rule. We tried passing it using a data page but it didn't work. Did anyone know the solution for this ?

***Edited by Moderator: Pallavi to update platform capability tags***

Pega Platform 8.3 Case Management Data Integration Government Senior System Architect
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 1 year ago
Posted: 17 Mar 2020 23:04 EDT
Yathender Jalla (Yathender)
PEGA
UI Architect
Pegasystems Inc.
IN

Hi

You can not pass parameters to the Connect SQL rule.

Try using the data page itself :

Ex:   Select ID,Name from {Class:ClassName} where ID='{ASIS:Testpage.ID}';

        Insert into {Class:ClassName}(ID,Name)values('{ASIS:Testpage.ID}','{ASIS:Testpage.Name}');