Issue with JasperSoft Custom filter expression in CA PPM

Document ID : KB000104150
Last Modified Date : 05/07/2018
Show Technical Document Details
Issue:

The steps to replicate this issue are as follows:
  • Login to CA PPM and Go to Advanced reporting and create a new Adhoc View on any Domain. For example Project Management Domain.
  • Create Pre Filters for a few attributes and lock them
         Example:
        IsActive =1  
        IsRequired =1
        IsTemplate =0
        Isprogram =0


 
  • Ensure the Report is Table Type
  • Add Task Name, Task Start Date, Task Finish date to the columns
  • Add Groups Project Name and Project Manager
  • Add more filters in the "New Ad Hoc View" page using the OOTB attributes until the number of filters is 27 and the prefix to the name of the filters crosses "Z" and becomes AA, BB etc. 
  • Now use Custom Filter Expression to filter the results based on Project Name and click on Apply. Project name in the below screenshot has prefix E so the custom filter expression used is E.
Custom filter expression
 
When "Apply" is clicked, the order of the prefix on the names of the filters changes and the results are also not filtered as per the specified filter.
For example in the above screenshot, E is the prefix for Project Name Filter and that has been specified as the filter criteria in the Custom Filter Expression.
But on clicking Apply, the prefix on the Project Name Filter changes from E to something else and the displayed Tasks are not for the Project Name selected in the filter E.

 
Environment:
CA PPM 15.2
Resolution:
This is a known issue on version 15.2. 
The issue has been fixed in version 15.3 and it is recommended to upgrade