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

Document ID : KB000052318
Last Modified Date : 14/02/2018
Show Technical Document Details

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.