NSQL Portlets not bringing up Image for Lookup Attribute

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When trying to see a lookup attribute (image option at field level is selected ) in the NSQL Portlet, the image does not come up. 

Environment

Release : 15.8.1

Component : CA PPM STUDIO

Resolution

The image is not showing because the Display Mappings on the Query Attribute will not work as it is trying to map the lookup value codes to the lookup value names . It would only work if the NSQL was querying specifically for the value codes. In this case, the NSQL query results would be looking at value codes, and so would the Display Mappings, so the image will show on the field as expected. 

Additional Information

Also see KB205939: Export to Excel does not export Range Descriptions