how to write a jql to show from list of users where same user not having multiple statues

Question

I have a ticketing jira project to track user given access or removed. How to write a jql to generate report to get the list of SAME users given access but not removed, means they are active in the system. Lets say, ticket #001 is raised to user A given access and ticket #002 raised to remove access to same user A, then report should not bring any record. I am struggling to get a such report, any quick help is appreciated.

Jack Brickey · Answer

so, with JQL you can't achieve exactly what you're looking for without somehow identifying the termination action on the granted issue. Let me explain by way of potential solution.

* create a custom field, let's call it current-access with values of granted and  rescinded
* the default value applied to the initial issue which grants access would be granted
* If/when a termination issue is completed it would Change the  current-access to rescinded

with the above, you could then create a JQL to find issues where the initial action includes, or does not have rescinded statuses. Does this make sense?

Another possible solution would be to simply not have two separate issues. You could simply have a workflow that looks something like below.

TO DO > IN PROGRESS > GRANTED > TERMINATED

With the above workflow you leave the issue in GRANTED until such time you rescind.

Prashant Mishra_x3ugkf · Answer

Yes @Jack Brickey, we have fields called (1) "Status" having values (Access Grated, Access Terminated), (2) "Assignee" having values (employee names) and (3) "System Name" having values (multiple projects where they need access/remove). Example:

Status                         Assignee      System Name

Access Granted          User1           Project1

Access Terminated     User1           Project1

Access Granted          User2           Project2

....

The report/jql should show only one entry

Jack Brickey · Answer

Hi @Prashant Mishra , do you some how distinguish between a "give access" and "remove access" issue, e.g. different issue type, custom field, etc.? Moreover, is there a field used to identify the user?