How to pull defects attached to test cases in workproduct field, but exclude user stories

[Simon Varley]

Hi All,

I'm trying to query which Test Cases have workproduct defects with a specific milestone (release). I can find all workproducts with a given milestone, but I get user stories and defects. How do I just pull the defects?

The fields that I've tried that are only present on defects won't query.

(WorkProduct.Milestones.FormattedID = MI999) <<-- this works fine from Test Case but I get defects and user stories.

Any suggestions?

Many thanks
-Simon Varley

------------------------------
[JobTitle]
[CompanyName]
[State]
------------------------------

[Sagi Gabay]

Hi Simon,

There isn't a straight forward way to do this, but it can be done. There is a hidden field on the Artifact object named: TypeDefOid . This holds the definition object id of the object. So, if you wanted to distinguish only the defects for example, you'll need to:

1. Query the TypeDefinition endpiont and use a query such as: (Name = "Defect"), then find the ObjectID. let's say you get "12345".
2. Back in your TestCase query, do:  ((WorkProduct.Milestones.FormattedID = "MI999") and (WorkProduct.TypeDefOid = 12345))

This will get you the workproducts of that test case which are only defects. Similarly, you can change #1 to query the TypeDefOid for other objects such as user story (HierarchicalRequirement) and others.

Please let us know if that helped.
Sagi

​

[Simon Varley]

Perfect!

All my dashboards are now showing only defects.

Thanks Sagi, that's a very useful trick for the toolbox.

Best regards.
Simon Varley

------------------------------
[JobTitle]
[CompanyName]
[State]
------------------------------

[Sagi Gabay]

:)

Good deal. Glad it helped.

Sagi