Filtering task results might not work as expected

When you use the quick filtering feature to filter the list of results shown in Dynamic Workload Console tables, with engines version 9.1 or later, you must consider the following limitations:

Filtering on dates and duration
  • You cannot filter by timezone and offset.
  • You cannot filter using text strings in date columns.
  • Even though the table of results shows dates in the following format: mm/dd/yyyy, the leading "0" is not considered when filtering. For example, 6/8 when filtering is considered as if it was 06/08.
  • Even though the table of results shows duration time in the following format: hh:mm, the leading "0" is not considered when filtering. For example, 06:08 when filtering is considered as if it was 6:08. In durations like 00:01 the 00part cannot be matched with the search string 00, because all non significant digits are discarded. The proper way to search for that is with the string 0.
Filtering not supported
Quick filtering feature is not supported on the following columns:
  • Information
  • Node type
Filtering on job types
To filter for the following job types you must use the specified text:
Shadow Distributed
In the filter field, enter: distributedShadowJob
Shadow z/OS
In the filter field, enter: zShadowJob
Remote Command
In the filter field, enter: remotecommand
Database
In the filter field, enter: database
Executable
In the filter field, enter: executable
File Transfer
In the filter field, enter: filetransfer
IBM i
In the filter field, enter: ibmi
J2EE
In the filter field, enter: j2ee
Java
In the filter field, enter: java
z/OS
In the filter field, enter: jcl
MS SQL
In the filter field, enter: mssqljob
Provisioning
In the filter field, enter: provisioning
Web Services
In the filter field, enter: ws
Access Method
In the filter field, enter: xajob
OSLC Automation
In the filter field, enter: oslcautomation

Cause and solution:

This is due to a mismatch between how data is stored in the database and how it is shown from the Dynamic Workload Console.

You must set your user preferences so that dates are shown in short format (6/27/08 5:59) and you must use the specified strings to filter for job types.