Jira query: issueFunction in linkedIssuesOfAll("filter = A", "is child of") isn't working

[Swati Mathapati]

The below query does not return anything ,Kindly anyone help me to find the solution

issueFunction in linkedIssuesOfAll("filter = PLANC_PI_BOARD_SWSAR", "is parent of") AND project = "Power, Load and Aerodynamic Noise Control"

[Trudy Claspill]

Hello @Swati Mathapati 

Using "filter = PLANC_PI_BOARD_SWAR" and "is parent of" indicates you are trying to find all issues returned by the filter PLANC_PI_BOARD_SWAR that have a link "is parent of" to another issue.

This is further constrained in that the issue returned must also be in the project "Power, Load and Aerodynamic Noise Control"

What are the details of the filter PLANC_PI_BOARD_SWAR?

Can you provide a screen image of an issue that you believe meets the conditions of your JQL?

linkedIssuesOfAll is a function provided by the Adaptavist ScriptRunner app. Can you tell us which version of that app you have? You may need to consult with your Jira Administrator to get that information. Additionally can you tell us the version of Jira that you have?

[Swati Mathapati]

HI Claspill ,

Thank you for the reply!

The version of the app we are using is Version: 6.58.0

The screenshot of the filter is attached below

[Trudy Claspill]

That image does not tell me the details of the criteria in the filter named "PLANC_PI_BOARD_SWSAR". It only shows me the results of the filter.

You need to go to the list of all filters and find the one named "PLANC_PI_BOARD_SWSAR" and show us the criteria it contains.

Also, what version of Jira are you using?

[Swati Mathapati]

Jira version is v8.20.10

[Trudy Claspill]

I am not able to offer additional advice without having the details of the filter named PLANC_PI_BOARD_SWSAR.

I suspect that the reason you are not seeing any results is that filter does not include issues that are in the project "Power, Load and Aerodynamic Noise Control", and that is a criteria in the query where you are using the PLANC_PI_BOARD_SWSAR filter

[Swati Mathapati]

I am checking with the user for an example that passes the entire query. I will get back to you. 

Thank you so much!

Regards,

Swati

[Swati Mathapati]

Please find the reply from an user

[Trudy Claspill]

Can you show us an image of SWSAR-7357 showing the part of the screen that shows the linked issues and including the PLANC-4008 issue?

[Swati Mathapati]

Please find the image below

[Trudy Claspill]

First, I am going to try to describe what the filter actually does. Let me know if this is the result you actually want.

1. Retrieve a set of issues based on the filter PLANC_PI_BOARD_SWSAR

2. For each of the issues in 1, retrieve the parent Epic.

3. For each Epic retrieved in 2, retrieve all the child issues.

4. From the child issues retrieved in 3, retrieve the subset of issues that are in the project "Power, Load and Aerodynamic Noise Control"

Does that match what you intended to retrieve?

I don't have access to a Jira Server instance, and these ScriptRunner functions are not available for Jira Cloud, so I cannot try these out for myself.

Using just this much of the query:

issueFunction in linkedIssuesOfAll("issue = PLANC-4008", "is parent of")

...do you get a list of all the children of SWSAR-7375?

[Swati Mathapati]

We have tested with some other projects as well and understood that its a problem with Issue linking ("is parent of", "is child of").

Could you please help us to know what we need to use for parent-child relationship?

[Trudy Claspill]

You didn't answer my question about whether or not I correctly described the results you want from this query. I'm going to proceed assuming that I was correct.

I don't have access to a Jira Server instance, and the ScriptRunner functionality is not the same on Jira Cloud, so I can't test out the solution I'm going to propose.

1. Retrieve a set of issues based on the filter PLANC_PI_BOARD_SWSAR

-- you already have that part done.

2. For each of the issues in 1, retrieve the parent Epic.

issuefunction in epicsOf("filter = PLANC_PI_BOARD_SWSAR")

This should return all the parent Epics of the issues returned by the filter PLANC_PI_BOARD_SWAR. Save that as another saved filter. Let us call that "filter2" for the moment.

3. For each Epic retrieved in 2, retrieve all the child issues.

issuefunction in issuesInEpics("filter = filter2")

This should retrieve all the children issues of the Epics you got in step 2. 

4. From the child issues retrieved in 3, retrieve the subset of issues that are in the project "Power, Load and Aerodynamic Noise Control"

issuefunction in issuesInEpics("filter = filter2") and project = "Power, Load and Aerodynamic Noise Control"

That should satisfy step 4.

[Swati Mathapati]

Sorry for not replying to your question as I am checking with the user who raised this request.