Using CONCAT in NSQL query

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Looking for hints to create an NSQL lookup query to concatenate two string fields and get the resulting values in a single field.

Resolution

Sample NSQL query based on the CONCAT function on a default clarity table.

SELECT
@SELECT:I.CODE:CODE@,
@SELECT:I.NAME:NAME@,
@SELECT:I.FULL:FULL@
FROM
(select
ID as ID,
CODE as CODE,
NAME as NAME,
concat(concat(NAME,'-'),CODE) as FULL
FROM INV_INVESTMENTS
) I
WHERE  @FILTER@