Just wondering again...
I have this section in my NSQL
WHEN odf.top= 1 Then 'Yes'
Works fine and I can associate the attribute with a lookup
When I have this NSQL section in another portlet
WHEN odf.top = 1 Then 'Yes'
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?