Searching for Parent issues with subtask fixversion != "xyz"

[Madhu Kiran Yalamanchili]

I am trying write a JQL to get bugs with sub-tasks not having fixversion as XYZ. 

A bug may have multiple subtasks with Fixversion as XYZ, XDF, XDE and ABC, but i need Subtasks with fixversion XYZ to be excluded from search results.

This is the query which i have written

issueFunction in parentsOf("project = DEF and fixversion not in ("XYZ") and resolution = fixed") AND type = Bug AND created >= 2018-10-01

[Petter Gonçalves]

Hello Madhu,

I understand that you are using the behaviors functionality of Script runner to configure the query, is that correct?

Analyzing your query, it seems to be correct to me. Please, let me know if this query works:

issueFunction in parentsOf("fixversion not in ("XYZ")")

You can also achieve this functionality by using JQL Tricks plugin and perform the following query:

issue in subtask("fixversion not in "XYZ")

Please, let me know if one of the queries above has worked for you.