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 to display Initiatives that are linked with Epics that have additional criteria

Gregory Kremer_mx3rfi

Hi all,

Could someone please assist me with a query that would grab Initiatives that have Epics with Field1 = ABC and Field2 = XYZ ?

I would greatly appreciate prompt assistance. And yes, we have ScriptRunner installed.

Again, thank you in advance for your help.

As @Trudy P Claspill and I were trying to figure out what I am doing wrong and so far couldn't, is there someone from Adaptavist who would be able to help in resolving my problem? I'd greatly appreciate it.

Accepted answers

All comments

Trudy P Claspill

Hello @Gregory Kremer

There is not a native JQL capability to get what you want in a single filter.

Are you open to using third party apps to achieve your requirement?

Gregory Kremer_mx3rfi

Hi @Trudy Claspill

It's nice to hear from you again. As I mentioned above, we have ScriptRunner installed. I was hoping to use "issueFunction" of the ScriptRunner Enhanced Search.

If this is a 3d party you are referring to, then yes, I am OK using it.

I've written such a query, but it doesn't see to work correctly:

issueFunction in parentsOf("issuetype = Epic and "Planned Quarter" = 2023Q3 and "Planning Commitment" = Yes")

That's where I need some help.

Trudy P Claspill

Oh, sorry, I missed that you said you have Scriptrunner.

What type of field is "Planned Quarter"?

If you try to retrieve jus the Epics (without the parentsOf function), do you get results?

issuetype = Epic and "Planned Quarter" = 2023Q3 and "Planning Commitment" = Yes

Gregory Kremer_mx3rfi

@Trudy P Claspill yes, I get 8 records. Here is how my "regular" query looks like:

issuetype = Epic and "Planned Quarter[Dropdown]" = 2023Q3 and "Planning Commitment[Checkboxes]" = Yes and "Parent Link" is not empty

mauricio.groth

Hi @Gregory Kremer

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all Initiatives that have Epics with Field1 = ABC and Field2 = XYZ:

issue in parentsOfIssuesInQuery("type=Epic and Field1 = ABC and Field2 = XYZ")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Maurício

Gregory Kremer_mx3rfi

@mauricio.groth Thank you for trying to help. Unfortunately this doesn't fo==wrok for me:

iScreen Shoter - Google Chrome - 230515151126.jpg

Please let me know what am I doing wrong. I'd appreciate it.

Trudy P Claspill

@Gregory Kremer

You would need to use the JQL Search Extensions for Jira app that @mauricio.groth mentioned. Their solution does not work with ScriptRunner.

mauricio.groth

Hi @Gregory Kremer

As per your screenshot, I believe you have tried to run the query in the Jira’s advanced JQL search. In order to use the JQL Search Extension, it is necessary to download it from the marketplace first, and then access it via “Apps”.

To run the query inside our app, please follow these steps:

Access Apps
Click on JQL Search Extensions
Run the query here

To use our functions in Jira’s JQL, you need to save the query as a filter inside our app and then use it in the Advanced Issue search.

Best Regards,
Maurício Groth

Kate Kabir

Hi @GRE

Allow me to chip in on this matter.

In regard to this, ScriptRunner Enhanced Search does not provide the same portfolioChildrenOf() and portfolioParentOf() JQL functions that the server version provides in order out of the box in order to search for Portfolio issues which are now called Advanced Roadmaps and their hierarchy inside of Jira Cloud as the API to provide this function does not exist in the Jira Cloud as it does in Jira Server.

In addition, I will give you a documentation page where you will be able to compare the functionalities in Server vs Cloud.

Feature Request

We would like to invite you to upvote the Nolt raised for the portfolioParentOf() JQL function so that our Product Manager will review this.

https://scriptrunner-for-jira-cloud.nolt.io/47

I hope this helps.

Kind Regards

Kate

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud