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

 Vikash Togarrati (vikat)
Pegasystems Inc.
Lead System Architect
Pegasystems Inc.
SG
vikat Member since 2015 4 posts
Pegasystems Inc.
Posted: Jun 28, 2018
Last activity: Jul 5, 2018
Posted: 28 Jun 2018 4:50 EDT
Last activity: 5 Jul 2018 16:25 EDT
Closed

Stored Procedure parameters (blank property)

Scenario:

We have an integration page where data is set from the work page. Connect SQL, calling SP, picks up parameter values from this page.

Problem Statement:

When there are no values to the properties, they do not show up on the integration page. Thereby parameters are not passed to the SP.

Where as, Downstream system is expecting blank values to be passed in the parameters.

@PropertyhasValue() and @PropertyExists() both returns false.

To see attachments, please log in.
Data Integration

Posted: 6 years ago
Posted: 5 Jul 2018 14:59 EDT
Carissa Wenhardt (CarissaW_GCS)
PEGA
Senior Principal Engineer, Technical Support, Industry Apps
Pegasystems Inc.
US

Can you modify the stored procedure to use a blank value if a value is not provided or add a step in your process to initialize those properties to blank values?

To see attachments, please log in.

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