Query Builder Help

[kirkwemple]

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

[MikeLockwood · Accepted solution]

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.

[joe_morton]

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"