List of Tables has Case ID
Hi ,
I would like to know if there is a way to pull list of all tables where specific case ID(s) is/are stored.
So far i have collected these tables, but i guess there will be more. Is there a definite list of tables where i should be looking at.
TableName - ClassName
ABCD_Work - ABCD-Work pc_assign_worklist - Assign-Worklist pc_assign_workbasket - Assign-WorkBasket pc_data_workattach - Data-WorkAttach- pc_link_attachment - Link-Attachment pr_data - Data-Corr-Email
I am using Pega 6.3
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 16 Sep 2022 6:09 EDT
HCL
PL
One option could be to take a random case ID , create and run a query to search entire database. This query should give all table name where the case ID is present in any column of the table. You can search online for the query based on the underlying DB that is used.
Thanks!