Filtering tickets for a Project

[Timi Falusi]

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.

[John Funk]

Hi Timi,

You should be able to use some JQL like this: 

Project = RD and summary ~ "[Validation]" AND issueLinkType = "blocks"

[Trudy Claspill]

Hello @Timi Falusi 

In the example you provided it is the parent item that is blocking the USRIM item. The RD item that includes "VALIDATION" in the summary is a child of the item that is blocking USRIM.

Do you create a link directly between the child "VALIDATION" item and the blocked issue?

If you do not, then it appears what you need is

1. Get the list of RD issues with "VALIDATION" in their Summaries
2. Get the parent issues of #1
3. Get the issues that are Blocked by #2 and are in the USRIM project

Is that correct? If so:

1. Develop the filter for #1 first. It would be something like:

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

2. For #2 you would add that into a ScriptRunner filter that searches for the parent issues

project=RD and issueFunction in epicsOf("project=RD and summary~"\"[VALIDATION]\""")

You would need to save that filter.

3. For number three you incorporate #2 into a ScriptRunner filter that search for the issues blocked by the results of #2. You would incorporate that by using the saved filter's name.

 project=USRIM and issueFunction in linkedIssuesOf("filter="Epics of VALIDATION issues in RD"", "blocks")

The Scriptrunner filters would need to be created/saved in the Enhanced Search UI accessed through the Apps list.

[Timi Falusi]

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?

[Trudy Claspill]

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.