You can request your DBA to create the columns in pc_assign_worklist table. Post that either recycle JVM or resave the Database Table instance for Assign-Worklist class. However, in this approach, you will have to write a separate process to populate the existing data to the new column.

Hi Kevin,

I could think of two ways for handling it. 

Approach 1: 

Optimize for reporting option creates a new column in the respective table. That we can do manually as well.  Create the required properties in Assign-Worklist class, and then you can update the table pc_assign_worklist by adding the required columns in it. Once you are done with that, ensure to test the connection from the Assign-Worklist database table rule. That helps in affecting the changes. Otherwise it does not respect the newly created columns. But you might need to pay attention during the upgrades. 

Approach 2: 

You can create a new class with the required properties + keys of assign worklist class. And that class should associate to a new table where all the columns are present. Then update NewDefaults to add a new entry to this table. For every assignment record there would be a record in this new table. Report definition has to be updated by joining assign worklist table and newly create table. Here still we have to rely on join but the entries are not as many as in work class. It does not affect during the upgrade. But performance wise might not be the best. 

Mahesh K. 

Hi Kevin,

I am also having similar requirement. I want to add few columns(which are in pyWorkPage) to Assign-WorkList. Could you please provide me step by step how to do this?

I tried to do with NewDefaults but it didnt work for me.