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
@Bharathan
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!