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; } } }

Advanced Searching

Sven Erdtmann

Hi everybody!

Our company is using JIRA Server (on premise; 7.13) and we have a tricky request from a stakeholder.

We track risks in our projects and have a dedicated issuetype for it. As all devisions are using the JIRA as project management tool, we have also a project head in each JIRA project, where the devision is selected in a drop down list.

The request from a stakeholder is, that he want's to have a list of all risks, which belong to his devision.

I tried many things, but couldn't find a solution on that.

This query from my point of view needs a "where" statement, which is not available.

Show all "issuetype = risk" where "issuetype = projecthead AND division = abc"

Any ideas, how to accomplish this?

Kind regards

Sven

Accepted answers

All comments

Cody Stevens

Hey @Sven Erdtmann

If I am understanding correctly, risks are tracked in your system via their own issue type and the divisions are selected via their own custom field dropdown.

If thats correct, then all you need to do is the below query.

issuetype=risk AND division = "division 1"

I didnt include the project head because from what you said, it doesnt seem like you need to filter off of it. If you do, I am assuming its a user picker? If it is, you would just add

projecthead="user"

Sven Erdtmann

...

Sven Erdtmann

Hey @Cody Stevens

thank you for your reply.

Seems not to work, since the division field is only available in the issuetype "projecthead" not in the risk issuetype.

Filtering on user, would only be useful, as sometimes users are lent to other divisons for a project lead.

P.S.: Sorry for miss-using the reply...

Sven Erdtmann

From my point of view we need to identify all projects where in the projecthead his division is selected and return all risks from these projects.

Mikael Sandberg

@Sven Erdtmann, if you use the project lead in your project settings to set it to your project head you could use project in projectsLeadByUser() in your query to get all the projects, like this:

project in projectsLeadByUser() AND issuetype = risk AND division = abc

Sven Erdtmann

@Mikael Sandberg

ok, I messed the understanding.

We have a issuetype which is named projecthead. It is not a person. In this head there are some project general informations, like the division. From my view it is not possible to use name fields in any case.

Mikael Sandberg

Okay, in that case I would say it would be hard to get that data out. Jira natively do not support nested queries, but I don't think even with an app that support it you could get it. Maybe take a look at scriptrunner since it has some powerful JQL functions, or maybe Power Scripts.

Sven Erdtmann

@Mikael Sandberg

We have Scriptrunner, but I couldn't identify a useful jql function.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

jql