Versions Compared

Old Version 53

changes.mady.by.user Deborah Scott

Saved on

compared with

New Version Current

changes.mady.by.user Deborah Scott

Saved on

Key

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

This page lists JQL functions and keywords for JQL Search Extensions for Jira Cloud. For details on using functions with Jira Data Center see the Server/Data Center documentation.

Jira Hierarchy & Advanced Roadmaps

Issue hierarchy

Powerful generic functions that support standard Jira hierarchy and Advanced Roadmaps: Subtasks, Stories, Epics, Initiatives, etc:

  • ParentsOfIssuesInQuery()

  • ParentsOfIssuesInQueryRecursive()

  • ChildrenOfIssuesInQuery()

  • ChildrenOfIssuesInQueryRecursive()

Epics

  • EpicsOfChildrenInQuery()

  • ChildrenOfEpicsInQuery()

  • issuesInEpicCount

  • bugsInEpicCount

  • storiesInEpicCount

  • issuesInEpicToDoCount

  • issuesInEpicInProgressCount

  • issuesInEpicDoneCount

  • bugsInEpicToDoCount

  • bugsInEpicInProgressCount

  • bugsInEpicDoneCount

  • storiesInEpicToDoCount

  • storiesInEpicInProgressCount

  • storiesInEpicDoneCount

Subtasks

  • ParentsOfSubtasksInQuery()

    • Text matches

    • ExactTextMatch()

    • ExactTextMatchCaseInsensitive()

    • WildcardMatch()

    • Regex()

    Agile sprints

    • NextSprint()

    • PreviousSprint()

    • AddedToSprintAfterStart()

    Attachments

    • AttachmentContent

    • AttachmentsCount

    • AttachedByUser

    • AttachedOnDate

    • AttachmentExtension

    • AttachmentName

    Subtasks

    • SubtasksOfParentsInQuery()

    • ParentSummary

    • ParentPriority

    • ParentIssueType

    • ParentStatus

    • ParentStatusCategory

    Issues with subtasks

    • ParentsOfSubtasksInQuery()

    • SubtasksCount

    • SubtaskSummary

    • SubtaskKey

    • SubtaskPriority

    • SubtaskIssueType

    • SubtaskStatus

    • SubtaskStatusCategory

    Comments

    • CommentsCount

    • CommentedByUser

    • CommentLastCreatedBy

    • CommentLastCreatedOnDate

    • CommentLastUpdatedBy

    • CommentLastUpdatedOnDate

    • CommentedOnDate

    • CommentUpdatedOnDate

    Versions

    • AffectedVersionsArchived

    • AffectedVersionsReleased

    • AffectedVersionsOpened

    • AffectedVersionsCount

    • AffectedVersionReleaseDate

    • FixVersionsArchived

    • FixVersionsReleased

    • FixVersionsOpened

    • FixVersionsCount

    • FixVersionReleaseDate

    • LinkedIssuesOfQuery()

    • LinksCount

    • LinkedBy

    • LinksIssue

    • LinkType

    • LinkedIssueStatus

    • LinkedIssueStatusCategory

    • LinkedIssueType

    • LinkedIssuePriority

    • LinksIssuesCount

    • LinkedByIssuesCount

    • LinkedByIssueProject

    • LinksIssueProject

    Formerly called remote links

    • RemoteLinkUrl

    • RemoteLinkUrlPartialMatch

    • RemoteLinkApplicationName

    • RemoteLinkApplicationType

    • RemoteLinkHost

    • RemoteLinkQuery

    • RemoteLinkPath

    • RemoteLinkTitle

    • RemoteLinkTitlePartialMatch

    • RemoteLinkRelationship

    • RemoteLinksCount

    Versions

    • AffectedVersionsArchived

    • AffectedVersionsReleased

    • AffectedVersionsOpened

    • AffectedVersionsCount

    • AffectedVersionReleaseDate

    • FixVersionsArchived

    • FixVersionsReleased

    • FixVersionsOpened

    • FixVersionsCount

    • FixVersionReleaseDate

    Attachments

    • AttachmentContent

    • AttachmentsCount

    • AttachedByUser

    • AttachedOnDate

    • AttachmentExtension

    • AttachmentName

    Comments

    • CommentsCount

    • CommentedByUser

    • CommentLastCreatedBy

    • CommentLastCreatedOnDate

    • CommentLastUpdatedBy

    • CommentLastUpdatedOnDate

    • CommentedOnDate

    • CommentUpdatedOnDate

    Issue updates

    • UpdatedByUsersCount

    • UpdatedBy

    • TransitionedBy

    • LoggedTimeBy

    • UpdatedOnDates

    • LastUpdatedBy

    • MovedProjects

    • MovedProjectsCount

    Text

    • ExactTextMatch()

    • ExactTextMatchCaseInsensitive()

    • WildcardMatch()

    • Regex()

    Agile

    • NextSprint()

    • PreviousSprint()

    • AddedToSprintAfterStart()

    Field comparisons

    Field values

    • DateCompare()

    • DateCompareIgnoreTime()

    • HasSameUpdatedAndCreatedDate

    • HasSameAssigneeAndReporter

    • HasSameVersions

    Notes

    Standard JQL

    Resources for using standard JQL functions in Jira Cloud