Clarity: List View Power Filter for OBS Unit does not work

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

List View Power Filter for OBS Unit does not work. Regardless of what OBS unit is select or combination of OBS units, the data is not filtered as expected.

This behavior can be reproduced for the Resource List View Power Filter, Project List View Power Filter and Portfolio Contents Power Filter.

The Steps to Reproduce shown below are for the Resource List View Power Filter.

Steps to Reproduce:

1. Admin Tool > OBS
   
   Create a new OBS 'Resource OBS' with 3 levels
   Associate the RESOURCE OBJECT to the OBS Definition
   Unit2a
   Unit3a-a
   Unit3a-b
   Unit3a-c
   Unit3a-d
   Unit2b
   Unit3b-a
   Unit3b-b
   Unit3b-c
   Unit3b-d
   Unit2c
   Unit3c-a
   Unit3c-b
   Unit3c-c
   Unit3c-d
   Unit2d
   Unit3d-a
   Unit3d-b
   Unit3d-c
   Unit3d-d
   
   
2. Update Resources with OBS as follows:
   Resource1 = Unit2a
   Resource2 = Unit2a > Unit3a-a
   
   Resource3 = Unit2b
   
   Resource4 = Unit2c
   Resource5 = Unit2c > Unit3c-c
   Resource6 = Unit2c > Unit3c-d
   
   Resource7 = Unit2d
   
   
3. Go to Resource List View and create power filters
   
   Total Resources = 47
   OBS1a = 47 (expected 2)
   ( obs("resource",5000052,"Resource OBS:Unit2a","EQUALS","selected_unit_and_below", ctx, resource) )
   OBS1b = 47 (expected 1)
   ( obs("resource",5000051,"Resource OBS:Unit2b","EQUALS","selected_unit_and_below", ctx, resource) )
   OBS1c = 47 (expected 3)
   ( obs("resource",5000050,"Resource OBS:Unit2c","EQUALS","selected_unit_and_below", ctx, resource) )
   OBS1d = 47 (expected 1)
   ( obs("resource",5000053,"Resource OBS:Unit2d","EQUALS","selected_unit_and_below", ctx, resource) )

Expected: Filtering should return expected results.

Actual: No filtering is accomplished.

Solution:

WORKAROUND:

The reason that the results are not returned as expected is due to the way the Power Filter Expression builder creates the expression. A space is needed between the name of the OBS Definition and the first unit name. This only occurs at the beginning of the expression.

Example:

If the Expression Builder creates the following expression:
( obs("resource",5000052,"Resource OBS:Unit2a","EQUALS","selected_unit_and_below", ctx, resource) )

The OBS Definition = 'Resource OBS' and the first unit name = 'Unit2a'

Modify the expression to insert a spaced between "Resource OBS: Unit2a"
( obs("resource",5000052,"Resource OBS: Unit2a","EQUALS","selected_unit_and_below", ctx, resource) )

Another alternative workaround:

Use OBS Unit and OBS Unit Filter Mode fields instead of the Power Filter.
Change the configuration of the Filter Section OBS Unit field from a 'Single Select' to a 'Multiple Select' if you want to see results for multiple OBS Units in one filter.

STATUS/RESOLUTION:

Defects CLRT-52430, CLRT-52917, CLRT-52918 are marked as a duplicate to CLRT-53168 which is resolved in Clarity 12.1.0 If you are using Clarity 12.0.6, request and implement the latest Generic Hotfix to resolve this issue and other critical issues. Read TEC522707 for more information.

Keywords: CLARITYKB, clarity1210resolved, studio, application admin, build expression.

Environment

Release:
Component: STUDIO