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.
Posted: 7 years ago
PEGA
Pegasystems Inc.
IN
Posted: 7 years ago
Anthem
Anthem
US
Using a Data Page wont hamper applications performance?
Posted: 7 years ago
Pegasystems Inc.
IN
Hello Sam,
Below links may help.
https://community.pega.com/knowledgebase/articles/manage-multiple-data-sources-data-page
-Shreshta
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