JQL search by issueId fails if issue key LIST has a deleted issue

Shailesh Shaile

I have a need where I need to get the list of issues remotely via their key. If one of the key corresponds to a deleted issues, entire JQL fails.

JQL: key in ("PROJ-1", "PROJ-5)

I also tried (with no luck)

key = "PROJ-1" or Key = "PROJ-5"
key in ("PROJ-1") OR key in ("PROJ-5")

I would expect that it should ignore the key that doesnt exist (like SQL). But in this case, entire JQL fails.

-Shailesh

Neha Sharma_9bogmy

Too late to post a comment on the thread, but it can be helpful to someone. So here's my observation -

I faced the same issue while making JIRA API calls using JQL. Where it should have returned results for valid keys, but it returned an exception if any issueKey was invalid.

However, I noticed something strange. When we make the same JQL query and use lowercase for the keys, e.g "abc-1" instead of "ABC-1", it gives results instead of the exception.