Rally Software

 View Only
  • 1.  Query User Stories with Attachments

    Posted Dec 11, 2019 09:10 AM
    I would like to create a list of user stories that have attachments but can't seem to find the field name to use in a query. Is this possible?

    ------------------------------
    Agile Coach
    Boston, MA
    ------------------------------


  • 2.  RE: Query User Stories with Attachments

    Broadcom Employee
    Posted Dec 11, 2019 09:16 AM
    Edited by Nik Antonelli Dec 11, 2019 09:18 AM
    Hi Stephen,

    The easiest way would be to put a Custom List app on a page and set the app settings to select UserStories and the set the query box to: (Attachments.ObjectID != 0)

    ------------------------------
    Nik
    Rally Sales Engineer
    Rally Software
    ------------------------------



  • 3.  RE: Query User Stories with Attachments

    Posted Dec 11, 2019 09:32 AM
    Hi Nik,
    Thanks for the quick response!

    I tried that query. The field (Attachments.ObjectID) is correct. But, the !=0 operator returns all user stories, even those without attachments. I tried (Attachments.ObjectID > 0) and got the results I'm looking for.  Thanks for the lead! ​

    ------------------------------
    Agile Coach
    Boston, MA
    ------------------------------



  • 4.  RE: Query User Stories with Attachments
    Best Answer

    Broadcom Employee
    Posted Dec 11, 2019 09:42 AM
    Doh! Of course! I should have written (Attachments.ObjectID != null)

    ------------------------------
    Nik
    Rally Sales Engineer
    Rally Software
    ------------------------------