JQL Queries for Optix Repair

optix-jira-search-closed.sql

(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

optix-jira-search-modified.sql

(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

optix-jira-search-simplified.sql

Bucket = SimplexRepair
  AND (Project = EIQV_COARELEASEMGMT OR Project = KFTV_COFEEREPAIR)
  AND Type = Bug
  AND Summary ~ "Optix Repair"
  AND Status != Closed
ORDER BY Created DESC

optix-jira-search.sql

(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

optix-search-yesterday.sql

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

• 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