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

 Siva Sampath Tutika (SamTutika)
Anthem

Anthem
US
SamTutika Member since 2017 10 posts
Anthem
Posted: Jun 4, 2018
Last activity: Jun 4, 2018
Posted: 4 Jun 2018 11:14 EDT
Last activity: 4 Jun 2018 20:03 EDT
Closed

Check pr_work table if entry already exists?

Lets say when we are working on a Work Object, we have to be notified that an Entry say Bill # already exists in the system. We have to check both the Pega Internal DB and also external Databases to make sure that if user tries to enter an existing Bill number in either internal or external db, an error should be shown that it already exists.

What approach for internal db and external db should i be looking for?

Thanks in advance.

To see attachments, please log in.
Case Management
Data Integration

Posted: 6 years ago
Posted: 4 Jun 2018 12:47 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi Sam,

You need to run query post the bill number is entered for both external and internal DB.
Better solution would be to use Data page that would have the particular column and is sourced collectively by data from both the ext and internal DB.

Regards,
Ujjwal

To see attachments, please log in.

Related content:

Question Solved

Checking if a Operator ID already exists

Question Solved

How will Data Transform Work for SET with Source and Destination as Pages if Destination Page already exists?

Question

Check if database table exists or not

Question Solved

How to check the property value is already exists in the other pagelist temp Activity

Question

While add new entry to decision tables should avoid duplicate entry check to avoid adding same entries

Question Solved

Why do I get a Flow Removed error when the flow exists?

Question

Property name- This instance already exists

Question Solved

Why am I getting a RuleNotFound exception for an activity that exists?

Question

Updating/replacing an already existing attachment based on attachment category

Question

The instance already exist on the Agent but this agent is new

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