locked
Query to Get Bugs and Userstories RRS feed

  • Question

  • HI Team,

    we know that there can be a userstory linked to a Bug or test case.

    Can you please share Query that I can run from TFS->New Query to get below info

    a. BugId's that has Userstory linked

    b. BugId that has testcase linked and this Testcases has userstory

    Friday, November 24, 2017 9:48 AM

All replies

  • Hi Anil,

    Thanks for posting there.

    You could create a query like these below. This find all test cases and bugs under user story.

    click the Column options, you could add the ID column to this query.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Sunday, November 26, 2017 4:09 AM
    Moderator
  • Hi,

    Thanks for your valuable inputs.

    Using the above query I can get User stories that has linked bugs, but there could be Userstories that do not have bugs directly linked to it. For these type of user stories(which has not direct bugs linked), I want to get testcase links from user stories and from test case we can get linked bugs. If test case does not have bugs linked I will ignore.

    Is there any query using which I can get this info..

    Thanks,

    Anil

    Wednesday, November 29, 2017 4:58 AM