IBM Support

Rational Publishing Engine: ClearQuest queries with filters do not work

Technote (troubleshooting)


When integrating IBM Rational Publishing Engine with ClearQuest using Data Services, the REST URI for Data Services queries referencing certain kinds of ClearQuest queries with filters do not work correctly.


IBM Rational Publishing Engine REST URIs referencing ClearQuest queries with filters fail in one of two ways:

  • Filters with 'not null' in a condition cause all the filters to be ignored

  • Other kinds of filters that do not use 'not null' result in an error like:
    Error 500: [$FilterLeaf$TargetType; incompatible with java.lang.String


This has been identified as a product defect under APAR PM48320.


This has been seen with IBM Rational Publishing Engine and 1.1.2, when using ClearQuest with multiple databases (Microsoft Access, Oracle 11G)

Diagnosing the problem

To determine whether you are having this problem, you need to have an IBM Rational ClearQuest (CQ) system with the sample database and Rational Publishing Engine (RPE) installed, with Data Services configured for CQ. If you are having this problem, you will be able to reproduce it in this way:

  1. Make a copy of the All Defects query.

  2. Edit the copy to add a filter. For example, you can filter by State and only find Resolved defects.

  3. In a browser, run the REST query to see the queries available for the sample database.
    For example:

  4. Run the All Defects query in a browser. For example:

    This works as expected, returning all defects.

  5. Run the query with the filter. For example:

    This fails with the 500 error described above.

Resolving the problem

As a result of this issue, you cannot use IBM Rational ClearQuest queries with Rational Publishing Engine (RPE) if the queries use filters.


To work around this problem, instead of filtering at the ClearQuest level, you can filter at the RPE level by using script filters in the RPE template.

Note that doing the filtering in RPE will impact performance.

Cross reference information
Segment Product Component Platform Version Edition
Software Development Rational Publishing Engine General Information Windows, 1.1.2

Document information

More support for: Rational ClearQuest
Integrations: IBM

Software version: 7.1.2,,,,

Operating system(s): Windows

Reference #: 1569223

Modified date: 07 August 2015

Translate this page: