Question
Social Security Administration
Social Security Administration
US
Social Security Administration
Posted: Mar 17, 2020
Last activity: Jun 14, 2021
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***
Posted: 4 years ago
IQZ Systems
IQZ Systems
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}');
Posted: 4 years ago
Updated: 3 years ago
Updated: 14 Jun 2021 7:38 EDT
PEGA
Pegasystems Inc.
IN
Please find the below URL which might be helpful