Technical Blog Post
Abstract
Add a custom field to the workflow inbox in start center
Body
Sometimes the fields that you would like to show in the inbox are not always available from the inbox portlet in Start Center. In that case, you might want to use a relationship to display the extra field.
Below are the steps to add the schedule start date from the Changes application to the workflow inbox:
1. Go to Database Configuration application
Bring up WFASSIGNMENT object
Go to Relationships tab
Click New Row to add a new relationship called CHANGEWFASSIGNMENT
Child object should be WOCHANGE
Where Clause expression will be like this
woclass='CHANGE' and workorderid=:ownerid
2. Run the
update statement below to use the relationship to fetch schedule start date from the wochange object:
UPDATE inbxconfig SET INBXCOLUMN='CHANGEWFASSIGNMENT.SCHEDSTART',DESCRIPTION='SCHEDSTART' where inbxcolumn='ASSIGN_01';
We need to execute the SQL statement every time we've a new user.
As an alternative, setup an escalation with an action to setvalue to 'CHANGEWFASSIGNMENT.SCHEDSTART' for new users
Attach the following action if the inbox column is still 'ASSIGN_01'
For example:
action = set inbxcolumn
object = inbxconfig
type = setvale
value = 'CHANGEWFASSIGNMENT.SCHEDSTART'
3. Go to the Start Center Inbox
Click Edit Portlet
4. Select Display checkbox besides the CHANGEWFASSIGNMENT.SCHEDSTART column
Click the Finished button
Schedule start date from WOCHANGE object will be displayed in the start center inbox like below:
UID
ibm11130397