nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query for child issues where something in the 'Details' portion of the issue doesn't match parent

Sofie Palacios

Exactly like the title mentions... I am trying to query for when a child issue doesn't match certain parts of their parent from the 'Details' section of the issue.

I do have access to scriptrunner and am totally at a loss.

Any help would be very appreciated!

Accepted answers

Ram Kumar Aravindakshan _Adaptavist_

Hi @Sofie Palacios

Please clarify, what field type are you using for the Details? Is it a Multi-Line text field?

And what type of comparison are you trying to make between the parent and child field? Is it for a particular word or multiple lines of text?

I am looking forward to your feedback and clarification.

Thank you and Kind regards,

Ram

All comments

Ram Kumar Aravindakshan _Adaptavist_

Hi @Sofie Palacios

Please clarify, what field type are you using for the Details? Is it a Multi-Line text field?

And what type of comparison are you trying to make between the parent and child field? Is it for a particular word or multiple lines of text?

I am looking forward to your feedback and clarification.

Thank you and Kind regards,

Ram

Sofie Palacios

Howdy Ram!

It is drop down field. I'm not sure if it comes standard for Jira, but as an example...

What I am trying to see is if the drop down field for the parent is set to 'Cat', I want to see all child issues where their drop down fields don't match their parent (i.e. set to 'Dog' instead).

Ram Kumar Aravindakshan _Adaptavist_

Hi @Sofie Palacios

So for your requirement, you can easily do a query using the ScriptRunner console.

Below is a sample working code for your reference:-

import com.adaptavist.hapi.jira.issues.Issues

def issue = Issues.getByKey('MOCK-1')
def parentListValue = issue.getCustomFieldValue('Sample List')

def differentOptions = [:]

issue.subTaskObjects.each { subTask ->
    def subTaksListValue = subTask.getCustomFieldValue('Sample List')

    if (subTaksListValue != parentListValue) {
         differentOptions << ["${subTask.key}": "${subTask.getCustomFieldValue('Sample List')}"]
    }
}

differentOptions

Please note that the sample working code above is not 100% exact to your environment. Hence, you must make the required modifications.

Below is a screenshot of the sample output:-

For this use case, I have created a sample Task Issue with a Couple of Sub-Tasks.

Below are the screenshots for your reference:-

1. For the Task Issue the value Option1 has been selected from the Sample List field as shown in the screenshot below:-

2. Below are the screenshots of the Sub-Tasks:-

In the screenshots above all the Sub-tasks except for Sub-taks MOCK-4 and MOCK-7 have the same value in the single select list as the parent issue.

Hence, only MOCK-4 and MOCK-7 are displayed in the result as expected.

I hope this helps to solve your question. :-)

I am looking forward to your feedback.

Thank you and Kind regards,
Ram

Ram Kumar Aravindakshan _Adaptavist_

Hi @Sofie Palacios

Has your question been answered? If yes, please accept the answer.

Thank you and Kind regards,

Ram

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

jira-data-center

data-center