cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Resource for reporting

Re: Resource for reporting

Re: Resource for reporting

Added some other reports:

TIPS and TRICKS

Using Java interfaces in QueryBuilder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS33057

How to use the Custom Input Page for a QueryBuilder Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS130739

How to retrieve the Date with no Hours:MinutesSmiley Frustratedeconds in Query builder report using the function

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS139088

Using Java Methods in Query Builder

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS114482

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

How to display all WTParts with Successful ESI Distribution Target using a report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS58679

Query builder report to fetch number of object in each Context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS149816

Query builder report to retrieve the Team, Roles and Users associated to Variances

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS229148

QML report to generate Access Control Lists applied in a specific context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS146799

How to get the Name and Context from any object based on the file vault file name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS229938

How to prepare Query Builder report to generate the Product/Project/Library team members

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS28414

QML Report to generate Access Control Lists applied in a specific context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS146799

Gather a report from WVS job monitor

https://www.ptcusercommunity.com/ideas/6338

Query builder report to list all active users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS209700

How to generate a report listing the projects and tasks where a resource is used

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS98782

QML which gives list of activities (like checkin, checkout etc) performed through both std browser

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS151749

Query Builder Report listing additional information not contained in a security audit report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS234696

How to get the Name and Context from any object based on the file vault file name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS229938

How to determine the number of WtPart in the Commonspace in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS235473

CHANGE MANAGEMENT

QML report to fetch all Change Notice and their associated Team template

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS228394

How to generate a report listing Change Request and the affected objects?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS52010

Query builder report to list Change notice with no affected objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS229390

Change Notice, Change Task, Votes, Assignee, Due Date, Completed Date, Last Modified Date

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS48714

What is the relationship between Change and Changeable Object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS106301

EPMDoc REPORT

PROMOTION and WORKFLOW

How to add Promoted By and Promoted On in advanced search criteria

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS55947

Anyone have a way to find nested family tables?

https://www.ptcusercommunity.com/thread/134675?sr=inbox&ru=369970

Query Builder Report which lists the user and workspace names for checked out versions of CAD Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS232560

How to get the latest EPM DOCrevision using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS184264

Family Table Report with Related WTParts

https://www.ptcusercommunity.com/docs/DOC-8798?sr=stream&ru=3370

PROMOTION and WORKFLOW

Query Builder Lifecycle History Example

https://www.ptcusercommunity.com/docs/DOC-8716

Report showing date of last promotion

https://www.ptcusercommunity.com/thread/135310?sr=stream&ru=263245

WTDOCUMENTS

How to identify the template that was used to create documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS214070

Report all WTParts related to WTDocuments

https://www.ptcusercommunity.com/thread/115318?sr=stream&ru=30733

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS36007

WTPARTS

How to select the latest revision of a Part in a Query Builder report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS1171

How to get a report of the URL address of WTparts

https://www.ptcusercommunity.com/thread/134395?sr=stream&ru=281467

Query to capture WTParts set to Released in the last 4 hours

https://www.ptcusercommunity.com/thread/134896?sr=stream&ru=51671

Query builder report to fetch WTParts in a specific Org that have Part Master Default unit set to "as needed"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS232193

Query builder report to find all WTParts and their corresponding PartsLink classification nodes

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS233215

Report to verify the details of changes in iterations of Part Instance using Described by Documents

http://support.ptc.com/images/cs/articles/2014/10/20163203_G4Hv.qml

Query Builder report to list the Variances reported against Parts

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS234246

SuMa - Report to list the Manufacturer associated with the specific Context Organization

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS234911

TROUBLESHOOTING

When searching for objects that have empty IBA with "not like" criteria, Query Builder and Search UI will give inconsistent results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS159539

Not able to set up changeable filter criteria in Query Builder Approver Status field for attribute eventlist of type wt.workflow.definer.UserEventVector in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS235453

Getting an error message as "Report can only be launched when Windchill Business Reporting is installed" in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS124351

Marco

Re: Resource for reporting

Added some other reports:

TIPS and TRICKS

How to limit Access to Report Template

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS71222

How to specify the output format of a QML report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS131663

How to find the new name of an object when only the old name is known?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS239797

How to retrieve attribute and its value on an object using Report Management

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS115300

What tables are global attribute definitions and values stored

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS53787

How to generate IQY query for Report Manager reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS47169

Database tables references for Security Audit Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS31046

How to use Concatenate function in Criteria section of Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS241697



ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

QML report showing 'No Content association between the Drawing and WTPart'

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS227183

How to identify users listed in the Usage and License Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS107490

Family tables with instances not at same revision as generic

https://www.ptcusercommunity.com/thread/136958?sr=stream&ru=288561

Querybuilder report to display access available to users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS162218



CHANGE MANAGEMENT

QML report to retrieve ECNs and their related EPMDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS239710

Change Requests and their connected Problem Reports

https://www.ptcusercommunity.com/thread/43627?sr=stream&ru=35352

How to get a list of all the ECNs in the Application for a particuar Need Date

https://www.ptcusercommunity.com/thread/133770?sr=stream&ru=36103



EPMDoc REPORT

Report to list all drawings without primary content for CAD document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS237391

How to create a query builder Report that shows Revision History of Drawings which is a soft type of EPM Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS236226

Report to fetch all EPM Documents having copied from representation

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS223584

Report to generate all EPMDocument with all iteration of Lifecycle Template

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS143164

Find all EPM Documents without Visualisation

https://www.ptcusercommunity.com/thread/127349?sr=stream&ru=6342



WTDOCUMENTS

How to create a report listing Documents Context, Name, Number, State, Latest Revision & Iteration, and Age

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS239335

File Name of a document from Query Builder

https://www.ptcusercommunity.com/message/457256

https://www.ptcusercommunity.com/servlet/JiveServlet/download/457256-119614/_Document_Search.qml.zip

TROUBLESHOOTING

Data monitor against "Open Change Notices" report template status is "failed"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS236920

Report to list Suppliers (Manufacturer) with their associated Documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS240978

Query Builder does not list the Display Name of Sourcing Status attribute values in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS241420

Marco

Re: Resource for reporting

Added some Christmas gift reports

TIPS and TRICKS

In Query Builder Report how to group the results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS162153

How to make Report Template available for use with Advanced Search in Windchill 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS245106

How to make a Query Builder report to fetch all the related documents for a specific BOM

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS245097

How to write a report that shows the association type between CAD Document and WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS17200

What are the steps to restrict visibility of Reports available on Saved Reports table for Users or Groups

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS244932

How to add a hyperlink to an object's Details page in Report Manager in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS82387

How to use QML reports upgraded from Windchill PDMLink 9.1 with Legacy Mode in Windchill PDMLink 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS246736

How to get the Checked out date of a CAD Document in a Report in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS246873

What is the relationship between WTUser, remoteobjectinfo and remoteobjectid tables in Windchill PDMLink database

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS94037

Restrict Access by Roles to Query Builder Reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS249618

How to ensure Report Templates and Reports  are available for use in Advanced Search​ in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS245106

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

Report showing the OID for products, library and project

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS237841

Query builder report to fetch Distinguished Name of the user and user name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS244704

Query Builder report to display WTParts having representations

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS247241

Query builder report to fetch Choices and their associated WTPart in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS247434

How to get a report of all Required attributes of a Classification Structure in Windchill PartsLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS247059

How to build a report to list all customer specific preferences in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS249136

How to create a report listing the resource allocation over multiple Projects in Windchill ProjectLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS249153

How to determine if an attribute type defined in Windchill is used anywhere in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS175010

How to generate query builder report which displays user with associated subscriptions

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS23188

CHANGE MANAGEMENT (ECR, ECN, PR, ...)

Query builder report (QML) to fetch problem report with part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS226330

Report listing all Change Requests without an associated Change Notice

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS144673

Is it possible to link Problem Report and Nonconformance in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS249232

Report listing Change Request and the affected objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS52010

EPMDoc REPORT

How to get the Checked out date of a CAD Document in a Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS246873

How to build a report of objects added to workspaces

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS202379

All EPMdocuments with secondary attachments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS249915

Query Builder report [QML] to list all Workspaces

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS250740

PROMOTION and WORKFLOW

How to generate Query Builder report to display "Promoted on" attribute from the Maturity History table of an object

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS11566

How to retrieve records for delegation/reassignment

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS39534

Query builder report to fetch the Open Task assigned to User in a Product

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS246581

WTDOCUMENTS

Report to generate BOM report with Described By and Referenced By Documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS238476

Report to get the document, its state and the role responsible to complete the task

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS245051

Query builder report to fetch document which is not related to any other document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS247264

How to build a report for latest revision of WTDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS251987

TROUBLESHOOTING

Unable to run cognos reports in Windchill 10.2

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS210583

Reports using macro CURRENT_TIME that used to work before update don’t work anymore in Windchill PDMLink 10.2 M030

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS248659

Query Builder Report to get the list of parts which does not have any related document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS251347

Upgraded reports where attributes with an enumerated list that were previously defined in the Criteria tab no longer display the enumerated list in the drop-down in Report Builder in Windchill 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS252519

When user added java method then selected allow user to decide option all of column user is not able to generate report.

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS253057

Marco

Re: Resource for reporting

Hi,

I have a requirement as follows

1. There are 2 document objects used in windchill (say Doc1 and Doc2). Doc2 can be created only when there is Doc1 (i.e. Doc2 can be created from details page of Doc1, The Doc1 number will be added as an attribute value in Doc2)

2. I wanted to create a report such that the output should show the value of Doc1 number and Doc2 number but with the condition that the Doc1 number should be in output even though Doc2 is not created.

Any suggestions would be helpful.

Regards,

Logeshwar.J 

Re: Resource for reporting

Please open a specific discussion with your request.

This way other people could reply if possible.

You have written your comment in a document that it's already very long.

Marco

Re: Resource for reporting

Added some reports (summer edition)

 

TIPS and TRICKS

How to get a date as today in query builder?

https://www.ptcusercommunity.com/thread/141409?sr=stream&ru=379844

 

How to generate a Query Builder report that lists the values of soft type attributes associated to an object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS99727

 

Is it possible to enable Legacy Mode for Query Builder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS112323

 

How can an Outer Join be used when creating a QML report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS125561

 

How to access a calculated attribute in Query Builder 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS126453

 

Is it possible to add some text in particular HTML report page

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS195857

 

Query Builder reports containing the function LOWER are not working properly

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS238773

 

How to use QML reports upgraded from Windchill PDMLink 9.1 with Legacy Mode in Windchill PDMLink 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS246736

 

How to import QML into report management in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS256736

 

How to add context criteria to query builder qml report on EPMDocuments for filtering results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS259441

 

How to create custom macro to use in Query Builder Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS260538

 

How to set the output of a report directly to CSV, XML or xls in Windchill PDMLink 11.0?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS260941

 

How enable SQL button in QML in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS264488

 

How to add a sub-type drop-down list of a parent type on report builder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS267881

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

 

Is it possible to create a Query Builder report for a ProjectLink Routing?

https://www.ptcusercommunity.com/thread/141587

 

How to create report of user checkins?

https://www.ptcusercommunity.com/thread/143951

 

Can’t search for Documents created/modified by deleted users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS17742

 

Query Builder Report for WTObject with the associated IBAs

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS20298

 

How to generate a report to which will accept the user name and will generate a list of Context with the role name in which he is a part of 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS59086

 

How to list all user enable in a report 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS106475

 

Report to list network details corresponding to a Context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS167040

 

Query all workflows to determine for class/method used in them

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS168660

 

Report to fetch the Event Manager Conflicts records

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS213042

 

QML to get the WTPart and EPMDocuments association type along with the Promotion Request number 

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS261567

 

Report to list the attachment download from CAD Document by user

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS267220

Marco

Re: Resource for reporting

Summer edition second part

 

CHANGE MANAGEMENT (ECR, ECN, PR, ...)

 

How to extract the Affected Objects and Resulting Objects associated to a Change Task using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS112463

 

Report showing Reassignment History for Change Task

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS143170

 

How to fetch Change task sequence with Change task name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS191007

 

Query Builder report to fetch the change task with no attachment

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS263438

 

QML to list change notice along with change task information

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS264939

 

Is there a way to get Implementation Plan task sequence number on a QueryBuilder report?

https://www.ptcusercommunity.com/thread/143940?sr=stream&ru=281467

 

EPMDoc REPORT

 

How to search for a CAD object that is in a particular workspace?

https://www.ptcusercommunity.com/thread/141746

 

QML for Drawing >> related objects, Format

https://www.ptcusercommunity.com/thread/142290

 

QML report - Formats where referenced (drawings)

https://www.ptcusercommunity.com/thread/142527

 

How are Representations stored in the database and how are EPMDocuments linked to them

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS17670

 

How to get the new object list that are uploaded but not checked-in from Workspace

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS20630

 

Query Builder Report to fetch CAD Documents for which viewable is not present

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS149329

 

Report that shows lists of all the Objects has Representation or Viewable with File Size

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS165565

 

Report of the latest version of all drawings at any State

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS255899

 

Query Builder report that mimics "References" table on "EPMDocument"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS258372

 

Report listing all models having a drawing reference

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS267362

 

Find Missing CAD Representations within a Specified Date Range

https://www.ptcusercommunity.com/docs/DOC-9945

 

File downloads from CAD Attachments

https://www.ptcusercommunity.com/thread/144545

 

PROMOTION and WORKFLOW

 

How to link SignatureLink and Workflow Process table and fetch data from them

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS258046

 

WTDOCUMENTS

 

How to make a report to fetch the IBA value for all documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS247369

 

Report to fetch the Primary Content URL details of the Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS262052

 

WTPARTS

 

How to create Report that shows link between Parent Part and Part Child?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS263165

 

Overview of WTPartUsageLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS266445

 

A query that will list all WTParts in the system along with the folder they are stored in

https://www.ptcusercommunity.com/thread/141400?sr=stream&ru=321881

 

TROUBLESHOOTING

Query Builder cannot find and add custom attributes to a report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS157493

 

When using the function "System Date" on Select tab of Query Builder, "System Date" is not the same as the server's true time

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS178058

 

Chart displays maximum of 25 values in Query Builder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS200763

 

Query Builder reports containing the function LOWER are not working properly

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS000238773

 

In report template, the case insensitive option doesn't work on IBA gets invalid result

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS244230

 

When user added java method then selected allow user to decide option all of column user is not able to generate report.

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS253057

 

In Query Builder, the character "&" in the name of a Report Template generates a NullPointerException exception when using the report in another report in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS251516

 

QML Object "role.fullDisplay" is not valid on class "Role Principal Map". The property "fullDisplay" is not valid on "wt.project.Role" 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS261768

 

Saved Reports executed from Data Monitor showing status as Executing

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS261779

 

Query builder report errors with An Aggregate may not appear in a where clause unless it is in a subquery contained in a Having clause or a select list, and the column being aggregated is an outer reference when ran in WIndchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS264090

 

Report failed to launch with Exception PropertyDescriptor not found for 'versionIdentifier.versionSortId' attribute in the class: wt.part.WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS266961

Marco

Re: Resource for reporting

Re: Resource for reporting

Hi Vincent,

thanks for your comment, but at the moment I cannot modify the link because of the limitation of the new site.

 

I just tried and it says that it's not possible because text is more than 20,000 digit long.

 

 

Marco