Rally Software

  • Private Community
Back to discussions
Expand all | Collapse all

Can I execute a query of all work items assigned to an individual in a single search?

  • 1.  Can I execute a query of all work items assigned to an individual in a single search?

    Posted Jan 19, 2016 09:18 AM
    I manage an infrastructure team, with some team members assigned to Kanban, Agile, or both styles of task management. So, some team members are assigned tasks, and others are assigned user stories, etc... Is there a way I can create a query for a specific user that will capture all their work (user stories, tasks, defects, etc...)?  I figured the various custom list functions would work, but they all force you to choose a single work type. I have also created custom fields that are shared across all work items, but cannot figure out how to execute a query that will go across all work items to make this work.  Any help would be welcomed!


  • 2.  Re: Can I execute a query of all work items assigned to an individual in a single search?
    Best Answer

    Posted Jan 20, 2016 03:33 PM
    Jamie, check out the Web Services API documentation at https://rally1.rallydev.com/slm/doc/webservice -- it's very helpful for figuring out stuff like this.  Each object shows its parent, so you should be able to go up to the Artifact object, and do a query for (Owner = "name@company.com").  


  • 3.  Re: Can I execute a query of all work items assigned to an individual in a single search?

    Posted Sep 21, 2018 11:00 AM

    Hello 867d23a130e822cf914e52a7538a77e2

    I am also looking for the same query. Were you able to find out the right query to get this view?

    Regards

    -Pankaj



  • 4.  Re: Can I execute a query of all work items assigned to an individual in a single search?

    Posted Sep 21, 2018 01:10 PM

    I would be interested in knowing this too.



  • 5.  Re: Can I execute a query of all work items assigned to an individual in a single search?

    Broadcom Employee
    Posted Sep 21, 2018 01:41 PM

    Hi Niveditha, Pankaj:

     

    I'll try to be comprehensive with this answer. The question here isn't the query but what you are actually asking for. I'll explain:

     

    If you are asking for some text export, to a file or something like that, then you can use the WSAPI page, go to the Artifact endpoint and run the query mentioned earlier (Owner = "<Rally username>") . You can run it from Postman or any of the API supported tool-kits. That will return a JSON structured response with all artifacts owned by that user. You can then filter or manipulate that JSON to get data exported in a way that meets your needs.

     

    I get a sense you're not asking about a text export but about an actual screen or app inside the product. There isn't anything like that, but here is an app that is not too far. This app (GitHub - RallyCommunity/artifact-store-example ) is an example that you can tweak or extend. You can see the code of that example in the source file: artifact-store-example/App.js at master · RallyCommunity/artifact-store-example · GitHub  . In this source you can see that this example app instantiates models for 'User Story' and 'Defect', it filters by 'Last Update Date' and fetches/displays the 'FormattedID', 'Name' and 'Feature' fields.

     

    The point of this app is that it's using the Artifact store (line 15 in the App.js file) which means it can include models of any or all artifacts. The example only instantiates this store with models for 'User Story' and 'Defect' (line 16) but you can change it to include all the artifacts you're interested with. 

     

    Note: There isn't a generic model named 'Artifact'. You will need to edit line 16 and specify the artifact-types you want to include.

     

    You will need to then specify the columns you're interested to display in the 'Fetch' field (line 17).

     

    So, you may want to download this app, but then you will need to develop what you need yourself using the SDK and working with the Rally App Builder. 

     

     

    I hope this helps. Let me know if you have any questions.

     

    Thanks,

    Sagi



  • 6.  Re: Can I execute a query of all work items assigned to an individual in a single search?

    Posted Sep 21, 2018 04:21 PM

    Thanks Sagi. I'll give this a try!