PTIASPRPTRESTXT

(SQL View)
 Index Back

BUG Resolution Text

This view combines the BUG resolution text entries into a single field.

SELECT PTIASPRPTNO , LISTAGG(PTIASPRPTBODYCOMNT , ' ') WITHIN GROUP ( ORDER BY PTIASPRPTBODYLN) AS "PTIASPBUGENTRIES" FROM PS_PTIASPRPTBODY 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 PTIASPBUGENTRIES Long Character CLOB Bugs