Advanced User Features Flashcards
The Reserved JQL characters are the following:
space (“ “) + . , ; ? | * / % ^ $ # @ [ ]
what do you need to do to be able to used them in a query ?
surround them with quote-marks (you can use either single quote-marks (‘) or double quote-marks (“))
AND
if you are searching a text field and the character is on the list of reserved characters (‘stop words’) for text searches,
What JQL Field type are these > < = != most appropriate for ?
Number fields
What JQL Field type are these ~ !~ most appropriate for ?
Text Fields
What JQL Field type are these “in” “not in” most appropriate for ?
Select list, radio buttons and check box fields
What are “is” “is not” paired with ?
NULL, IS EMPTY
To check if there is a value
What is the positioning of the NOT operator ?
How do you use WAS in JQL?
The WAS operator is used to find issues that previously had a specific value in a field.
status WAS “In Progress”
status WAS “In Progress” ON “2023/05/01”
status WAS “In Progress” DURING (“2023/01/01”, “2023/01/31”)
how do you use changed in JQL?
The CHANGED operator is used to find issues where a field’s value has changed. It is particularly useful for tracking modifications to fields over time.
status CHANGED
status CHANGED FROM “To Do” TO “In Progress”
status CHANGED DURING (“2023/02/01”, “2023/02/28”)
Difference between WAS and CHANGED :
WAS looks at past values of a field
CHANGED focuses on the action of change itself
What fields to WAS and CHANGED apply to ?
- Assignee
- Fixed Version
- Priority
- Reporter
- Resolution
WAS and CHANGED optional predicates ?
- from
- to
- before
- by
- during
Main Date JQL functions:
- now()
- startOfDay() & endOfDay()
- startOfWeek() & endOfweek()
- startOfMonth() & endOfMonth()
- startOfYear() & endOfYear()
JQL date functions how do optional increments work ?
The increments can be positive (for future dates) or negative (for past dates).
<dateFunction>([+|-]<increment>[<unit>])
Examples:
Issues created today:
created >= startOfDay()
Issues created in the last 7 days:
created >= startOfDay(-7d)
Issues updated last week:
updated >= startOfWeek(-1w) AND updated < startOfWeek()
Issues that will be due within the next month:
due <= endOfMonth(+1m)
Issues created exactly one year ago:
created >= startOfDay(-1y) AND created < startOfDay(-1y+1d)
</unit></increment></dateFunction>
JQL date functions what happens if you omit the time unit ?
Defaults to the natural period of the function
What to look out for when inspecting a JQL query:
- Does it need parenthesis to perform the order of the operations correctly ?
- Does it return the right resullts
- is it efficient
- is the date increment correct ?
