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

Query Builder Help

kirkwemple
5-Regular Member

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
mlockwood
19-Tanzanite
(To:kirkwemple)

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
mlockwood
19-Tanzanite
(To:kirkwemple)

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

joe_morton
13-Aquamarine
(To:kirkwemple)

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"

Announcements