Story status is incorrect

[Manikandan K]

I would like to filter all the stories that have incorrect status 

For Example :

I have my sub-tasks are closed and story status is not updated by my team and it remain in "In-progress"

I would like to identify those stories using JQL. Let me know if we have any query for it ?

[Suhas P]

If I am understanding correctly, you want to find Stories where Sub Tasks are closed. You can use script runner JQL function 'parentsOf'

Ex.  issueFunction in parentsOf("status=closed")

OR 

issueFunction in parentsOf("project = JRA and status not in Open")

 I assume '!' will work for the query. I referred it from here https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_parentsof

[Manikandan K]

Nope. Its doesnt give the required results

[Suhas P]

Seems like difficult to find parent issue where all sub tasks are closed. But you can find parent issue where at least one sub task is closed with this query.

issueFunction in parentsOf("status not in ('To Do','In Progress',Open,Reopened)")