List view multi-select attribute

book

Article ID: 126762

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

We have an multi-select attribute that displays many more values than are actually selected in a list view.

Cause

SETUP and STEPS TO REPRODUCE


SETUP:

1. create a custom object:
Object name=c_summary_comptency
Object ID= c_summary_comptency

Add attribute:
Attribute ID= descript (type srting)

2. Create some instances of the custom object:

id / name/ descript
aa / aa / aa
bb / bb / bb
cc / cc / cc
dd / dd / dd

3. Create a Dynamyc Lookup:

Lookup Name=c_summary_comptency
Lookup ID=c_summary_comptency

NSQL:

SELECT @SELECT:code:[email protected],
@SELECT:NAME:[email protected],
@SELECT:descript:[email protected],
@select:last_updated_date:[email protected]
FROM odf_ca_c_summary_comptency
WHERE @[email protected]


4. Open Project Object and create a new attribute:

Attribute Name=c_competency
Attribute ID=c_competency
Data Type=Multi Valued Lookup - String
Lookup= c_summary_comptency

Add the attribute to the Edit View


5. Create a Dynamyc Lookup:

Lookup Name=C_LOOKUP_SUMMARY_COMPETENCY_RISK_V3
Lookup ID=C_LOOKUP_SUMMARY_COMPETENCY_RISK_V3

NSQL:

select @SELECT:odf.id:[email protected], @SELECT:odf.code:[email protected], @SELECT:odf.name:[email protected], @SELECT:odf.descript:[email protected] from inv_investments i join odf_multi_valued_lookups ml on i.id = ml.pk_id and ml.ATTRIBUTE =

'c_competency' and upper(ml.OBJECT) = 'PROJECT' join ODF_CA_C_SUMMARY_COMPTENCY odf on ml.value = odf.code where @[email protected] and (@WHERE:PARAM:USER_DEF:INTEGER:[email protected] = i.id or @WHERE:PARAM:USER_DEF:INTEGER:[email protected] is

null)


Hidden Key=odf_key
Display Attribute= code

6. Open Risk Object and create a new attribute:


Attribute Name=summary_competen4
Attribute ID=summary_competen4
Data Type=Multi Valued Lookup - String
Lookup= C_LOOKUP_SUMMARY_COMPETENCY_RISK_V3

Lookup Paramer Mapping:

ID mapped to PK_ ID


Add the attribute to the Edit View


STR:

1. Create Project X.

My Project id=5019003

Populate manatory field
Populate field 'c_competency' with values:
id / name/ descript
aa / aa / aa
bb / bb / bb


2. Create Project Y.

My Project id=5031011


Populate manatory field
Populate field 'c_competency' with values:
id / name/ descript
cc / cc / cc
dd / dd / dd

3. Open Project X. Create a Risk.

Risk URL: odf_pk=5009000 & id=5019003

For Attribute "summary_competen4" click on the binocular to select the values.


EXPECTED RESULTS:
Values of field 'c_competency' in Project X are displayed. So, it should displayed:

id / name/ descript
aa / aa / aa
bb / bb / bb

It should only show the value from the corresponding project.

ACTUAL RESULTS:
Values of field 'c_competency' in Project X and in Project X\Y are displayed. So, it displayed:

id / name/ descript
aa / aa / aa
bb / bb / bb
cc / cc / cc
dd / dd / dd

It shows the values from all projects.

3. Open Project Y. Create a Risk.

Risk URL: odf_pk=5012000 & id=5031011

For Attribute "summary_competen4" click on the binocular to select the values.

Environment

Release:
Component: PPMSTU

Resolution

DE47803, In review by Engineering