NSQL Lookup with concat not showing full value in New UX

book

Article ID: 196166

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

An NSQL lookup that is using concat to combine the name and code field in a lookup is not working as expected in the new UX. It looks fine in Classic, but in the new  UX it is only showing the name. This only occurs in Postgres/GCP environments. 

Steps to Reproduce: 

1. Create a new lookup using concat to combine two values. 

Example: 
SELECT
@SELECT:S.CODE:[email protected],
@SELECT:S.NAME:[email protected],
@SELECT:S.FULL:[email protected]
FROM
(select
ID as ID,
CODE as CODE,
NAME as NAME,
concat(concat(NAME,' -  '),CODE) as FULL
FROM   ODF_CA_CUSTOM_OBJECT) S
WHERE  @[email protected]

2. Create a new lookup attribute on the Project object using this lookup
3. Add an API Attribute ID on this attribute to make it available in the New UX
4. In the New UX, add this field to a blueprint
5. Associate any existing or new project to this blueprint 
6. In the New UX, open the project details 
7. Click on the drop down for the lookup 

Expected Results: The available values display as full name - code. 
Actual Results: The values only display the name. However, when a value is selected it does display the value as full name - code in the field.

Cause

Caused by DE57172

Environment

Release : 15.8.1

Component : CA PPM STUDIO

Resolution

DE57172 has been targeted to be fixed in our upcoming 15.9 release. 

Workaround: Flush the Clarity cache. 

Additional Information

For steps to flush the Clarity cache, see KB98199