Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-34168

Add functionality to JQL to search for inactive users

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      I would like to be able to search for inactive users. An example would be
      assignee IS INACTIVE
      for being able to find issues assigned to users who left the company (and therefore might never be resolved). I tried this in 5.2.11 but didn't succeed. I also didn't find documentation about such a feature.

            [JRASERVER-34168] Add functionality to JQL to search for inactive users

            Deleted Account (Inactive) added a comment - - edited

             FREE app called JQL Booster Pack  very nice! 

            reporter in componentLeads()  also working

            Deleted Account (Inactive) added a comment - - edited   FREE  app called  JQL Booster Pack   very nice!   reporter in componentLeads()  also working

            Jack Nolddor [Sweet Bananas] added a comment - - edited

            Hi everybody,
            If you are using Jira Server you can install the FREE app called JQL Booster Pack throught Atlassian Marketplace and use the requested functionality.

            After install this app, you should be able to create a query using inactiveUsers() function, that will allow you to find issues reported/assigned to inactive users.

            This is the complete information of this JQL function:

            Description:

            Perform searches based on inactive users that belong to the provided group.
            If any group is provided, it will return all users set as inactive in the system.

             

            Syntax inactiveUsers()
            inactiveUsers(group, ...)
            Available since v1.0.0-RELEASE
            Supported fields Assignee, Reporter, Voter, Watcher, custom fields of type User
            Supported operators IN , NOT IN
            Unsupported operators = , != , ~ , !~ , > , >= , < , <=
            IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

            Examples:

            • Find issues that have been created by any inactive user in 'EMEA' or 'LATAM' projects:

            creator IN inactiveUsers() AND project IN ("EMEA", "LATAM")

            • Find issues that are assigned to inactive users of group 'HelpDesk L1':

            assignee IN inactiveUsers("HelpDesk L1")

             

            Kinds regards.

            Jack Nolddor [Sweet Bananas] added a comment - - edited Hi everybody, If you are using Jira Server you can install the FREE app called JQL Booster Pack throught Atlassian Marketplace and use the requested functionality. After install this app, you should be able to create a query using inactiveUsers() function, that will allow you to find issues reported/assigned to inactive users. This is the complete information of this JQL function: Description: Perform searches based on inactive users that belong to the provided group. If any group is provided, it will return all users set as inactive in the system.   Syntax inactiveUsers() inactiveUsers(group, ...) Available since v1.0.0-RELEASE Supported fields Assignee, Reporter, Voter, Watcher, custom fields of type User Supported operators IN , NOT IN Unsupported operators = , != , ~ , !~ , > , >= , < , <= IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED Examples: • Find issues that have been created by any inactive user in 'EMEA' or 'LATAM' projects: creator IN inactiveUsers() AND project IN ("EMEA", "LATAM") • Find issues that are assigned to inactive users of group 'HelpDesk L1': assignee IN inactiveUsers("HelpDesk L1")   Kinds regards.

            Aaron Kotranza added a comment -

            How is this closed? inactiveUsers() is an invalid function. Atlassian is terrible, this is why my leadership keeps trying to move us to VersionOne. Atlassian's feature set is trash and they clearly don't care about customers.

            Aaron Kotranza added a comment - How is this closed? inactiveUsers() is an invalid function. Atlassian is terrible, this is why my leadership keeps trying to move us to VersionOne. Atlassian's feature set is trash and they clearly don't care about customers.

            Raul MrAddon added a comment -

            This summer I will try to create the plugin for Cloud & Server ^^

            Raul MrAddon added a comment - This summer I will try to create the plugin for Cloud & Server ^^

            Stephen Poyser added a comment -

            +1 cloud solution for this.

            Stephen Poyser added a comment - +1 cloud solution for this.

            Ramakrishna Anumalla added a comment -

            Even I am also looking for same issue, when will we get this feature in jql search function.

            Ramakrishna Anumalla added a comment - Even I am also looking for same issue, when will we get this feature in jql search function.

            Gary Bates added a comment -

            +1 for this. It makes me laugh that Atlassian say "there's a plug-in available for this" - yet JQL tricks is not available on Cloud anyway. So what are Cloud users supposed to do?

            Gary Bates added a comment - +1 for this. It makes me laugh that Atlassian say "there's a plug-in available for this" - yet JQL tricks is not available on Cloud anyway. So what are Cloud users supposed to do?

            Raul Pelaez added a comment - - edited

            You can use my JQL custom functions:
            https://jirasupport.wordpress.com/2015/12/18/custom-jql-function-hasinactivereporter-and-hasinactiveassignee-compatible-with-jira-7/

            Raul Pelaez added a comment - - edited You can use my JQL custom functions: https://jirasupport.wordpress.com/2015/12/18/custom-jql-function-hasinactivereporter-and-hasinactiveassignee-compatible-with-jira-7/

            CoreyM added a comment -

            Has there been any additional thought to reopening this issue? Or, has a new issue been created to address this functionality?

            CoreyM added a comment - Has there been any additional thought to reopening this issue? Or, has a new issue been created to address this functionality?

            durova added a comment -

            Please, make this issue as soon as possible, without plugins, on basic functional!

            durova added a comment - Please, make this issue as soon as possible, without plugins, on basic functional!

              Unassigned Unassigned
              a9f35328df11 Jens Kretzschmar
              Votes:
              0 Vote for this issue
              Watchers:
              39 Start watching this issue

                Created:
                Updated:
                Resolved: