JQL Functions and Keywords

Owned by Werare Support User
Last updated: Sept 27, 2024
1 min read

Jira Hierarchy & Advanced Roadmap

  • ParentsOfIssuesInQuery()

  • ChildrenOfIssuesInQuery()

Epics

  • EpicsOfChildrenInQuery()

  • ChildrenOfEpicsInQuery()

  • IssuesInEpicCount

  • BugsInEpicCount

  • StoriesInEpicCount

  • IssuesInEpicToDoCount

  • IssuesInEpicInProgressCount

  • IssuesInEpicDoneCount

  • BugsInEpicToDoCount

  • BugsInEpicInProgressCount

  • BugsInEpicDoneCount

  • StoriesInEpicToDoCount

  • StoriesInEpicInProgressCount

  • StoriesInEpicDoneCount

Subtasks

  • ParentsOfSubtasksInQuery()

  • SubtasksOfParentsInQuery()

  • ParentSummary

  • ParentPriority

  • ParentIssueType

  • ParentStatus

  • ParentStatusCategory

  • SubtaskCount

  • SubtaskSummary

  • SubtaskKey

  • SubtaskPriority

  • SubtaskIssueType

  • SubtaskStatus

  • SubtaskStatusCategory

Links

  • LinkedIssuesOfQuery()

  • LinksCount

  • LinkedBy

  • LinksIssue

  • LinkType

  • LinkedIssueStatus

  • LinkedIssueStatusCategory

  • LinkedIssueType

  • LinkedIssuePriority

  • LinksIssuesCount

  • LinkedByIssuesCount

  • LinkedByIssueProject

  • LinksIssueProject

Web Links

  • RemoteLinkUrl

  • RemoteLinkUrlPartialMatch

  • RemoteLinkApplicationName

  • RemoteLinkApplicationType

  • RemoteLinkHost

  • RemoteLinkQuery

  • RemoteLinkPath

  • RemoteLinkTitle

  • RemoteLinkTitlePartialMatch

  • RemoteLinkRelationship

  • RemoteLinksCount

Versions

  • AffectedVersionsArchived

  • AffectedVersionsReleased

  • AffectedVersionsOpened

  • AffectedVersionsCount

  • AffectedVersionReleaseDate

  • FixVersionsArchived

  • FixVersionsReleased

  • FixVersionsOpened

  • FixVersionsCount

  • FixVersionReleaseDate

Attachments

  • AttachmentCount

  • AttachedByUser

  • AttachedOnDate

  • AttachmentExtension

  • AttachmentName

Comments

  • CommentCount

  • CommentedByUser

  • CommentLastCreatedBy

  • CommentLastCreatedOnDate

  • CommentLastUpdatedBy

  • CommentLastUpdatedOnDate

  • CommentedOnDate

  • CommentUpdatedOnDate

Issue Updates

  • UpdatedByUsersCount

  • UpdatedBy

  • TransitionedBy

  • LoggedTimeBy

  • UpdatedOnDates

  • LastUpdatedBy

  • MovedProjects

Text

  • ExactTextMatch()

  • ExactTextMatchCaseInsensitive()

  • WildcardMatch()

  • Regex()

Agile

  • NextSprint()

  • PreviousSprint()

  • AddedToSprintAfterStart()

Field Comprassion

  • DateCompare()

  • DateCompareIgnoreTime()

  • HasSameUpdatedAndCreatedDate

  • HasSameAssigneeAndReporter

  • HasSameVersions