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 ?
What do general settings allow ?
Allow users to share fiilters and dashboards with the **Public **( default off )
What do Global permissions allow ?
To share dashboards and filters with:
* Group
* project
* My organization
What global permission is required to create and delete group filter subscriptions?
The Manage Group Filter subscriptions Global permission
Steps to prevent and remove public access to issue filters and dashboards:
- Turn public sharing off
- Set default sharing for filters and dashboards to private
- Remove public access to filters, if it’s been granted.
- Remove public access to dashboards, if it’s been granted.
- Revoke the Browse users and groups permission from the Anyone group, if it’s been granted.
Your management team needs to see a list of only those issues that were resolved in the previous week, from Sunday to Saturday. The list needs to be sent to them each week on Tuesdays. You plan to create a saved filter and filter subscription to do this.
Which JQL query will return the correct results?
1. resolved >= endOfWeek(-1)
2. resolved >= startOfWeek(-1) AND resolved < startOfWeek()
3. status changed TO Resolved BEFORE startOfWeek()
4. * resolved >= startOfDay(-7) AND resolved < startOfDay()*
5. resolved <= endOfWeek()
jql to find unresolved issues
resolution = Unresolved
resolution is EMPTY
Jira does not use null in JQL queries for unresolved issues.
6 types of bulk operation
- edit
- move
- transition
- delete
- watch
Whoc can suppress notifications by unchecking the option Send e-mail for this update for a bulk change operation if desired?
JIRA administrators
Bulk operation may fail in what cases ?
Workflow inconsistencies:
* validators
* no outgoing transiting from that state
* status property on the workflow
Lacking permissions
