AnsweredAssumed Answered

Trying to combine two object links (old vs new) into one column of NSQL query/portlet using UNION

Question asked by GregPaisley62353433 on Mar 31, 2016
Latest reply on Apr 5, 2016 by Dave_3.0

We are running CA PPM 14.3.  I am creating a NSQL query/portlet and have the following question.  The query is a UNION query between an old sub-object of the project object (custom Risk Assessment object) and a newer version of this sub-object.  The query returns rows from the old and new objects.  I have created two separate links to connect to the Properties page of the old sub-object and the Properties page of the new sub-object.  My links are working for both sub-objects .... but I have to return two columns in the query .... one column for the old link and one column for the new link.  One of these columns is always blank for each row.  My question is ..... is there a way to combine the columns so that I can place the correct (old or new) link into the one column?  Thanks for any help!  Greg P

Outcomes