How to list the incomplete tasks of completed stories?

[Anon Anon]

I'm trying to list the incomplete tasks of completed stories.

How would I query the task of a story that is in the complete state? Will someone help me out? Also, if there is a resource you can recommend for query examples/help outside of the basics included in the CA help menu that would be much appreciated. Thank you. 

[Legacy User]

Brian, 

A query like: (State = '"Completed") would work for identifying those Completed tasks! As far a secondary resource, honestly checking out Stack Overflow or posting here is probably your best bet!

[Anon Anon]

Thank you John. I am still looking for a second piece to that query... "the task of a story that is completed." (State = "Complete") will provide me stories in the complete state but I'm also trying to combine that with the task of said completed story. How do I query the relationship of tasks to stories? With that answer I can then combine it with the (State = "Complete") to get teh results I'm looking for.

-Brian 

[Legacy User]

Brian, that's what that query would do - find completed Tasks. If I were trying to query for completed Stories, I would query on the ScheduleState field, not State. 

Are you trying to list stories with completed tasks? Or are you just trying to list tasks?

I would definitely recommend creating a custom page  (https://help.rallydev.com/create-custom-pages)then adding the Custom List app (https://help.rallydev.com/custom-grid). It makes it really easy to filter for what you're looking for on the front end. In the app's setting (gear at top-right), you can set the kind of work item that you want to see, whether it's Tasks, Stories, Defects, Portfolio Items, etc. Using Advanced Filters from the app, you can really drill down to specifically what you're looking to show. 

I just recorded a screen capture showing how set it up showing Tasks that are completed: http://screencast.com/t/MTKR2UxiQ

If you do want to show Stories with Completed Tasks, I believe if you filter on Task Status = COMPLETED (using those front-end filters), it will only show the stories where all tasks are completed, if that makes sense. 

[Anon Anon]

Thank you again John. I apologize for not being clear. I didn't want to confuse what I was after with too much detail. I'm trying to list the incomplete tasks of completed stories. Our backlog is a mess, including stories that have been marked completed but have outstanding tasks. A custom page is exactly where I'm going with this but I haven't been able to find a way to query the associaton between tasks and stories without knowing exactly which story. 

[Legacy User]

Ah! Thanks for that clarification! In that case, I'd use a Custom List app on the Task work item type, with the following query: 
 

((WorkProduct.ScheduleState <= "Completed") AND (State != "Completed"))

[Anon Anon]

That's it James. Thank you. With a little validation this seems to be what I am needing.

[Anon Anon]

It appears as though my question might need updating if this is to help anyone else. I am unable to edit it but would be happy to allow an admin to adjust it.

[Legacy User]

Updated! Thanks Brian!