Skip to end of banner
Go to start of banner

JQL Functions Reference

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 49 Next »

This page lists JQL functions 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

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()

  • SubtasksOfParentsInQuery()

  • ParentSummary

  • ParentPriority

  • ParentIssueType

  • ParentStatus

  • ParentStatusCategory

  • SubtasksCount

  • SubtaskSummary

  • SubtaskKey

  • SubtaskPriority

  • SubtaskIssueType

  • SubtaskStatus

  • SubtaskStatusCategory

  • 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

  • CommentedUpdatedOnDate

Issue updates

  • UpdatedByUsersCount

  • UpdatedBy

  • TransitionedBy

  • LoggedTimeBy

  • UpdatedOnDates

  • LastUpdatedBy

  • MovedProjects

  • MovedProjectsCount

Text

  • ExactTextMatch()

  • ExactTextMatchCaseInsensitive()

  • WildcardMatch()

  • Regex()

Agile

  • NextSprint()

  • PreviousSprint()

  • AddedToSprintAfterStart()

Field Comparisons

  • DateCompare()

  • DateCompareIgnoreTime()

  • HasSameUpdatedAndCreatedDate

  • HasSameAssigneeAndReporter

  • HasSameVersions

Notes

Standard JQL

References for using standard JQL functions in Jira Cloud

  • No labels
Error formatting macro: appfire-confluence-analytics: java.lang.NullPointerException: Cannot invoke "com.atlassian.confluence.xhtml.api.MacroDefinition.getMacroId()" because "macroDefinition" is null