PTIASPTAGVW

 index back

BUG Status by TAG

BUG Percentage Applied / Unapplied by TAGs
SELECT DISTINCT D.DBNAME , T.PTIASPRPTTAGNAME , T.PTIASPRPTTAGVALUE , ROUND((( SELECT COUNT(*) FROM PS_PTIASPLOGTGT L , PS_PTIASPRPTTAGS T2 WHERE L.PTIASPRPTNO = T2.PTIASPRPTNO AND L.DBNAME = D.DBNAME AND T2.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T2.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE ) * 100 / ( SELECT COUNT(*) FROM PS_PTIASPRPTTAGS T1 WHERE T1.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T1.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE)),2) AS PERCENT ,'Applied' AS "BUG Status" FROM PS_PTIASPRPTTAGS T, PS_PTIASPTGTDBVW D UNION SELECT DISTINCT D.DBNAME , T.PTIASPRPTTAGNAME , T.PTIASPRPTTAGVALUE , ROUND(100-(( SELECT COUNT(*) FROM PS_PTIASPLOGTGT L , PS_PTIASPRPTTAGS T2 WHERE L.PTIASPRPTNO = T2.PTIASPRPTNO AND L.DBNAME = D.DBNAME AND T2.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T2.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE ) * 100 / ( SELECT COUNT(*) FROM PS_PTIASPRPTTAGS T1 WHERE T1.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T1.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE)),2) AS PERCENT ,'Unapplied' AS "BUG Status" FROM PS_PTIASPRPTTAGS T, PS_PTIASPTGTDBVW D ORDER BY 1,2,3

PeopleSoft Field Name Field Type Column Type Description
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
PTIASPRPTTAGNAME Character(30) VARCHAR2(30) NOT NULL TAG Name
PTIASPRPTTAGVALUE Character(254) VARCHAR2(254) NOT NULL TAG Value
PTIA_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent field for PTIA use.
PTIA_TEXT1 Character(15) VARCHAR2(15) NOT NULL Text field for PTIA use.
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20