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

Technote (FAQ)


Question

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

Cause

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

Answer

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. Restart Taskmaster Server.

To Populate the Column with Datacap Actions

The Lookup actions can be used in some situations to populate the library using a ruleset like the following:

  • OpenConnection(@APPVAR(*/tmengine:cs)
  • SmartSQL(UPDATE tmbatch SET pb_MyColumn='+@TASKNAME+' WHERE pb_batch='@BATCHID+';,False)
  • Close Connection()
There can only be one connection open at a time with the Lookup actions. So if Lookup is used within the application, care must be taken not to have both connections open at the same time. This example posts the name of the task to the custom column. However, @TASKNAME can be replaced with any desired Smart Parameter.

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Datacap Taskmaster Capture

Software version:

7.6, 8.0.0, 8.0.1, 8.1.0

Operating system(s):

Windows

Reference #:

1500306

Modified date:

2014-04-15

Translate my page

Machine Translation

Content navigation