Skip to main content
K
kirkwemple11-Garnet
11-Garnet
October 8, 2021
Solved

Query Builder Help

  • October 8, 2021
  • 2 replies
  • 1590 views

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

Best answer by MikeLockwood

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.

2 replies

M
22-Sapphire I
MikeLockwood22-Sapphire IAnswer
22-Sapphire I
October 8, 2021

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
    18-Opal
    joe_morton18-Opal
    18-Opal
    October 11, 2021

    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"

    Terms & ConditionsCookie settingsAccessibility statement