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

[Nguyen Ngoc Tram _FHM_INS_]

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

[verraf · Accepted solution]

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’

or

user WAS username AFTER ‘2022-04-01’

[Nguyen Ngoc Tram _FHM_INS_]

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

[verraf]

Hi @Nguyen Ngoc Tram _FHM_INS_  

sorry my mistake, the query must be:

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

[Nguyen Ngoc Tram _FHM_INS_]

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

[verraf]

Hi @Nguyen Ngoc Tram _FHM_INS_ 

can you post here your jql?

[Nguyen Ngoc Tram _FHM_INS_]

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 

[Nguyen Ngoc Tram _FHM_INS_]

I tried to fix but it until not work

[verraf]

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?

[Nguyen Ngoc Tram _FHM_INS_]

Thank you so much @verraf , I finished.

Thank for your help again :)

Trâm

[verraf]

Hi @Nguyen Ngoc Tram _FHM_INS_ 

I'm glad it works now.
If you like it, would you rate my answer?
Thank you!

[Nguyen Ngoc Tram _FHM_INS_]

Yes, I love it. I rated it for you :)

Thanks.