How to use jql to find currentUser() in user group?

[Sam Nadarajan]

Hello,

I need to configure a Service Desk queue to only pull issues that have been assigned to a user group that the logged in user is a part of. Currently, I have a custom field (Assigned To Group) that contains the user group that the issue is assigned to.

How can I accomplish this through JQL? If this isn't possible with standard functionality, what would I need to accomplish this?

Thanks!

[Sam Nadarajan · Accepted solution]

I was able to overcome this by using the Groups and Organizations in JQL add on. Thanks all for the dialog!

[Malka]

Perfect... just about what I was looking for... unfortunately not for Cloud. *sigh*

[Keith Rowe]

Jira Cloud - With Jira Service Desk

JQL to find the current user in the Request Participants field:

"Request participants" in (currentUser())

The "Request participants" is a custom locked field added by the Jira cloud.

Full example to pull waiting for support status, or work in progress:

project = JIRAKEY AND status in ("Waiting for support", "Work in progress") AND "Request participants" in (currentUser()) ORDER BY created DESC

[Dmitry Astapkovich _Colined_]

Let me thank you SOOOO MUCH! =) That works just perfect as a quick filter for the Collaborators custom field I've just added to our Board. A-W-E-S-O-M-E! 

[Cengiz Akyildiz]

Have you tried jql like,

assignee in membersOf("<jira group name>")

[Sam Nadarajan]

I need to check the currentUser not the assignee unfortunately

[Cengiz Akyildiz]

I haven't tried but you can have a calculated/scripted field for currentUser, then you can use above jql function. Well, I don't know, if you would go for this solution.

scripted_field in membersOf("<jira group name>"), you would need add-on for scripted field.

Another solution, you can have one queue for each bucket, so everyone can see how many tickets are there in each bucket. Well, as the number of groups grow, the solution might not be sustainable, but in some cases it works, if you don't use any add-on.

There's one more solution, you can use Queues for Jira Service Desk add-on, set up queues exactly in the same way as the second solution, by using queue restrictions, you can limit the user to see only the queue he is in. 

[Sam Nadarajan]

I'll look into the add on, thanks! I wish I could set up multiple queues but yes that wouldn't be scalable unfortunately.

[Sascha Stegmüller]

Helped for me! Thanks!

[David Harkins]

We now have this working with the use of ScriptRunner, as Groups and Organizations in JQL is being phased out for a Paid Version.

[Sandra Axelsdottir]

@Sam Nadarajan - Did you solve this? I need the same JQL 

[David Harkins]

@Sam Nadarajan I'm also in need of the same.

Have an 'Assignee Group' field - Single Group

Need to show issues for which the current user is a member of the Single Group selected in the 'Assignee Group' field.

The 'Request Participants' is not going to work for my use case here.

[Sam Nadarajan]

Hey! I used the Groups and Organizations for JQL add-on, however that's only available for Server/Data Center. Are you using cloud?

[David Harkins]

@Sam Nadarajan Thank you for confirming.

Yes I used the same add-on on a Data Center install.

[Jack Brickey]

If I understand I would try this

Assignee in membersof (xxxx) and assignee = currentuser()

[Sam Nadarajan]

I wish i could use the assignee but unfortunately tickets get assigned to a group first. This is kind of the holding tank for tickets before they're picked up by individuals.

[Jack Brickey]

How are you assigning to a group? I’m guessing you are using an email that maybe is a distribution list or something. Assigning issues to a group is rather flawed.

[Sam Nadarajan]

Yea I understand Atlassian's insistence on assigning issues to users only - scenario here is that different areas solve different types of problems which are triaged by the "call center" if you will. I set up user groups in Jira and a custom single pick user group field. Incoming tickets are assigned to different groups, and users in that group would assign it to themselves.

[Andreas Lärkfeldt]

Samuel - Any findings??? Need the same! +1

[Damian Ryan]

See comment by Keith Rowe above:

AND "Request participants" in (currentUser()) ORDER BY created DESC

Add that to your JQL string and it will show the current user (ie: you when you look) tickets of which they're a Requested Participant.