List view multi-select attribute
Article ID: 126762
Updated On:
Products
Clarity PPM SaaS
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.
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
Component: PPMSTU
Resolution
DE47803, In review by Engineering
Feedback
Yes
No
Powered by
