Skip to main content

Segregating cases into a dedicated table

Suggest edit Updated on May 11, 2022

If your pc_work table contains cases from two or more unrelated applications, segregate cases into a dedicated table.

Note: If you created the applications using New Application wizard, each work pool has a dedicated table named pc_ZZZZZ_Work and you do not have to segregate cases into a dedicated table.
  1. Create a database table by copying the schema for the standard pc_work table. Be certain to update the CONSTRAINT element in the new table to reference itself, not the old pc_work table.
  2. Expose the columns for new properties in the application in the new table or tables as desired.
  3. Within the portal, create a database table instance ( Data-Admin-DB-Table class) for the class group, referencing the new table.
  4. Create a database table instance for the History-ZZZZZ class, where ZZZZZ is the name of the class group, mapping instances to the pc_history_work table.
  5. Copy the view definitions pcv4_assignment_summary and pcv4_assignmentwb_summary and adjust them to reference the new tables.
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us