in JIRA JQL is there a way to filter somehow if the user was active in the last 30 days ?

[Eran Roiter]

Hey all! 😊

I want to query all issues that are in the current sprint, and check whether the users assigned to these issues have been inactive in the last 5 days (for example).

Is it possible to achieve this with JQL?
Basically, what I want is a list of issues in the current sprint where the assignee hasn't been active (logged in) during the last 5 days.

Thanks a lot, and have a great day! 🙏

[Serhii Kibitkin_SAASJet_]

Hi, @Eran Roiter 

The question is, what is "user activity"?

You want to see a user who has not been active for 5 days.

I agree with @Brita Moorus.

In my opinion, it is more correct to control the user's activity in working with task fields (Status, Assignee, Priority, or another field that is critical to you as an indicator of user activity).

Logging in and out of the system does not mean that the user was working on the task.

I control the work with the help of a paid application that my team made - Issue History for Jira.

[Evgenii]

Hi, @Eran Roiter 

This isn't possible with native Jira Cloud functionality. There are no built-in JQL functions that allow you to filter issues by inactive users. You might be able to achieve this using a third-party add-on - if one offers such a feature.

On Jira Server or Data Center instances, I know how to implement something like this using a custom ScriptRunner JQL function. However, the Cloud version of the ScriptRunner plugin doesn’t support this kind of customization.

Best regards,
Evgeniy

[Brita Moorus]

Hey! 👋😊 

Unfortunately you can't do this directly with JQL because JQL can search issues based on issue fields (status, sprint, assignee, updated, etc.), but it cannot access user activity data like "last login" or "last activity".