PTIASPRPTTAGSVW

 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 Field Type Column Type Description
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPRPTTAGLONG Long Character CLOB Long character field for concatenating Tag Name / Value pairs for a BUG into a single field.
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20