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

 Navpreet Kaur (NavpreetK1225)
CIBC

CIBC
CA
NavpreetK1225 Member since 2018 6 posts
CIBC
Posted: May 7, 2020
Last activity: May 8, 2020
Posted: 7 May 2020 14:43 EDT
Last activity: 8 May 2020 10:44 EDT
Closed

Unable to get the value of a property in SQL Query which is present in step page

Hi Team,

I am trying to insert a record in database. To do it,  I created an activity that create a Page A which tolds the the instance values and and same instance I passed to Obj-save. While tracing,  I saw one of the property value(in SQL Query) is null, however, property has a value in step page. I have attached the screenshots for reference.

Can anyone pls guide me?

 

To see attachments, please log in.
Pega Platform
Case Management
Financial Services
System Architect

Posted: 4 years ago
Updated: 3 years ago
Posted: 7 May 2020 15:43 EDT
Updated: 14 Jun 2021 7:38 EDT
Pavan Kalyan Kanaparthi (kanap2)
PEGA
Senior System Architect
Pegasystems Inc.
IN

Did you check that page on the Obj-Save step?

Any property reset is happening before that step and is that value saving in DB?

To see attachments, please log in.
Posted: 4 years ago
Updated: 4 years ago
Posted: 7 May 2020 16:03 EDT
Updated: 7 May 2020 16:07 EDT
Navpreet Kaur (NavpreetK1225)
CIBC

CIBC
CA

Yes, I checked the step page the property has a value. There is no property reset happening before saving it to DB. Blob has value of FormID. See the attachment for reference...

 

To see attachments, please log in.
Posted: 4 years ago
Posted: 8 May 2020 10:44 EDT
Hari Priya Yerram (yerrh)
Pegasystems Inc.
System Architect
Pegasystems Inc.
IN

Hi,

Did you expose FormID column? And can you try running a query in query runner to check if FormID value is there in the DB.

To see attachments, please log in.

Related content:

Question Solved

I am not able to see Steps which is present in the processs

Question Solved

SQL query to update the value for an exposed column the value for which is already there in the blob

Question Solved

Query on default value on text property

Question Solved

SQL query to expose property inside single page

Question

Write Custom SQL Query

Question

Using the value of a property in advanced presentation options

Question

Unable to finish assignment when the new assign page is not present

Question Solved

Can get a property value from the clipboard by using the Java step?

Question

Unable to retrieve the correct value for page property(Which is of Page Copy From Data Page) in Report Definition

Question Solved

Declare expressions are not getting fired on a embedded page property which is not on clipboard

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