PTC/USER Portal

Welcome, Lawrence Jett - PTC/USER Members

11:27 PM America/Central

Query Builder Reports

Query Builder Reports

Jan 17, 2008 12:24 PM


I was looking for information to help build a Query Builder report where a Product Number is given and a report of all WTParts within that Product is generated.  Anyone have such a report or details for which tables need to be used and joined?

 Also, would everyone that has a Query Builder report be interested in submitting for others to reference?


Query Builder Reports

Jan 17, 2008 12:42 PM


James,

If you mean "Product" as a Context, then you might be able to use
Context="Product Name" or join WTParts to Context and set Context name to
"Product Name." I do that for documents in project link, so it might work
for parts in pdmlink.

But if you mean "Product" as a top level item in a bill of material that
has a special designation as a "product" rather than some other part, then
Query Builder isn't going to be as as useful as other BOM-related tools,
like the BOM report, or using baselines, or the multi-level where used
report, etc.

Al Anderson
Solar Turbines





"James Little" <james.little@corning.com>
01/17/2008 10:24 AM
Please respond to
"James Little" <james.little@corning.com>


To
solutions@lists.ptcuser.org
cc

Subject
[solutions] - Query Builder Reports




Caterpillar: Confidential Green Retain Until: 02/16/2008



I was looking for information to help build a Query Builder report where a
Product Number is given and a report of all WTParts within that Product is
generated. Anyone have such a report or details for which tables need to
be used and joined?
Also, would everyone that has a Query Builder report be interested in
submitting for others to reference?
_____________________________________________View Online:
http://portal.ptcuser.org/p/fo/st/post=58355&anc=p58355#p58355
_____________________________________________Windchill Solutions mailing
listmailto:solutions@lists.ptcuser.orgManage your subscription at:
http://portal.ptcuser.org/p/us/to/Use of this email content is governed by
the terms of service at:
http://portal.ptcuser.org/index.php?module=sthtml&op=load&sid=s1_010_tos
_____________________________________________

Query Builder Reports

Jan 17, 2008 02:22 PM


James,
The attached report can be used for either WTPart structure of WTProduct structure. I currently have the following being selected:

Part/Product Number|Part/Product Name|Part/Product Version|Part/Product Iteration|Line Number|Used Part Number|Used Part Name|Used Part Quantity|Used Part Unit|Used Part State|Used Part Context

You should be able to import this .qml into query builder and make any necessary changes.

Hope this helps,
Dax Williams
Business Administrator
Lifetime Products
dwilliams@lifetime.com<mailto:dwilliams@lifetime.com>

From: James Little [mailto:james.little@corning.com]
Sent: Thursday, January 17, 2008 11:24 AM
To: solutions@lists.ptcuser.org
Subject: [solutions] - Query Builder Reports


I was looking for information to help build a Query Builder report where a Product Number is given and a report of all WTParts within that Product is generated. Anyone have such a report or details for which tables need to be used and joined?

Also, would everyone that has a Query Builder report be interested in submitting for others to reference?


-----End Original Message-----

________________________________________________________________________
This email has been proactively scanned for all known and unknown viruses. This message is now certified Virus-free.
________________________________________________________________________

Attachments:
PartUsesReport.qml
(5.1k) - Jan 17, 2008 02:23 PM   [1376]


Copyright © 2009 PTC/USER. All Rights Reserved
All material, files, logos and trademarks within this site are copyright their respective organizations.
Terms of Service - Privacy Policy - Contact

Logout


Are you sure you want to logout?
Yes No