Queue for Filtering by Request Participants

[Cecilia Hedberg]

I've created several queues that filter on individual users, so everyone can see just their own issues, based on how they are added to the issue, e.g. if they are the Assignee, a Watcher or one of several users in the 'Request Participants' field. This all worked fine until recently.

This week I noticed that the 'Request Participants' queue no longer worked. It is filtered using this as part of the JQL:
AND "Request participants" in (currentUser())

The currentUser part no longer works and there doesn't seem to be any equivalent. I can't even get it to work by selecting a single user from the drop down list that appears when I start typing after "in".

A similar filter to show issues which include an inactive user works:
AND "Request participants" in (inactiveUsers())

I have tried slightly different versions of currentUser, e.g. currentUsers and putting the brackets in different ways, but I don't get any results. Some variations give an error message, but the current filter ("in (currentUser())") doesn't show an error, just no results.

[John Funk · Accepted solution]

Hi Cecilia,

I tried this: "Request participants" in (currentUser())

and it worked perfectly for me. So maybe there is something wrong with the rest of the JQL? 

[Cecilia Hedberg]

I've been reviewing it this morning and found that it's only an issue when I combine that part of the filter with the status of the issue. So another queue on "Request participants", which shows issues for all statuses, works, the full JQL for that queue is:

issuetype in (AnalystQueryInbox, "Email request") AND "Request participants" in (currentUser()) ORDER BY updated DESC

The queue which doesn't work has this full JQL:

issuetype in (AnalystQueryInbox, "Email request") AND status in ("India Team", Open, Reopened, "Rota Analyst", "Specialist Analyst") AND "Request participants" in (currentUser()) ORDER BY updated DESC

The statuses selected in the 2nd non-working queue are all different open statuses.

[John Funk]

So the query works great except for the status part? Try doing just status in (Open) and see if that works. 

If so, then add one at a time until it quits working. 

[Cecilia Hedberg]

I've played around with it a little and got it to work with 1 status. So I will test it a bit more!

[Cecilia Hedberg]

Actually, I think it does work after all, we have automation related to "Request participant" and I think it's just that I've not been added back as a participant on many queries.

[John Funk]

Great! Glad it is working. Sometimes if you paste it in, it doesn't work well. But if you type it in from scratch it will work. Not sure if that applies here, but glad it works.