Dynamic Lookup values not shown in MUX

Products

• Clarity PPM On Premise

Issue/Introduction

We have custom attribute linked to a dynamic lookup, which shows values based on user id and associated groups. We checked and the lookup value shows correctly all the values in Classic UI, but not in Modern UX.

                      Classic UI                                                                        MUX

                     

Environment

Component: Clarity 

Release: 16.x

Cause

The NSQL query used in dynamic lookup is not using the correct NSQL syntax within SELECT clause.

Resolution

Change the NSQL query to follow proper NSQL syntax in SELECT clause

Incorrect	Correct
select v1.lookup_code,v1.name	select  @SELECT:v1.lookup_code:lookup_code@, @SELECT:v1.name:name@