Search not assigned issues for the same field

Question

I would like to search for issues not assigned to a user with the same custom field values as the ones already assigned to them.

The idea is x user has a number of tasks assigned to them for a number of Stores (this changes daily). I would like to be able to lookup if there are other open issues not assigned to them in the same Stores (store ID is a 6 digit figure).

Looking them up manually is not an option since it's multiple users and multiple stores per user. Also i don't have access to the database.

I tried messing about with IssueFieldMatch, but i am probably getting something wrong

Dimitris Dreamer · Answer

The Store ID changes regularly. I can search for unassigned issues manually  -as in ur latest example

Store in (123456, 345210)

but, i have multiple users i need to assign issues, so my concern is:

1.avoid assigning 2 users to the same Store, and

2.avoid not assigning an issue to the Store the assignee is visiting.

My idea (i don't know if this is possible) was to filter out the Stores per Assignee (using IssueFieldMatch) and use it as an input for a Store ID search

Ste Wright · Answer

Hi @Dimitris Dreamer

Just to check you want to:

* Search for all unassigned issues...
* Which should be assigned to a user looking after issues in those stores and..
* The stores assigned to each user can change daily

How do you want to visualise this for each user, given you mention the stores they are assigned to can change daily?

You can search for all unassigned open issues using searches such as:

assignee is empty and statusCategory != Done

or

assignee is empty and resolution is empty

Does this resolve your issue or is this too manual as it would be per store or a set of stores? Such as:

assignee is empty and resolution is empty and Store in (123456, 345210)

This assumes Store ID is in set list of options, or you'd need to use "Store ~" or similar for a free-text field

-------------------

If the Stores per user do not change regularly, an alternative would be to put Store ID into the Components field - here you can set a Component Lead per Component and change the project settings so issues created with that component are assigned to the Component Lead.

Ste