Merge user fields into one field to avoid OR filter

Sascha Werheid2

Hi,

We use different fields for users who have interests in an issue. The reporter, the assignee and a costume Multi User Picker field named "Stakeholders".

Now we build filter for all issues currentUser has an interest in.

To filter this we need JQL

(reporter = currentUser() OR Stakeholder = currentUser() OR assignee = currentUser())

But with the OR in our JQL query it is impossible for our customers to use the basic filters and they have no idea to extend our filter.

Now we want to merge (by a plugin, or jelly script?) the reporter, the assignee and the stakeholder into one hidden field, which we can use to filter without or.

Is this possible? has anyone tired something like that and has a hint for use how we get started?

Nic Brough -Adaptavist-

I've done something similar for a totally different reason.

As you say, you create a multi-user-picker field, and don't put it on any view screens (it still needs to have the right context for the project and not be hidden in the field context). You then find/write a listener that picks up changes on the fields and rebuilds that hidden field in the background.

Another option, probably a lot more neat, would be to create a derived or scripted field (again, mostly hidden). If you look at the Jira Toolkit plugin, you'll see that has a field for "participants" which is "commenters, reporter and assignee". That's easy to change to "people listed in other user picker fields". I believe you can do it with a scripted field as well, if you have the script-runner plugin.