PTIASPRPTRESTXT

 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 Field Type Column Type Description
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPBUGENTRIES Long Character CLOB Bugs
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20