Creating a custom column in Job Monitor for IBM Datacap Taskmaster Capture

Creating a custom column in Job Monitor for IBM Datacap Taskmaster Capture

To add a column:

1. In the tmBatch table in the Taskmaster engine database, add a column, giving it the desired name preceded with pb_ (ex: pb_MyColumn).


2. Save the table.


3. For SQL only, also do the following:
   
   
   
   1. Open the JMView view for design.
   
   
   2. Delete each item appearing in the 'Alias' column.
   
   
   3. Press the ! (exclamation mark) icon.
   
   
   4. Save the view.
   
   
   5. Open the JobMonitor view for design.
   
   
   6. Press the ! (exclamation mark) icon.
   
   
   7. Save the view.
   
   
   
   


4. Restart Taskmaster Server.


5. To populate this field with dynamic content, scripting is required.

• If using a Batch Pilot form, the following command is used.
  pilot.XtraBatchFieldValue("pb_MyColumn") = "my value"


• If using a Rulerunner action, the pilot.XtraBatchFieldValue parameter must be uppercase. For example:
  sValue = pilot.XtraBatchFieldValue("PB_MYCOLUMN")