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

We are happy to announce the new Windchill Customization board! Learn more.

Query Builder Help

kirkwemple
8-Gravel

Query Builder Help

Attached is a query builder report for listing work items assigned to disconnected users.  I have been able to get it to work for products or libraries only.     Does any one have any guidance for how I can define the report to return work items for both products and libraries in the same report.  Thanks.

 

--Kirk Wemple

1 ACCEPTED SOLUTION

Accepted Solutions

Hi Kirk,

Appears that you should just remove "Product" from the Tables and Joins tab. That will return all.

Could add container name on the Select or Constraint tab to be able to see where the task is.

 

I imported the qml, deleted the Product type and it seems to work.

View solution in original post

2 REPLIES 2

Hi Kirk,

Appears that you should just remove "Product" from the Tables and Joins tab. That will return all.

Could add container name on the Select or Constraint tab to be able to see where the task is.

 

I imported the qml, deleted the Product type and it seems to work.

To add to that, if you do want to know the Product/Library the task is in, you can use the table called "Context". It gives Product and Library info. I believe the field is "Context Name"

Top Tags