Exam ACP-120 Topic 3 Question 76 Discussion

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 is Level IN (Beginner, Intermediate, "Advanced Pro")(Option B), as it properly handles the multi-word value Advanced Prowith quotes.
* Explanation of the Correct Answer (Option B):
* TheLevelcustom field is a single-select field with three options:Beginner,Intermediate, and Advanced 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 the Levelfield 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 specified Leveloptions, 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")
* Level ~ (Beginner, Intermediate, "Advanced Pro") (Option C):
* The~operator is used for partial text matching (e.g., wildcard searches) and is not valid for single-select fields likeLevel, which require exact value matching. This query is syntactically incorrect.
* Extract from Documentation:
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")
* Level IN (Beginner, Intermediate OR Advanced Pro) (Option D):
* This query is syntactically incorrect, as theINoperator requires a comma-separated list of values, not logical operators likeOR. Additionally,Advanced Proneeds quotes to be treated as a single value.
* Extract from Documentation:
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