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

Technote (FAQ)


How to create a custom column in the Taskmaster Client or Taskmaster Web Job Monitor.


It is possible to add custom columns to the Job Monitor. These custom columns can then be sorted and filtered on if desired.


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. Delete each item appearing in the 'Alias' column.
    7. Press the ! (exclamation mark) icon.
    8. Save the view.
  4. For Oracle, use an Oracle DB tool to add the newly created column (eg: pb_MyColumn) into the JMView and JobMonitor view. Then execute the changes and save the view.
  5. Restart Taskmaster Server.

To Populate the Column with Custom Actions

  • 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 upper-case. For example:
    sValue = pilot.XtraBatchFieldValue("PB_MYCOLUMN")
  • The value passed to the property must be valid for the database field. That is, it cannot exceed the maximum number of characters that can be held in the database field or contain characters not valid for that field type.

Direct queries to the database, such as with SmartSQL, cannot be used, as the entry will be overwritten when the task completes.

Document information

More support for:


Software version:

7.6, 8.0.0, 8.0.1, 8.1.0

Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation