Report filtering from different tables

[nwittmann]

As an end user I want to create a dashboard filter that shows a status of scrum tasks for open stories.   

I'm working in the Agile Development module and have created a filter looking at the Scrum task [rm_scrum_task] Table.  I would like to filter on tasks where the parent story is not closed, however story status is located on the Story [rm_story] table.   How can I reference both the scrum task table and the story table?  

My current workaround is to add and remove a global tag from each task once its created and closed, respectively.  

[Zach Koch · Accepted solution]

Should be able to do this in a report. You would report on the rm_scrum_task table, like you are already, then in the filter conditions select Parent, hit the arrow next to it, then click State. Then choose is not, or is not one of, and select the states you want it to look for, then hit Run. This will return all Scrum tasks where the Parent is not whatever states you selected. Here is a picture of what that would look like