AnsweredAssumed Answered

Similar data, why is different lookup required?

Question asked by urmas on Feb 24, 2017
Latest reply on Feb 24, 2017 by Dave_3.0

Just wondering again...

I have this section in my NSQL

@select:DIM_PROP:USER_DEF:IMPLIED:ISSUE:(CASE

WHEN odf.top= 1 Then 'Yes'

 

ELSE ''

END):Top_Issue@,

Works fine and I can associate the attribute  with a lookup

 

When I have this NSQL section in another portlet

   @select:DIM_PROP:USER_DEF:IMPLIED:risk:(CASE

WHEN odf.top = 1 Then 'Yes'

ELSE ''

END):Top_Risk@,

 

I cannot see that lookup to associate it with the attribute. However, I can associate it with a similar lookup

 

To that sounds that in one case the odf.top is considered numeric (the enum) in the other case text.

 

Where might it be defined so that I cannot use the same lookup in both cases?

Outcomes