Skip to content

Instantly share code, notes, and snippets.

@jpelton-stroud
Last active June 24, 2022 16:59
Show Gist options
  • Save jpelton-stroud/4d4574a0453a12bfae69dd0c9be4a2e1 to your computer and use it in GitHub Desktop.
Save jpelton-stroud/4d4574a0453a12bfae69dd0c9be4a2e1 to your computer and use it in GitHub Desktop.
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