I’m working with JIRA v8.5.9 and having trouble with a search query. I’m trying to find sub-tasks related to stories that are assigned to specific users but getting zero results.
Here’s the query I’m using:
issueType = "defect" AND assignee in ("john.doe", "jane.smith")
I want to locate all sub-tasks under stories where the assignee is either john.doe or jane.smith. The search runs without errors but returns nothing even though I know there should be matching tickets. Has anyone encountered this issue before? What could be causing the query to fail?
also, check your jira permissions - sometimes the query’s fine but u can’t actually view those issues or projects. try testing with just one username first to make sure that works b4 using ‘in’ with multiple users.
I experienced a similar issue previously with JIRA 8.5.x. It appears that your current query is set up to search for defects assigned to specific users, but you want to find sub-tasks associated with those users’ stories. Since sub-tasks and their parent stories have distinct assignee fields, you should utilize the “parent” function. Consider revising your query as follows:
issueType = "Sub-task" AND parent in (assignee in ("john.doe", "jane.smith"))
This modification should retrieve sub-tasks linked to stories assigned to either user. Additionally, ensure that the usernames are entered correctly, as JIRA usernames may differ from display names. Verify this by reviewing the user profile for the accurate username.
Looks like there’s a mix-up in your query setup. You’re searching for ‘defects’ but mentioned wanting sub-tasks - you’ll need to update your filter to match what you actually want. If you’re after sub-tasks related to stories, change your query to reflect that. Also, JIRA’s picky about usernames, so double-check you’ve got the assignees spelled right. Try testing something simple first like assignee = "john.doe" to make sure that user exists before adding more filters.