we have lot of cases in pc_work table and hence we want to move all cancel cases to a new archive table. is there a process that we should follow to move cancelled cases to new archive table? all the cases archive table should be able to open from the portal.
we already moved all cancelled cases in the back end to new archive table with same structure. now we are facing issues to open the cases from archive table. the class name is different and pzinskey of the work object class is different. hence obj-open and obj-open-by-handle are not working.
can you please tell a solution how we can open cases from archive table?
e.g: - work-CA is the main workobject class. work-Archive is the archive class. work-archive is mapped to table pc_work_archive. but any case in pc_work_archive have pzinskey with 'work-CA CA-12345'. when tried with obj-open-by-handle it is opening from PC_work table. when tried with obj-open the work handle is formed like 'Work-Archive CA-12345' and unable to find in Archive table.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Were you able to find any solution for the issue you have mentioned. If you have a solved answer kindly share it across.
We are also facing a similar situation, we have moved few work objects from Work class to Work-Archive class, if we try to do an Obj-Open or Obj-Open by Handle on the archived work objects using the pzInsKey, the activity is throwing an error.
Solution to this issue would be of great help.
Posted: 4 years ago
Posted: 12 Feb 2018 6:08 EST
Vidyaranjan AV (Vidyaranjan)
Senior Online Community Moderator
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.