Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

2
Replies
393
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

Report

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
Posted: 3 years ago
Posted: 17 Mar 2020 23:04 EDT
Yathender Jalla (YathenderJ8207) IQZ Systems Senior System Architect - UI Specialist
IQZ Systems
IN
Report

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}');

 

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice