http://dants155.rsta.drs.master/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/URLTemplateAction?format=formatDelegate&delegateName=HTMLWithSorting&xsl1=&xsl2=&oid=OR%3Awt.query.template.ReportTemplate%3A15215037&action=ExecuteReport

http://dants155.rsta.drs.master/Windchill/
servlet/WindchillAuthGW/wt.enterprise.URLProcessor/URLTemplateAction
?format=formatDelegate&delegateName=HTMLWithSorting
&xsl1=
&xsl2=
&oid=OR:wt.query.template.ReportTemplate:15215037
&action=ExecuteReport

SELECT A0.name C1C0,A1.namecontainerInfo C1C1 FROM ReportTemplate A0,(SELECT A1.namecontainerInfo,A1.idA2A2 FROM ExchangeContainer A1 UNION ALL SELECT A1.namecontainerInfo,A1.idA2A2 FROM OrgContainer A1 UNION ALL SELECT A1.namecontainerInfo,A1.idA2A2 FROM WTLibrary A1 UNION ALL SELECT A1.namecontainerInfo,A1.idA2A2 FROM PDMLinkProduct A1 UNION ALL SELECT A1.namecontainerInfo,A1.idA2A2 FROM Project2 A1) A1 WHERE (((A0.name LIKE 'All%') OR (A0.name LIKE 'Average%'))) AND ((A0.idA3containerReference = A1.idA2A2)) ORDER BY  NLSSORT(C1C1,'NLS_SORT = ASCII7'), NLSSORT(C1C0,'NLS_SORT = ASCII7')

Connect time(ms): 1313

Connected to jdbc:oracle:thin:@dants155.rsta.drs.master:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 125

C1C0|C1C1
All Average Change Notice Completion Time|Site
All Average Change Request Completion Time|Site
All Average Problem Report Completion Time|Site
All Change Notice Influx And Resolution|Site
All Change Request Influx And Resolution|Site
All Open Change Notices|Site
All Open Change Requests|Site
All Open Problem Reports|Site
All Problem Report Influx And Resolution|Site
Average Change Notice Completion Time|Site
Average Change Request Completion Time|Site
Average Problem Report Completion Time|Site

