To find issues where theLevelcustom field (a single-select field) has any of the valuesBeginner,Intermediate, orAdvanced Pro, the JQL query must use theINoperator to check for multiple values. The correct query isLevel IN (Beginner, Intermediate, "Advanced Pro")(Option B), as it properly handles the multi-word valueAdvanced Prowith quotes.
Explanation of the Correct Answer (Option B):
TheLevelcustom field is a single-select field with three options:Beginner,Intermediate, andAdvanced Pro. TheINoperator allows checking if a field’s value matches any of a list of values. For multi-word values likeAdvanced Pro, quotes are required to treat it as a single value.
The queryLevel IN (Beginner, Intermediate, "Advanced Pro")searches for issues where theLevelfield is set toBeginner,Intermediate, orAdvanced Pro, covering all possible values.
Exact Extract from Documentation:
Advanced searching - operators reference
TheINoperator checks if a field’s value matches any of the specified values.
Example:
Level IN (Beginner, Intermediate, "Advanced Pro") returns issues where theLevelfield is set toBeginner,Intermediate, orAdvanced Pro.Note: For values containing spaces (e.g.,Advanced Pro), enclose the value in double quotes.(Source: Atlassian Support Documentation, "Advanced searching - operators reference")
Why This Fits: TheINoperator with properly quoted values efficiently searches for all specifiedLeveloptions, making Option B the correct answer.
Why Other Options Are Incorrect:
Level = Beginner OR Level = Intermediate OR Level = Advanced Pro (Option A):
This query is functionally correct but less efficient than usingIN. It requires multiple=operators and does not handle the multi-word valueAdvanced Procorrectly without quotes, potentially causing a syntax error.
Extract from Documentation:
UseINfor concise queries with multiple values. MultipleORclauses are valid but less efficient and require quotes for multi-word values.
(Source: Atlassian Support Documentation, "Advanced searching - operators reference")
The~operator is for text fields and partial matching, not for select fields. Use=orINfor exact value matching.
(Source: Atlassian Support Documentation, "Advanced searching - operators reference")
TheINoperator requires a list of values (e.g., (value1, value2, "value3")). Logical operators likeORare not allowed insideIN.
(Source: Atlassian Support Documentation, "Advanced searching - operators reference")
Additional Notes:
TheLevelfield must be a single-select custom field with the exact options listed.Verify the field’s configuration inSettings > Issues > Custom fields.
The query can be tested inIssues > Search for issuesand saved as a filter.
Ensure the user hasBrowse Projectspermission for the relevant projects.
[:, Atlassian Support Documentation:Advanced searching - operators reference, Atlassian Support Documentation:Search for issues using JQL, ]