Approval JQL Functions

This page provides information about Approval JQL Functions.

Select an Approval JQL Function from the Approval Menu in Herzum Approval Tab

 

Need support?

We would love to help.

Submit a support request

The Herzum Approval Tab empowers users to efficiently search for issues based on pending and replied approvals.

Access and Configuration:

  • Users can access the Herzum Approval Tab through the apps menu.

  • Administrators can configure access to this feature within the Permissions settings of the Herzum Approval configuration.

image-20240404-154637.png

Search Functionality:

  • The tab includes various filters to refine your search results and enhance efficiency.

617cb203-d7c0-4a77-a304-2b574ba8a9c3.png

  • For advanced searches, utilize the "Advanced JQL" button to create custom JQL queries.

 

For all Herzum Approval JQL functions, issues are loaded in blocks of 50 until all issues are displayed on the screen. Once all issues are fully loaded, the following message appears above the results table: "100% of the issues have been loaded."

 

Please note that search loading times may vary depending on the amount of data returned. Using filters can significantly improve performance.

 

Here's a list of the available search functions within the Herzum Approval Tab:

pendingForApproval() 

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

This function can take from 0 to 2 arguments:

  • first parameter expects the Project key or “All”

Examples:  PendingForApproval('All'), issue in PendingForApproval('Pkey')

  • second parameter expects true or false; this parameter, when true, enables an alternative filter method on the conditional rules that may be used to improve performance for some scenarios

Example:  pendingForApproval('All','true')

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

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.

 

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.

 

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 a User Name and Approval Name.

Admissible operators include IN and NOT IN.

 

pendingNotifiedApproval() 

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

This function doesn't take any arguments.

Admissible operators include IN and NOT IN.

 

 

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

 

 

myPendingApproval() 

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

This function can take from 0 to 2 arguments:

  • first parameter expects the Project key or All

Examples:  myPendingApproval('All'), issue in myPendingApproval('Pkey')

  • second parameter expects true or false; this parameter, when true, enables an alternative filter method on the conditional rules that may be used to improve performance for some scenarios

Example:  myPendingApproval('All','true')

Admissible operators include IN and NOT IN.

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.

Admissible operators include IN and NOT IN.

Correct misspelled word, change in all matches and redeploy

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.

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.

Admissible operators include IN and NOT IN.

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.

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.

 

rejectedForApprovalStatus()

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

This function doesn't take any arguments. 

Admissible operators include IN and NOT IN.

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. 

Admissible operators include IN and NOT IN.

approvedForApprovalStatus()

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

This function doesn't take any arguments. 

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.

Admissible operators include IN and NOT IN.

 

 

 

 

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. 

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.

Admissible operators include IN and NOT IN.

 

 

myPendingForDelegatedApproval()

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

This function doesn't take any arguments. 

Admissible operators include IN and NOT IN.

 

 

 

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. 

Admissible operators include IN and NOT IN.

 

 

 

pendingForDelegatedNoComment()

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

This function doesn't take any arguments. 

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

Admissible operators include IN and NOT IN.

noApprovalsReceived()

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

This function doesn't take any arguments. 

Admissible operators include IN and NOT IN.

 

partiallyApproved()

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

This function doesn't take any arguments. 

Admissible operators include IN and NOT IN.