Moving a work type to separate table
Hi All,
Is it possible to move a particular work type from pc_work table to different table say pc_work_a.?
As far as i know we need to update the pzInskey of the work type and also we need to update the same in other tables like Assignment,History,Attachments etc.
Is there a way to achieve it without refactoring?
***Moderator Edit: Vidyaranjan| Updated Categories***
Pegasystems
IN
Infosys
IN
We are trying the same, would like to map a work type to a table in work pool where work pool is mapped to a different table.
we have x, y , z work types in Work pool. we want different tables to be mapped to every work type.
Can we change the work type to work pool by changing the class definition.
Pegasystems Inc.
IN
Yes, you can change the each work type to work pool and map each one to a different table.
Let us know if you need anything else.
Infosys
IN
Thanks mate for your response.
We have work objects/cases created before the change & now I have to retrofit all old instances to new table & change definition on all instances.
would like to know all the areas which needs to be retrofitted.
For eg: pzinskey, pyid etc at case level, refobjkey at work Basket ,WL level & might be at other places, I have to perform the change in case of old cases.
Thanks
Coforge
AU
You can also look at Declare trigger as an option apart from modifying corresponding Data-Admin-DB-Table instance.
Infosys
IN
Thanks Venkata for your response, could you please elaborate more on this can be more helpful.
Mphasis
IN
Hi All,
To save the work object/Case to another External DB or to perform changes to a work object and to restore the old case data which needs to be stored for back up we can achieve it thorough "Package Work Wizard". Where you can even mention the number of cases you need to store(Say Cases ID from 1 to 10) or even as a individual case when you run the wizard.
A product archive of an individual or a list of cases will be created at the end where the File can be stored in the system or in any external DB. Whenever a case or list of cases needs to be restored, the file can be imported into the application through import wizard.
Thanks.
Association of a work type (class) to a database table is via the Data-Admin-DB-Table instance. All classes belonging to a single workpool will be associated to the same table.
https://docs-previous.pega.com/database-management/all-classes-class-group-map-one-shared-database-table
https://community.pega.com/support/support-articles/unable-map-work-classes-different-tables-1-class-group
If you change this work type to be a classgroup then you could map it to a different table. Please make sure this change is in line with your application requirements and design.