NSQL Portlets not bringing up Image for Lookup Attribute


Article ID: 205938


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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


Release : 15.8.1

Component : CA PPM STUDIO


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