JQL filter for specific issue status

[Zahid Hasan]

I have a board that contains only tasks and sub-tasks. I would like to apply a filter that would exclude any task in "New" status but include all Sub-Tasks in "New" status. Any idea how to achieve this?

[Nic Brough -Adaptavist-]

The basic query for this could be done in several ways, but the most obvious one is simply:

Status = New and issuetype != task

But you might want to be a bit more clever/flexible and use

Status = New and issuetype in subtasktypes()

[Zahid Hasan]

Thanks a lot for the quick follow up! I've tested your suggestion and it works. Although I might not have clearly mentioned my requirement. Currently this filter is bringing in only sub-tasks in New status. How do I include all the other status? 

I'm working with the following status: New, Ready, To Do, Ready For Review, In Process. If the status is New, then I only want to see sub-tasks (no Tasks) but for all other status (Ready, To Do, Ready For Review, In Process) I want to view both Tasks and Sub-Tasks. Hope I this makes sense. 

[Nic Brough -Adaptavist-]

To get other status in, either don't filter by it at all, or give it a list - Status in (New, Ready, In progress) for example.