How can we write nested queries in Jira

Question

Hello,

Can somebody please help me with the following scenario:

How could something like this could be achieved in Jira?

Query: project = project-name  AND type = Sub-task (type = Story AND status changed TO "Development Done")

I want Sub-tasks as my results but filter them according to the changed status at a Story.

Hierarchy:

* Story* Sub-tasks

If I write,

Query: project = project-name  AND type = Sub-task AND status changed TO "Development Done"

then the query filters the data according to the Status changed at sub-tasks.

Thanks a lot in advance.

Regards,

Udita

Mel Dett · Answer

looking for help.

I have a query resulting in a list of Epic Links

Now I want to list the labels within the list of Epic Links.

Seems like a nested filter or sub-query or something.

Any thoughts?

Thomas Schlegel · Answer

Back again

Sorry Udita, but I didn't find a function that is able to compare the status changed date from the main issue with the creation date of the subtask. Even with Scriptrunner. It might be possible to add a scripted field, maybe someone else has a solution for that?

Thomas Schlegel · Answer

hmm, that's tricky. I don't know, if I can find an answer for that. I will try and answer later again. Don't have much time at the moment to try things out.