I had created a query (custom list, type: test case) in order to receive an overview of failed test cases where no defect is assigned.
((LastVerdict = "Fail") AND (Defects.ObjectID = null ))
This basically works.
Now I would like to extend the query:
The description of all available defects shall be parsed against the TC ID (e.g. TC1234) which was found in the query stated above.
Reason: not all defects are assigned to the corresponding TC, but often the relevant TC ID is enlisted in the description