List of users without issues assigned (Idle users)

[Emil Naghiyev]

I build a Script which shows me a list of users from specific group (Developers) who are not assigned to specific issue types (Subtasks for example) at the moment. In this way, I can observe which users are idle, do not have assigned tasks on them. 

I run this script in Scriptrunner console to find these users. Now I need to somehow show this output in Dashboards, so Scrum team can also observe these results. 

Is it possible to build a scheduler that every morning will run script, write the result to a specific place and show in the Dashboard? 

[John Funk]

Hi Emil,

Were you not able to just create a Filter using JQL? Then you could add a gadget to a dashboard like a Filter Results gadget linked to the Filter. No need to run it every night, it would always be real time. 

What does your script look like? 

[Emil Naghiyev]

But it is not possible to get list of the users without issues via JQL, JQLs are only used to filter issues, not the users. 

[Emil Naghiyev]

I don't let me post the full script here

[John Funk]

Can you save a Filter with the ScriptRunner script in it? 

[Kristian Walker _Adaptavist_]

Is this being done on Jira DC or Jira Cloud? 

If Jira DC you can use the JQL functions in a JQL query in the main search page, if it is Jira Cloud you need to create the filter on the enhanced search page and then call the shared enhanced search filter in a QL query on the main search page.

[Stefan Salzl]

@John Funk , @Kristian Walker _Adaptavist_ 

how would a filter gives users as result? what would be the JQL?

The requirement is about getting users that aren‘t assigned to any issues, hence are „free for work“.

Or did I get anything wrong here @Emil Naghiyev ?

Best
Stean