Lookup values not displayed in MUX while in Classic do

book

Article ID: 221728

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

One of the lookup attributes is not showing lookup values in the MUX but i am able to see the values in classic clarity. What can be the issue behind?

Lookup NSLQ sample:

select 
  unt.id
  ,ltrim(substr(unt.name,instr(unt.name,'-')+1)) unitName
  from  
  prj_obs_units unt   
  @BROWSE-ONLY:
  join PRJ_OBS_TYPES typ on typ.unique_name='department' and unt.type_id=typ.id
  join prj_obs_units l2 on l2.depth=2 and l2.unique_name='XXXX' and l2.type_id=typ.id and l2.id=unt.PARENT_ID
  where unt.id not in (5013698, 5013699)
  :[email protected]

Environment

Release : 15.9.2

Component :

Resolution

@[email protected] clause should be included in the NSQL as below

select 
  @SELECT:unt.id:[email protected],
  @SELECT:ltrim(substr(unt.name,instr(unt.name,'-')+1)):[email protected]
  from  
  prj_obs_units unt   
  @BROWSE-ONLY:
  join PRJ_OBS_TYPES typ on typ.unique_name='department' and unt.type_id=typ.id
  join prj_obs_units l2 on l2.depth=2 and l2.unique_name='MCIO' and l2.type_id=typ.id and l2.id=unt.PARENT_ID
  :[email protected]
  where unt.id not in (5013698, 5013699)
  and @[email protected]