Filtering tickets for a Project

Question

Is it possible to write a JQL filter or Scriptrunner that finds all RD tickets where the summary contains '[VALIDATION]', then returns the USRIM tickets they are blocking?

As in the example there's a child work item for Validation, I would want to know that it blocks USRIM-442 with a filter.

Trudy P Claspill · Answer

Hello @Timi Falusi

Did you find a solution to this filtering problem, or implement one of the alternatives I suggested?

Trudy P Claspill · Answer

I have not found a method to make that search work to find only items where the Summary starts with the specified text.

This document talks more about how to do searches for text fields. It indicates that one should be able to place a wildcard character at the end, but that is still getting items where the text is not at the beginning.

https://support.atlassian.com/jira-software-cloud/docs/search-for-work-items-using-the-text-field/

You may want to find a different way to indicate that the child items are VALIDATION vs. Development, Deployment, or Spec, that would be more reliable for filtering. Perhaps you can talk to your admins about adding a custom single select list field with those same options as selectable values, and you could then filter for <your custom field>=Validation. You could use an Automation Rule to set the field based on checking if the Summary starts with X, Y, or Z. In an Automation Rule it is possible to use Smart Values to check if a text field starts with specific text.

Timi Falusi · Answer

Hey Trudy thanks for this.

This filter

project=RD and summary~"\"[VALIDATION]\""

gives all tickets with validation in the summary. I want to get only tickets that the summary starts with [VALIDATION]. Could you please help me with a filter for this?