The parameterized lookups based on a boolean field does not allow selections on the Modern UX.

book

Article ID: 140980

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

STEPS TO REPRODUCE: 

1. Go to Administration > Data Administration > Lookups
2. Create a lookup
3. New_ux_param
Query:
SELECT
@SELECT:RES.ID:[email protected]
,@SELECT:RES.FULL_NAME:[email protected]
FROM
SRM_RESOURCES RES
WHERE
@[email protected]
@BROWSE-ONLY:
AND ((RES.IS_ACTIVE = 1) AND (@WHERE:PARAM:USER_DEF:INTEGER:[email protected] = 1)) :[email protected]
4. Go to Studio > project object
5. Create a boolean attribute: 
6. n_flg
7. Create a numeric attribute: n_integ
Validation range 0 to 1
8. Create a lookup type attribute called: new_ux_param_boo
Lookup linked: new_ux_param
Lookup parameter mapping: n_flg
9. Create a lookup type attribute called: new_ux_param_integ
Lookup linked: new_ux_param
Lookup parameter mapping: n_integ
10. At the project object views add all 4 attributes to the edit view
11. Set the lookups as pull-down
    Project properties View > Fields > By editing the field properties
12. Open any project and look at the fields
13. Select the value 1 for the n_integ and click on the pull-down for new_ux_param_integ
14. Values display
15. Check the Boolean flag and do the same on the new_ux_param_boo
16. No values display (This is the first anomaly of the Boolean based parametrized lookup)
17. Add the 4 fields to the list view
18. Select the value 1 for the n_integ and click on the pull-down for new_ux_param_integ
19. Values display
20. Set the n_flg and do the same on the new_ux_param_boo
21. Values display and can be saved
22. Once values are saved at list view, the project properties field shows the value and you can change it to any other
23. Go to the Modern UX > Blueprints
24. Add a section and the fields
25. Link the project to the blueprint and open the project
26. The values have been carried as specified on the Classic UI
27. Change the value of the new_ux_param_integ
28. Changes can be saved
29. Try to do the same with the new_ux_param_boo field


Expected Results: The field value can be changed and saved  

Actual Results: No values are selectable and can not be changed

Cause

This is caused by DE52076

Environment

Release: 15.7


Component: Studio

Resolution

This is fixed within Clarity PPM 15.8

Workaround: 

Use an integer field instead of a boolean (as on the steps to reproduce)

OR 

a static list lookup with Yes and No values