I need to get a filter query that produces results containing only the planned end date and GA date, and additionally also fetches the tickets that has either the planned end date or solely the GA date.
Query:
project in (ABC, DEF, HIJ) AND issuetype in (Epic, Initiative, Objective, Story) AND Team in (350, 44, 357, 191, 376, 362, 361, 344, 340, 341) AND status in (Backlog, Planned, "Needs Info", "In Progress", Testing, Execution, "Ready For Test", Grooming, Discovery, Canceled, Done, Funnel, "Ready for Release", Adoption, "Solution Design", "Public Tech Preview", "Private Tech Preview") AND "GA Date" >= 2025-03-1 AND "GA Date" <= 2025-03-31 OR "Planned End" >= 2025-03-01 AND "Planned End" < 2025-03-31
Query:
project in (ABC, DEF, HIJ) AND issuetype in (Epic, Initiative, Objective, Story) AND Team in (350, 44, 357, 191, 376, 362, 361, 344, 340, 341) AND status in (Backlog, Planned, "Needs Info", "In Progress", Testing, Execution, "Ready For Test", Grooming, Discovery, Canceled, Done, Funnel, "Ready for Release", Adoption, "Solution Design", "Public Tech Preview", "Private Tech Preview") AND "GA Date" is not EMPTY
You need to enclosing brackets to set operation precedence. I have added few brackets to meet your requirement of
You will have to play around with below query adjusting the brackets and make it work based on your requirement.
project in (ABC, DEF, HIJ) AND issuetype in (Epic, Initiative, Objective, Story) AND Team in (350, 44, 357, 191, 376, 362, 361, 344, 340, 341) AND status in (Backlog, Planned, "Needs Info", "In Progress", Testing, Execution, "Ready For Test", Grooming, Discovery, Canceled, Done, Funnel, "Ready for Release", Adoption, "Solution Design", "Public Tech Preview", "Private Tech Preview") AND ((("GA Date" >= 2025-03-1 AND "GA Date" <= 2025-03-31) OR ("Planned End" >= 2025-03-01 AND "Planned End" < 2025-03-31)) or ("GA Date" is not Empty or Planned End is not Empty))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm not joking here but ChatGPT actually writes pretty killer JQL. Try this and then troubleshoot it with GPT
project in (ABC, DEF, HIJ) AND issuetype in (Epic, Initiative, Objective, Story) AND Team in (350, 44, 357, 191, 376, 362, 361, 344, 340, 341) AND status in (Backlog, Planned, "Needs Info", "In Progress", Testing, Execution, "Ready For Test", Grooming, Discovery, Canceled, Done, Funnel, "Ready for Release", Adoption, "Solution Design", "Public Tech Preview", "Private Tech Preview") AND (("GA Date" >= 2025-03-01 AND "GA Date" <= 2025-03-31) OR ("Planned End" >= 2025-03-01 AND "Planned End" < 2025-03-31))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.