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

Create a list of issues where certain user have invested time on

Helder Martins

Hello. I have created a custom field that gets filled when a ticket is closed. Now, I want to know who has filled that particular custom field with certain value I am looking for BUT only if 4 different people have logged time in that particular ticket, if those 4 people have not logged time in that ticket then I am not interested.

I have tried something like this:

created >= startOfYear() AND "Forma de Resolución del Ticket" = "Resuelto directo por Consultor" AND status in (RESUELTO, CERRADO, CANCELADO) and worklogAuthor in (bmontes, sylvana, lsocorro, mlena)

However, this doesn't bring me any results and I know it's not correct.

Any ideas?

Accepted answers

All comments

Max Foerster - K15t

Hi Helder,

the operator "IN" works like parenthesis around multiple OR operators, so you're searching:

worklogAuthor = bmontes OR worklogAuthor = sylvana OR....

I guess you understand what I'm saying. What you need is an AND.

But what I learned from trying is that searching for:

worklogAuthor = bmontes AND worklogAuthor = sylvana AND....

It doesn't work at all. Which is sad. So you're right that your expression wasn't correct but what I've figured to be a possible solution doesn't work. Let me think about it a bit more..

Best, Max

Helder Martins

Max, first of all thanks for your interest.

The expression "IN" works indeed instead of using the OR with each of the persons, which is the desired, meaning that I would like to get the list where the workAuthor is bmontes OR workAuthor is sylvana OR...... If I use the AND it wouldn't ever work as expected because I would be saying that I want to know an issue where ALL these 4 peoples worked on, I just want to cross 1 of these person with an specific value of my "Forma de resolución del ticket" custom field.

In any case, I even tested using only 1 unique user like this:

"Forma de Resolución del Ticket" = "Resuelto directo por Consultor" AND worklogAuthor = bmontes

And I know there are tickets which have those 2 conditions indeed.

So any ideas?

Max Foerster - K15t

Oh sorry, so I just got your initial post wrong then and you are totally fine with the IN. That's something!

What kind of custom field is "Forma de Resolución del Ticket"? Does your initial query work without that specific bit?

Helder Martins

The "Forma de Resolución del Ticket" is just a dropdown with 4 different possible values and has a default value which is actually "Resuelto directo por Consultor".

If I run the following:

"Forma de Resolución del Ticket" = "Resuelto directo por Consultor"

I actually get the list of tickets that have that value.

Welcome!

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

Quick Links

Find more posts tagged with

custom-field

jira

cloud

jira-cloud

filter

tempo

worklog