Exam (elaborations)
JIRA JQL FUNCTIONS TEST
- Course
- Institution
JIRA JQL FUNCTIONS TEST...
[Show more]
Content preview
approved() - ANSWER Only applicable if JIRA Service Desk is installedand licensed.
Search for issues that require approval and have a final decision of
approval.
approver() - ANSWER Only applicable if JIRA Service Desk is installed
and licensed.
Search for issues that require or require approval by the listed user/s.
This uses an OR operator, and you must specify the username/s.
breached() - ANSWER Only applicable if Jira Service Desk is installed
and licensed.
Returns issues whose most recent SLA has missed its goal.
cascadeOption() - ANSWER Search for issues that match the selected
values of a 'cascading select' custom field.
Find issues where a custom field ("Location") has the value "USA" for
the first tier and "New York" for the second tier: location in
cascadeOption("USA","New York")
closedSprints() - ANSWER Search for issues that are assigned to a
completed Sprint. Note, it is possible for an issue to belong to both a
completed Sprint(s) and an incomplete Sprint(s). See also openSprints().
completed() - ANSWER Only applicable if Jira Service Desk is installed
and licensed.
Returns issues that have an SLA that has completed at least one cycle.
Find issues where Time to First Response has completed at least one
cycle:"Time to First Response" = completed()
componentsLeadByUser() - ANSWER Find issues in components that
are led by a specific user. You can optionally specify a user, or if the
, user is omitted, the current user (i.e. you) will be used. Note that if you
are not logged in to JIRA, a user must be specified.
currentLogin() - ANSWER Find issues that have been created during my
current session:created > currentLogin()
currentUser() - ANSWER Find issues that are assigned to me:assignee
= currentUser()
Find issues that were reported to me but are not assigned to me:
reporter = currentUser() AND (assignee != currentUser() OR assignee is
EMPTY)
earliestUnreleasedVersion() - ANSWER Find issues that relate to the
earlist unreleased version of the ABC project:affectedVersion =
earliestUnreleasedVersion(ABC) or fixVersion =
earliestUnreleasedVersion(ABC)
elapsed() - ANSWER Service Desk Only.
Returns issues whose SLA clock is at a certain point relative to a cycle's
start event.
Find issues that have been waiting for a first response for more than 1
hour:"Time to First Response" > elapsed("1h")
endOfDay() - ANSWER Find issues due by the end of tomorrow:due <
endOfDay("+1")
endOfMonth() - ANSWER Find issues due by the end of this month:due
< endOfMonth()
Find issues due by the end of next month:due < endOfMonth("+1")
Find issues due by the 15th of next month:due < endOfMonth("+15d")
endOfWeek() - ANSWER Find issues due by the end of this week:due <
endOfWeek()
Find issues due by the end of next week:due < endOfWeek("+1")
endOfYear() - ANSWER Find issues due by the end of this year:due <
endOfYear()
Find issues due by the end of March next year:due < endOfYear("+3M")
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79650 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now