Thanks to Bjarne and Brian.
You must use the Count function with a GROUP BY. Once activating GROUP
BY I counted the ECR rows and got the output I needed!
Thanks again!
Darin
From: Darin Sensabaugh
Sent: Wednesday, October 01, 2008 9:31 AM
To: solutions@ptcuser.org
Subject: [solutions] - Report Manager (Query Builder) Question
All,
I have my query about 95% complete but I'm having difficulty with the
final step.
My query joins the Change Request, Change Order, Change Activity and
Changeable.
It returns the ECR linked to its ECO, the creator of the ECR, the
Context, ECR cycle time, track, ECR to ECO cycle time and the affected
data in the Change Activity.
Currently its giving me individual lines for each affected item in the
Change Activity; see below:
ECR No.
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=1&sortOrder=asc>
Creator
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=2&sortOrder=asc>
Context
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=3&sortOrder=asc>
ECR Cycle Time
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=4&sortOrder=asc>
Track
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=5&sortOrder=asc>
ECO No.
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=6&sortOrder=desc>
ECR to ECO
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=7&sortOrder=asc>
Affected Data
ECR-00046
olivierc
FNP-9_40_357
14
Fast
ECO-00003
7
47451.PRT - SEAR, -
ECR-00046
olivierc
FNP-9_40_357
14
Fast
ECO-00003
7
47451.PRT - SEAR, -
ECR-00046
olivierc
FNP-9_40_357
14
Fast
ECO-00003
7
47451.DRW - SEAR, -
Instead of 3 lines displaying the affected data, I want a single line
with the count of the affected items; see below:
ECR No.
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=1&sortOrder=asc>
Creator
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=2&sortOrder=asc>
Context
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=3&sortOrder=asc>
ECR Cycle Time
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=4&sortOrder=asc>
Track
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=5&sortOrder=asc>
ECO No.
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=6&sortOrder=desc>
ECR to ECO
<
http://c12460.fncorp.com/Windchill/servlet/WindchillAuthGW/wt.enterprise.URLProcessor/invokeAction?u8&action=ProduceReport&u8=1&oid=OR%3Awt.que
ry.template.ReportTemplate%3A68432407&jrb=wt.query.template.reportTempla
teRB&sortByIndex=7&sortOrder=asc>
Affected Data Count
ECR-00046
olivierc
FNP-9_40_357
14
Fast
ECO-00003
7
3
I've tried the count function, but I don't believe this is it's intended
use. Does anyone have any suggestions?
I've attached the qml file for reference.
Thanks,
Darin Sensabaugh
Manager-Engineering Services
FN Manufacturing, LLC
-----End Original Message-----
