JQL Query for sub-tasks changed from "in progress" to "done" within 1 minute

Sarah Tanzillo October 7, 2019

JQL Query for search not working, still showing sub-tasks that were changed after 1 minute.

I would like to use this search to create a dashboard.

project in (REPORT, TRAINING, COMMERCE, CRM2, CONFIG) AND issuetype in (" Commerce Sub-Task - Run Migration (Test)", "CRM Sub-Task - Assign SSR", "CRM Sub-Task - Attach SSR", "CRM Sub-Task - Attach Test Script", "CRM Sub-Task - Communication with Training Team", "CRM Sub-Task - Create & Submit CAB Request", "CRM Sub-Task - Create Test Script", "CRM Sub-Task - Create/Attach Spec Sheet", "CRM Sub-Task - Identify Changes Needed", "CRM Sub-Task - Identify Impact", "CRM Sub-Task - Identify New Fields for Translations", "CRM Sub-Task - Monitor Issues Throughout Release Weekend", "CRM Sub-Task - Release with Development Team", "CRM Sub-Task - Request Translations", "CRM Sub-Task - Review & Approve SSR", "CRM Sub-Task - UAT Sign Off", "CRM Sub-Task - Unit Testing Sign Off", "CRM Sub-Task - Validate Production", "Commerce Sub-Task - Attach Approvals to SSR/Epic", "Commerce Sub-Task - Attach Spec Sheet", "Commerce Sub-Task - Communications", "Commerce Sub-Task - Create Test Script", "Commerce Sub-Task - Define Solution", "Commerce Sub-Task - Diagnosticate CRM Change", "Commerce Sub-Task - Diagnosticate Interface Changes", "Commerce Sub-Task - Diagnosticate NOMS Change", "Commerce Sub-Task - ID Business Requirement", "Commerce Sub-Task - ID Stakeholders", "Commerce Sub-Task - Manual Update Not Migrated", "Commerce Sub-Task - Migrate Package (Prod)", "Commerce Sub-Task - Notify Users to Test", "Commerce Sub-Task - Post Mortem", "Commerce Sub-Task - Request Translations", "Commerce Sub-Task - Review & Approve SSR", "Commerce Sub-Task - Run Bellwether Quotes (Dev)", "Commerce Sub-Task - Run Bellwether Quotes (Test)", "Commerce Sub-Task - Support Testing Effort", "Commerce Sub-Task - Testing in Dev", "Commerce Sub-Task - Training Material", "Commerce Sub-Task - UAT Sign Off", "Commerce Sub-Task - Update/Create Walk Me", "Commerce Sub-Task - Validate Production", "Commerce Sub-Task - Validate Test Migration", "Config Sub-Task - Load Parts/Translations into NOMS", "Config Sub-Task - Load Parts/Translations into Test NOMS", "Configuration Sub-Task - Add Punch-In to Eval", "Configuration Sub-Task - Add Punch-In to Prod", "Configuration Sub-Task - Attribute/Value Translations", "Configuration Sub-Task - Build Parts String Rule", "Configuration Sub-Task - Bypass Reslot", "Configuration Sub-Task - Constraint Rule Translations", "Configuration Sub-Task - Diesel Tier, Constraint Charger", "Configuration Sub-Task - Load Parts/Translations into NOVO", "Configuration Sub-Task - Migrate to Eval", "Configuration Sub-Task - Migrate to Prod", "Configuration Sub-Task - Product Hierarchy", "Configuration Sub-Task - Rec Items", "Configuration Sub-Task - Request New Parts", "Configuration Sub-Task - Request Translations", "Configuration Sub-Task - SPED Constraint Rules", "Configuration Sub-Task - Series Access Override", "Configuration Sub-Task - Series Code Map", "Configuration Sub-Task - Series Phaseout", "Configuration Sub-Task - Set Constraint Charger", "Configuration Sub-Task - Setup Option Code Mapping", "Configuration Sub-Task - Setup Series and Model Data in NOMS", "Configuration Sub-Task - Special Lift Heights", "Configuration Sub-Task - Tab/Group Translations", "Configuration Sub-Task - Update Description", "Configuration Sub-Task - Update Translations", "Reporting Sub-Task - Assign SSR", "Reporting Sub-Task - Attach SSR to Epic", "Reporting Sub-Task - Attach Test Script to Epic", "Reporting Sub-Task - CM Ticket to Create Table", "Reporting Sub-Task - CM Ticket to Update Table", "Reporting Sub-Task - Communication with Training Team", "Reporting Sub-Task - Create & Submit CAB Request", "Reporting Sub-Task - Create Joins", "Reporting Sub-Task - Create Test Script", "Reporting Sub-Task - Create/Attach Spec Sheet to Epic", "Reporting Sub-Task - Define Audience", "Reporting Sub-Task - Define Security Roles", "Reporting Sub-Task - Demo to Tester", "Reporting Sub-Task - Final Demo", "Reporting Sub-Task - Gateway/Schedule Refresh", "Reporting Sub-Task - Identify Changes to Filters", "Reporting Sub-Task - Identify Changes to Report", "Reporting Sub-Task - Identify Field Changes", "Reporting Sub-Task - Identify New Fields for Translations", "Reporting Sub-Task - Identify Report Fields", "Reporting Sub-Task - Identify Report Filters w/ POC", "Reporting Sub-Task - Identify Visualization", "Reporting Sub-Task - Identify Visualization Changes", "Reporting Sub-Task - Identify/Create SQL Query", "Reporting Sub-Task - Include Disclaimer for Test", "Reporting Sub-Task - Monitor for Issues", "Reporting Sub-Task - Prepare Communication", "Reporting Sub-Task - Prepare Details Page", "Reporting Sub-Task - Prepare Visualizations", "Reporting Sub-Task - Publish to Test Workspace", "Reporting Sub-Task - Publish to Woskpace & Update App", "Reporting Sub-Task - Pull in Table(s)", "Reporting Sub-Task - Refresh Tables", "Reporting Sub-Task - Release with Development Team", "Reporting Sub-Task - Remove Disclaimer", "Reporting Sub-Task - Remove from Testing Workspace/App", "Reporting Sub-Task - Request Translations", "Reporting Sub-Task - Research/Identify Field & Table Names", "Reporting Sub-Task - Review & Approve SSR", "Reporting Sub-Task - Send Communication ", "Reporting Sub-Task - UAT Sign Off", "Reporting Sub-Task - Unit Testing Sign Off", "Reporting Sub-Task - Update Details Page", "Reporting Sub-Task - Update Visualizations", "Reporting Sub-Task - Validate Production", Sub-task) and status changed from "in progress" to "done" BEFORE -1mCapture.PNG

1 answer

0 votes
Gikku
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 7, 2019

Hi @Sarah Tanzillo 

Edited... Please use as below. Change 30 minute interval as per your convenience.

type in subTaskIssueTypes() and status changed from 'In Progress' to 'Done' after '-30m'

Sarah Tanzillo October 7, 2019

1 minute, 5 minutes, 10 minutes, 30 minutes. nothing works.
Below is a perfect example of a sub-task I'd like to show in this search, it was closed within 5 minutes.Capture3.PNGInkedCapture2_LI.jpg

Suggest an answer

Log in or Sign up to answer