Community
Products
Jira
Questions
JQL to see activity for a period of time by a user

JQL to see activity for a period of time by a user

What does a JQL query look like that shows all of the activity by a particular user for a specific time?

I want check a user assigned in the past. Now, maybe this user be changed by other user on Jira.

Thanks,

Trâm

1 answer

1 accepted

1 vote

Answer accepted

Hi Tram,

you can search with a JQL like:

user WAS username DURING (‘2022-04-01’, ‘2022-04-31’)

or using the AFTER and BEFORE clause

user WAS username BEFORE ‘2022-04-31’

user WAS username AFTER ‘2022-04-01’

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @verraf , thank you for your help. I tried but it was not work. Could you help me with other JQL?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Nguyen Ngoc Tram _FHM_INS_

sorry my mistake, the query must be:

assignee WAS username DURING (‘2022-04-01’, ‘2022-04-31’)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @verraf , unlucky, I see my Jira have Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'WAS'. (line 1, character 29)

"WAS" maybe is not work.

Thanks,

Trâm

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Nguyen Ngoc Tram _FHM_INS_

can you post here your jql?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Nguyen Ngoc Tram _FHM_INS_ likes this

Hi @verraf , thank you. I tried again and luckily, "WAS" is worked. I tried with "AFTER" or "BEFORE", my jql was until OK. But I use "DURING", I have a error.

My JQL: assignee was E114120 DURING (‘2022-04-01’, ‘2022-04-31’)

Error:

Date value '‘2022-04-01’' for predicate 'during' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.
Date value '‘2022-04-31’' for predicate 'during' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.

Thank you,

Trâm

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I tried to fix but it until not work

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Nguyen Ngoc Tram _FHM_INS_
I think there is a typing error in the query: could you put the date back in the format 2022-04-01 and write the quotes yourself rather than copy and paste?