Jira Admin Certification Questions and
Answers| Latest Update
JQL Query to find bugs since the beginning of this year which were closed and then reopened?
✔️✔️project = "dev" AND issueType = "Bug" AND status CHANGED FROM "Closed" TO
"Reopened" AFTER startOfYear()
Filters can be exported in Issue Navigator. True of false? ✔️✔️True!
To share a filter, where do you go? ✔️✔️Details (next to Save As) -> edit permissions -> Add
Shares
category = development AND status changed from Done AND status != Done ✔️✔️find reopened
issues in dev category
How can you tell its a simplified workflow? ✔️✔️If all issues go from one status to any other
status in the flow. This is shown with the "All" transitions next to each status.
If you create a project from a template, what is automatically enabled? ✔️✔️Extended project
administration
Why might two groups see different issue statistics in the same gadgets? ✔️✔️There is issue
securities set and some groups are able to see issues the other can't.
assignee = currentUser() AND IssueType = Bug AND resolved >= -1d ✔️✔️List of bugs that I closed
in the last day
assignee = currentUser() AND updated >= startOfDay(-7) ✔️✔️list of issues I updated in last week
,assignee = currentUser() AND due >= "2018/01/15" AND due <= "2018/01/16" ✔️✔️list of my
issues due in the next 2 days
creator in membersOf(Development) AND assignee is Empty ✔️✔️list of issues from my team
that are unassigned
assignee changed to currentUser() after -7d ✔️✔️list of issues that were assigned to me in the
last week
type = Bug AND status WAS closed by currentUser() during ("2018/02/01", "2018/02/28")
✔️✔️list of bugs that I closed in February
type = Bug AND status = Open AND component not in (Database, Login) ✔️✔️list of open bugs for
systems other than Database and Login
resolution = Empty AND summary ~ "storm damage" ✔️✔️list of unresolved issues about storm
damage
assignee in membersOf(Development) AND dueDate < now() AND resolution = EMPTY ✔️✔️all
my teams issues due by end of today that are not resolved
due <= -1w ✔️✔️Show me issues due MORE THAN a week ago
created >= -24h ✔️✔️Show me issues created WITHIN the last 24 hours
resolved >= -2w AND resolved <= -1w ✔️✔️Show me issues resolved 1-2 weeks ago
* farther out data goes first!!
, due >= 2016-03-22 AND due <= 2016-03-31 ✔️✔️Show me issues between two dates
due >= 2016-03-13 AND due < 2016-03-14 ✔️✔️show me issues on exact data (3/13)
Note: the "<"
This is best practice for exact dates!!
text ~ "\"teams in space\"" ✔️✔️find issues with exact text "teams in space"
text ~ "network\\[20\\]" ✔️✔️find issues with exact text "network[20]"
startOfDay("-2d") vs -2d ✔️✔️startOfDay("-2d") returns issues starting from midnight 2 days ago
and the latter returns issues in past 48 hrs from current time
(1) duedate <= 1d AND duedate > now()
(2) duedate <= 24h ✔️✔️issues due within 24 hours from now
Issues created since I first logged in? ✔️✔️created < currentLogin() AND creator = currentUser()
also theres lastLogin()
What issues are in open sprints? ✔️✔️sprint in openSprints()
Issues im currently watching? ✔️✔️issue IN watchedIssues()
Issues I looked at most recently? ✔️✔️issue IN issueHistory()
Answers| Latest Update
JQL Query to find bugs since the beginning of this year which were closed and then reopened?
✔️✔️project = "dev" AND issueType = "Bug" AND status CHANGED FROM "Closed" TO
"Reopened" AFTER startOfYear()
Filters can be exported in Issue Navigator. True of false? ✔️✔️True!
To share a filter, where do you go? ✔️✔️Details (next to Save As) -> edit permissions -> Add
Shares
category = development AND status changed from Done AND status != Done ✔️✔️find reopened
issues in dev category
How can you tell its a simplified workflow? ✔️✔️If all issues go from one status to any other
status in the flow. This is shown with the "All" transitions next to each status.
If you create a project from a template, what is automatically enabled? ✔️✔️Extended project
administration
Why might two groups see different issue statistics in the same gadgets? ✔️✔️There is issue
securities set and some groups are able to see issues the other can't.
assignee = currentUser() AND IssueType = Bug AND resolved >= -1d ✔️✔️List of bugs that I closed
in the last day
assignee = currentUser() AND updated >= startOfDay(-7) ✔️✔️list of issues I updated in last week
,assignee = currentUser() AND due >= "2018/01/15" AND due <= "2018/01/16" ✔️✔️list of my
issues due in the next 2 days
creator in membersOf(Development) AND assignee is Empty ✔️✔️list of issues from my team
that are unassigned
assignee changed to currentUser() after -7d ✔️✔️list of issues that were assigned to me in the
last week
type = Bug AND status WAS closed by currentUser() during ("2018/02/01", "2018/02/28")
✔️✔️list of bugs that I closed in February
type = Bug AND status = Open AND component not in (Database, Login) ✔️✔️list of open bugs for
systems other than Database and Login
resolution = Empty AND summary ~ "storm damage" ✔️✔️list of unresolved issues about storm
damage
assignee in membersOf(Development) AND dueDate < now() AND resolution = EMPTY ✔️✔️all
my teams issues due by end of today that are not resolved
due <= -1w ✔️✔️Show me issues due MORE THAN a week ago
created >= -24h ✔️✔️Show me issues created WITHIN the last 24 hours
resolved >= -2w AND resolved <= -1w ✔️✔️Show me issues resolved 1-2 weeks ago
* farther out data goes first!!
, due >= 2016-03-22 AND due <= 2016-03-31 ✔️✔️Show me issues between two dates
due >= 2016-03-13 AND due < 2016-03-14 ✔️✔️show me issues on exact data (3/13)
Note: the "<"
This is best practice for exact dates!!
text ~ "\"teams in space\"" ✔️✔️find issues with exact text "teams in space"
text ~ "network\\[20\\]" ✔️✔️find issues with exact text "network[20]"
startOfDay("-2d") vs -2d ✔️✔️startOfDay("-2d") returns issues starting from midnight 2 days ago
and the latter returns issues in past 48 hrs from current time
(1) duedate <= 1d AND duedate > now()
(2) duedate <= 24h ✔️✔️issues due within 24 hours from now
Issues created since I first logged in? ✔️✔️created < currentLogin() AND creator = currentUser()
also theres lastLogin()
What issues are in open sprints? ✔️✔️sprint in openSprints()
Issues im currently watching? ✔️✔️issue IN watchedIssues()
Issues I looked at most recently? ✔️✔️issue IN issueHistory()
