PTIASPRPTTAGSVW

(SQL View)
 Index Back

BUG Tag Values

Concantenated list by BUG of Tag Name/Value pairs.

SELECT PTIASPRPTNO , LISTAGG((PTIASPRPTTAGNAME||':'||PTIASPRPTTAGVALUE) , ' | ') WITHIN GROUP ( ORDER BY PTIASPRPTNO) AS "PTIASPRPTTAGLONG" FROM PS_PTIASPRPTTAGS GROUP BY PTIASPRPTNO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
2 PTIASPRPTTAGLONG Long Character CLOB Long character field for concatenating Tag Name / Value pairs for a BUG into a single field.