Jira Query on Single user field not giving expected result.

Question

Query is

project = **** AND issuetype in (Defect, "Defect Record") AND status in (Submitted, Assigned) AND priority in ("P1 - Urgent", "P2 - High") AND "Target GA Release" in ("32.6.3", "32.7.1") AND "Dev Manager" = x ORDER BY createdDate ASC

The result displays the issues with Dev Manager = y

When checked the history, Dev Manager was moved from x to y. The change is not reflecting the query. We did reindexing and that did not work either.

Please suggest.

chanduperi · Answer

Thanks @Marc -Devoteam- for help. Added few more details to @David Nickell reply.

Added below also in JQL

"Dev Manager" in a JQL as "Dev Manager" = X AND  "Dev Manager" != Y

Still reporting a JIRA where Dev Manager is Y

Dev Manager field is a Single User Picker Field

chanduperi · Answer

Thanks @David Nickell for details.

User's name did not change. What happened is, "Dev Manager" is a User Picker field. One of the JIRA was having this field set as User "X" and later changed to User "Y"

We want to query JIRAs where "Dev Manager" is User "X"

But, the queried list is having the JIRA where Dev Manager is User "Y" also even though JQL specifically states "Dev Manager = X" because this JIRA was having X as the Dev Manager previously.

We did re-index the JIRA and did not help

When we the single JIRA, it does report "Dev Manager" as Y only. But, JQL returns this JIRA also

Marc -Devoteam- · Answer

Hi @chanduperi

On updating information that is fixed in a used JQL in a filter, this won't update automatically when changing information.

As @David Nickell states the information related to the Dev Manager changed, this will require you to update the query.

You could also make the statement as: "Dev Manager" is not empty

This will always fetch information if the field is not empty and doesn't depend on changes made from x to y