Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
toc-examples
toc-examples

Here are the most common examples of using S-JQL.

Table of Contents
minLevel4
indent0
stylenone

Anchor
fiatas
fiatas
Find issues added to a structure

...

Code Block
issue in structure()

^ up to the list of examples

Anchor
qffgsbtdoliis
qffgsbtdoliis

...

Code Block
issue in structure("Project work breakdown", "leaf or parent of leaf")

...

Anchor
raeiacsaaotc
raeiacsaaotc

...

Code Block
issueOrAncestor in [type = Epic and status = Assigned]

...

Anchor
ftcawsiaas
ftcawsiaas

...

Code Block
[type = 'Test Case'] and ancestor in [type = Story and sprint in openSprints()]

^ up to the list of examples

Anchor
faitabci
faitabci

Find all issues that are blocking critical issues

...

Code Block
child of [priority = Critical]

^ up to the list of examples

Anchor
fauiiapoap
fauiiapoap

...

Code Block
issue in structure("Project work breakdown", "[assignee is empty] and descendant of PROJ-123")

^ up to the list of examples

Anchor
tvoupotp
tvoupotp

Top-level view on unfinished parts of a project

...

Code Block
issue in structure("Project work breakdown", "root and descendants in [resolution is empty]")

...

Anchor
fvormbueosant
fvormbueosant

...

Code Block
issue in structure("Planning", "[type = Task] and parent not in [type in (Epic, Story)]")

^ up to the list of examples

Anchor
fvoricbriihuc
fvoricbriihuc

...

Code Block
[resolution is not empty] and child in [resolution is empty]

...

Anchor
fitcbrbatcar
fitcbrbatcar

...

Code Block
issue in structure("Planning", "[resolution is empty] and not(child is empty or child in [resolution is empty])")

...

Anchor
gavoasloth
gavoasloth

...

Code Block
child of (child of root)

^ up to the list of examples

Get the contents of a folder

...

Goal: The users want to see all issues that are located under the specified folder.

How to achieve: In the Issue Navigator, switch to Advanced Searching and run the following query:

Code Block
issue in structure("My Structure", "descendant of folder('next release')")

Note that the folder name is case-insensitive.

^ up to the list of examples

...

languagexml

...

.

...