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

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

Eran Roiter_tdmgcu

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! 🙏

Accepted answers

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

All comments

Brita Moorus

Hey! 👋😊

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

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.

Issue-History-screens-30days activity.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql

user

query

activity