Advance JQL for Status change does not work for BY user

[ayesha]

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.

[Sam Bartolome · Accepted solution]

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/

[ayesha]

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"))

[Fabio Racobaldo _Herzum_]

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

[ayesha]

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.