AnsweredAssumed Answered

Look Ups in Queries

Question asked by krista.frimel on Mar 8, 2011
Latest reply on Mar 8, 2011 by krista.frimel
I've modified some NQSL to include a custom field (pulled from odf_ca_inv) that has an associated lookup. I've identified the lookup to use in the Attributes section of the query. When displaying the results through a portlet, it displays the ID value of the lookup field i.e. it displays the ID of e_datacenter instead of the Lookup Value of Data Center. How do I get the Lookup Value to display instead of the ID? Is that a change needed in the NSQL?

Outcomes