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

Advance JQL for Status change does not work for BY user

ayesha_ca34nl

I am usign following JQL which works fine

project = projName AND status changed from "BU sign off" to Done during (2022-02-21, 2022-05-01) AND fixVersion = "R1" ORDER BY created DESC

But when I try to find out change by user

project = projName AND status changed BY "user" FROM "BU sign off" to Done during (2022-02-21, 2022-05-01) AND fixVersion = "R1 2022" ORDER BY created DESC

It gives below error. Any idea what is going wrong here. I can confirm the "user" exists in the system

The user 'user' does not exist and cannot be used in the 'by' predicate.

Accepted answers

Sam Bartolome

Hi @ayesha ,

The username in Cloud have changed in respect to Server or DC, so the JQL is also changed, especially the username part.

This link should help you digging.

But basically you should changed the "user" by the correct username in Cloud. You can check the user id by navigating to Admin>User management>Users and hoover on the user you would like to add on the JQL.

As the user id is long and convoluted you can open a new tab and copy the last set of numbers/letters after .../users/

All comments

Fabio Racobaldo _Catworkx_

Hi @ayesha ,

you should use a valid username instead of "user". That clause allows you to retrieve all issue transitioned by a specific user in that time.

Hope this helps,

Fabio

Sam Bartolome

Hi @ayesha ,

The username in Cloud have changed in respect to Server or DC, so the JQL is also changed, especially the username part.

This link should help you digging.

As the user id is long and convoluted you can open a new tab and copy the last set of numbers/letters after .../users/

ayesha_ca34nl

For data policy reason I typed "user" in my question above. When I am actually putting JQL I am using actual user name from User management screen and it still fails.

ayesha_ca34nl

Thanks @Sam Bartolome ! That link helped But what if I want to add as user from some group? That group Id is nto working

Sam Bartolome

For users in some specific groups you can use:

status changed by (membersOf("jira-users"))

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