This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.

Take a look here! If you have any questions please email support@appfire.com

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 46 Current »

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

Try it free: ☁Cloud 🖥Data Center

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

  • CommentLastUpdatedBy

  • 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