JQL Functions

JQL Functions are provided to search for issues against the Email Audit Log.
SINCE 5.4.0.7
Search for issues created by email
Usage in JQL: issue in createdByEmail(senderEmailAddress,dateFrom, dateTo, containingText)
Parameters are optional:
senderEmailAddress: email address of the sender of the email.
dateFrom, dateTo: these are date values in format of dd/MM/yyyy (as 31/03/2021) or durations like 5d or 3h, etc.
containingText: search the email subject for substring, you can use SQL wildcards like ? and %
Search for issues commented by email
Usage in JQL: issue in commentedByEmail(senderEmailAddress,dateFrom, dateTo, containingText)
Parameters are optional:
senderEmailAddress: email address of the sender of the email.
dateFrom, dateTo: these are date values in format of dd/MM/yyyy (as 31/03/2021) or durations like 5d or 3h, etc.
containingText: search the email subject for substring, you can use SQL wildcards like ? and %
Search for issues sent in email
Usage in JQL: issue in sentInEmail(searchParams)
The parameter is a construct of multiple fields. The parameter itself and its fields are optional.
Fields in Search Parameter
Field
Description
to
The recipient to whom the email was sent, SQL wildcards are allowed.
cc
The copy recipient to which the email was sent, SQL wildcards are allowed.
bcc
The blind copy recipient to which the email was sent, SQL wildcards are allowed.
sender
The Jira full name (displayName) of the sender.
dateFrom
Date in format of dd/MM/yyyy (as 31/03/2021) or durations like 5d or 3h, etc.
dateTo
Date in format of dd/MM/yyyy (as 31/03/2021) or durations like 5d or 3h, etc.
source
OPERATION: email sent manually
BULK: email sent in bulk operation
EVENT: email sent by Jira Email This Issue event notification
WORKFLOW: email sent by Jira Email This Issue post function
AUTOREPLY: email sent as autoreply for an incoming email
subject
The subject of the email that was sent, wildcards are accepted.
issue
The key of the issue that was sent.
Note: All fields can be combined into a search, they are ANDed in the query
If none of the fields is specified, query spans over to, cc, bcc (see below).
Example
Example
Result
issue in sentInEmail( "[email protected]")
Issues that were sent to [email protected] (either to or cc or bcc).
issue in sentInEmail("[email protected], sender=A Wilson, dateFrom=22/04/2020, dateTo=5d")
Issues that were sent by user "A Wilson", to [email protected], between April 22, 2020 and 5 days ago.
issue in sentInEmail( "[email protected], [email protected], [email protected], sender=A Wilson, dateFrom=22/04/2020, dateTo=-5d, source=OPERATION")
Issues that were sent by user "A Wilson", to [email protected], copied to [email protected], bcced to projectemailaddress@mycompany.com, between April 22, 2020 and 5 days ago, manually.
issue in sentInEmail( "issue=FOO-13")
The FOO-13 issue, if it was sent.

Field	Description
to	The recipient to whom the email was sent, SQL wildcards are allowed.
cc	The copy recipient to which the email was sent, SQL wildcards are allowed.
bcc	The blind copy recipient to which the email was sent, SQL wildcards are allowed.
sender	The Jira full name (displayName) of the sender.
dateFrom	Date in format of dd/MM/yyyy (as 31/03/2021) or durations like 5d or 3h, etc.
dateTo	Date in format of dd/MM/yyyy (as 31/03/2021) or durations like 5d or 3h, etc.
source	OPERATION: email sent manually BULK: email sent in bulk operation EVENT: email sent by Jira Email This Issue event notification WORKFLOW: email sent by Jira Email This Issue post function AUTOREPLY: email sent as autoreply for an incoming email
subject	The subject of the email that was sent, wildcards are accepted.
issue	The key of the issue that was sent.

Example	Result
`issue in sentInEmail( "[email protected]")`	Issues that were sent to [email protected] (either to or cc or bcc).
`issue in sentInEmail("[email protected], sender=A Wilson, dateFrom=22/04/2020, dateTo=5d")`	Issues that were sent by user "A Wilson", to [email protected], between April 22, 2020 and 5 days ago.
`issue in sentInEmail( "[email protected], [email protected], [email protected], sender=A Wilson, dateFrom=22/04/2020, dateTo=-5d, source=OPERATION")`	Issues that were sent by user "`A Wilson`", to [email protected], copied to [email protected], bcced to projectemailaddress@mycompany.com, between April 22, 2020 and 5 days ago, manually.
`issue in sentInEmail( "issue=FOO-13")`	The FOO-13 issue, if it was sent.

Last modified 11d ago