Jira Jira Query Language and Advanced Features 2 — Questions and Answers
Question 1: In JQL, what does the ORDER BY clause do?
- Limits the number of results returned
- Sorts the search results by a specified field (Correct answer)
- Groups issues by a category
- Filters issues by creation order only
Correct answer: Sorts the search results by a specified field
The ORDER BY clause in JQL sorts the returned issues by one or more fields in ascending or descending order.
Question 2: Which JQL operator finds issues that are not in a specific status?
- status != Done (Correct answer)
- status NOT Done
- status EXCLUDE Done
- status REMOVE Done
Correct answer: status != Done
The != operator in JQL returns issues where the field does not equal the specified value.
Question 3: What is the purpose of the issueFunction in advanced JQL with ScriptRunner?
- To run Groovy scripts that return dynamic sets of issues beyond standard JQL capabilities (Correct answer)
- To create new issues via JQL query
- To export issues to CSV format
- To visualize JQL results as a chart
Correct answer: To run Groovy scripts that return dynamic sets of issues beyond standard JQL capabilities
The issueFunction plugin extends JQL with Groovy-powered functions for complex queries not possible with standard JQL.
Question 4: In JQL, which field would you use to find issues linked to a specific epic?
- parentEpic
- Epic Link (Correct answer)
- epicParent
- linkedEpic
Correct answer: Epic Link
The Epic Link field in JQL filters issues associated with a specific epic by the epic's issue key.
Question 5: What does the JQL keyword EMPTY match?
- Issues with no comments
- Issues where the specified field has no value set (Correct answer)
- Issues with empty descriptions
- Issues in an empty sprint
Correct answer: Issues where the specified field has no value set
The EMPTY keyword in JQL finds issues where a specified field has no value assigned.
Question 6: Which JQL query would return all issues updated in the last 7 days?
- updated >= -7d (Correct answer)
- updated > lastWeek()
- updated WITHIN 7d
- updated = recent(7)
Correct answer: updated >= -7d
The JQL syntax updated >= -7d uses a relative date offset to filter issues updated within the past 7 days.
Jira Jira Query Language and Advanced Features 2
In JQL, what does the ORDER BY clause do?