Approval JQL Functions

Owned by Antonella Capalbo
Last updated: Sept 21, 2020
6 min read

This page provides information about Approval JQL Functions.

Select an Approval JQL Function from the Approval Menu or type it in the Jira Search Navigator.

pendingForApproval() 

This function returns issues having at least one approval request in 'Pending' status.

This function can take 0 or 1 argument (the Project Key).

Admissible operators include IN and NOT IN.

If you do not specify any argument the function returns all issues having at least one approval request in 'Pending' status.

issue in pendingForApproval()

Example

You are able to specify one Project Key in order to return only issues, that belong to the selected Project, having at least one approval request in 'Pending' status.

issue in pendingForApproval(Project Key)

Example


pendingForApprovalName() 

This function returns all issues having at least one approval request in 'Pending' status for the specific 'approval name'. 

This function expects the argument approval name.

issue in pendingForApprovalName(<approvalname>)

Admissible operators include IN and NOT IN.

Example


pendingForUserApproval() 

This function returns all issues having at least one approval request in 'Pending' status for the specific user. 

This function expects the argument username.

issue in pendingForUserApproval(<username>)

Admissible operators include IN and NOT IN.

Example

pendingUserApprovalName

This function returns all issues having at least one approval request in 'Pending' status for the specific User Name and Approval Name. 

This function expects the argument an User Name and Approval Name.

issue in pendingUserApprovalName(<username><approvalname>)

Admissible operators include IN and NOT IN.

Example

PendingNotifiedApproval() 

This function returns all issues having at least one notified approval request in 'Pending' status.

This function doesn't take any arguments.

issue in PendingNotifiedApproval()

Admissible operators include IN and NOT IN.

Example

PendingForUserNotifiedApproval()

This function all issues having at least one notified approval request in 'Pending' status for the specific user.

This function expects the argument username. 

issue in PendingForUserNotifiedApproval(<username>)

Admissible operators include IN and NOT IN.

Example


myPendingApproval() 

This function returns issues having at least one approval request waiting for logged user approval action.

This function can take 0 or 1 argument (the Project Key).

Admissible operators include IN and NOT IN.

If you do not specify any argument the function returns all issues having at least one approval request waiting for logged user approval action.

issue in myPendingApproval()

Example

You are able to specify one Project Key in order to return only issues, that belong to the selected Project, having at least one approval request waiting for logged user approval action.

issue in myPendingApproval(SD)

myPendingNotifiedApproval() 

This function returns all the issues having at least one notified approval request waiting for logged user approval action.

This function doesn't take any arguments.

issue in myPendingNotifiedApproval()

Admissible operators include IN and NOT IN.

Example

MyPendingNoComment()

This function returns all the issues having at least one pending approval for logged user that doesn't require an approbation comment.

This function doesn't take any arguments.

issue in myPendingNoComment()

Admissible operators include IN and NOT IN.

pendingForGroupApproval()

The function returns all issues having at least one approval request in 'Pending' status for the specified Group.

This function expects the argument Group.

issue in pendingForGroupApproval("<Group>")

The search for issue in pendingForGroupApproval("") returns all issues having at least one notified approval request in 'Pending' status for every Group.

Admissible operators include IN and NOT IN.

Example

pendingForGroupNotifiedApproval()

The function returns all issues having at least one notified approval request in 'Pending' status for the specified Group.

This function expects the argument Group.

issue in pendingForGroupNotifiedApproval("<Group>")

The search for issue in pendingForGroupNotifiedApproval("") returns all issues having at least one notified approval request in 'Pending' status for every Group.

Admissible operators include IN and NOT IN.

Example

pendingApprovalDays()

The function returns all issues having at least one pending approval request in 'Pending' status for a number of days greater or equal to the specified Days.

This function expects the argument Days.

The argument Days is required.

issue in pendingApprovalDays("<Integer>")

Admissible operators include IN and NOT IN.

rejectedForApprovalStatus()

This function returns all issues having at least one approval request in 'Rejected' status.

This function doesn't take any arguments. 

issue in rejectedForApprovalStatus()

Admissible operators include IN and NOT IN.

Example

myRejectedApproval()

This function returns all issues having at least one approval request that has been 'Rejected' by the logged user.

This function doesn't take any arguments. 

issue in myRejectedApproval()

Admissible operators include IN and NOT IN.

Example

approvedForApprovalStatus()

This function returns  all issues having all approval requests in 'Approved' status.

This function doesn't take any arguments. 

issue in approvedForApprovalStatus()

Admissible operators include IN and NOT IN.

approvedOrAbstainedStatus() 

This function returns all issues having all approval requests in 'Approved' or 'Abstained' statuses.

This function doesn't take any arguments.

issue in approvedOrAbstainedStatus()

Admissible operators include IN and NOT IN.

Example

myApprovedApproval() 

This function returns all issues, found in the Approval Source Status, having at least one approval request that has been 'Approved' by the logged user.

This function doesn't take any arguments. 

issue in myApprovedApproval()

Admissible operators include IN and NOT IN.

Example

myApprovedInHistory()

This function filters in Approval History all issues having received an Approbation by the logged user.

This function doesn't take any arguments. 

issue in myApprovedInHistory()

Admissible operators include IN and NOT IN.

myApprovedOrAbstainedStaus()

This function returns all issues having at least one approval request that has been 'Approved' or 'Abstained' by the logged user.

This function doesn't take any arguments. 

issue in myApprovedOrAbstainedStaus()

Admissible operators include IN and NOT IN.

Example

pendingAutomaticTransitioning() 

This function returns all issues configured to be automatically transitioned on reached approbations.

This function doesn't take any arguments. 

issue in pendingAutomaticTransitioning()

Admissible operators include IN and NOT IN.

defineApproval()

This function returns all issues configured with specific approvals (not following the overall approval mapping). 

This function doesn't take any arguments.

issue in defineApproval()

Admissible operators include IN and NOT IN.

failedAutomaticTransitioning()

This function returns all issues not automatically transitioned due to conditions and validators have not been validated.

This function doesn't take any arguments. 

issue in failedAutomaticTransitioning()

Admissible operators include IN and NOT IN.

Example

myPendingForDelegatedApproval()

This function returns all issues pending for my approval due to I'm a delegated approver.

This function doesn't take any arguments. 

issue in myPendingForDelegatedApproval()

Admissible operators include IN and NOT IN.


Example

MyPendingForDelegatedNoComment()

This function returns all issues pending for logged user approval due to a delegation that doesn't require an approbation comment.

This function doesn't take any arguments. 

issue in MyPendingForDelegatedNoComment()

Admissible operators include IN and NOT IN.

PendingForDelegatedApproval()

This function returns issues pending for approval due to a delegation from a specific delegator for a specific project and issue type in a given time range.

This function takes the listed arguments: delegator username(mandatory), Project Id (optional), IssueType Id (optional), Start Date (optional), End Date (optional). 

issue in pendingForDelegatedApproval('delegator username',10004,'10006','','')

Admissible operators include IN and NOT IN.

Example

noApprovalsReceived()

This function returns all issues pending for approval that have no yet received any approbation.

This function doesn't take any arguments. 

issue in noApprovalsReceived()

Admissible operators include IN and NOT IN.


Example

partiallyApproved()

This function returns all issues pending approval having already at least catched one approbation.

This function doesn't take any arguments. 

issue in partiallyApproved()

Admissible operators include IN and NOT IN.

Example


approvedApproval()

This function returns all issues with a number of approbations from an Approval (specified by name) greater than the specified Number.

This function expects the arguments Approval Name and an integer.

All two the arguments are required.

(issue in approvedApproval("Approval Name", 1)

Example

In this section

Still need help?

We would love to help.