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

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

MikeLockwoodAnswer
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.

View in thread

2 replies

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.

Translate
    joe_morton
    joe_morton19-Tanzanite
    19-Tanzanite
    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"

    Translate
    Terms & ConditionsAccessibility statement