Question
1
Replies
175
Views
Posted: December 10, 2019
Last activity: December 24, 2019
Closed
Solved
List of Tables Containing Case IDs
Hi All,
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 that if i have to delete a Case ID, i will have a definite list of tables were i can delete.
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
Thank you,
Kamesh Kuppaiah
Hi Kamesh,
List of tables which store case ids , can keep vary with application design.
To get the complete list of tables you can consider checking all the tables associated with work, assign and index classes using DesignStudio > Data Model > Classes and Properties > Database Class Mappings option in designer studio.
This would give the complete list of tables associated with each class type and then you quickly do the query of tables (in doubt) to verify the data.
While above list of yours shares the basic and standard tables, you may also need to include tables related to Index classes.