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 -1m
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.