It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

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'

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
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

308 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you