Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
JQL Queries for Optix Repair
(Project = EIQV_COARELEASEMGMT OR Project = KFTV_COFEEREPAIR)
AND Status = Closed
AND Bucket = SimplexRepair
AND Resolved > startOfYear()
AND (Type = Bug OR Type = AdHoc)
AND (Summary ~ "Optix Repair" OR Summary ~ "Simplex Repair")
AND (Summary !~ "Admin Tool" OR Summary !~ "D&SS")
ORDER BY Created DESC
(Project = EIQV_COARELEASEMGMT OR Project = KFTV_COFEEREPAIR)
AND Status != Closed
AND Bucket = SimplexRepair
AND (Type = Bug OR Type = AdHoc)
AND (Summary ~ "Optix Repair" OR Summary ~ "Simplex Repair")
AND (Summary !~ "Admin Tool" OR Summary !~ "D&SS")
ORDER BY Created DESC
Bucket = SimplexRepair
AND (Project = EIQV_COARELEASEMGMT OR Project = KFTV_COFEEREPAIR)
AND Type = Bug
AND Summary ~ "Optix Repair"
AND Status != Closed
ORDER BY Created DESC
(Project = EIQV_COARELEASEMGMT OR Project = KFTV_COFEEREPAIR)
AND BUCKET = SimplexRepair
AND (
Summary ~ "Simplex Repair"
OR Summary ~ "Optix Repair"
OR Bucket = SimplexRepair
AND (Summary !~ "Admin Tool" OR Summary !~ "D&SS")
)
AND (Type = Bug OR Type = AdHoc)
AND Status != Closed
ORDER BY Status DESC
Bucket = SimplexRepair
AND Type = Bug
AND (Project = EIQV_COARELEASEMGMT OR Project = KFTV_COFEEREPAIR)
AND Summary ~ "Optix Repair !HSI"
AND (
(Created > startOfDay(-1) AND Created < startOfDay())
OR (Resolved > startOfDay(-1) AND Resolved < startOfDay())
)
ORDER BY Status ASC
@jpelton-stroud
Copy link
Author

  • optix-jira-search - Initial search query; incls Summary ~ "Admin Tool" even though intention appears to be to excl
  • optix-jira-search-modified - initial search modified to properly excl Summary ~ "Admin Tool"/"D&SS"
  • optix-jira-search-simplified - initial search simplified for readability
  • optix-jira-search-yesterday - includes only tickets that have been opened or closed in the last 24 hours

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment