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/2014) 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/2014) 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

FieldDescription
torecipient to which the email was sent, SQL wildcards allowed
cccopy recipient to which the email was sent, SQL wildcards allowed
bccblind copy recipient to which the email was sent, SQL wildcards allowed
senderJIRA username or email address of the sender
dateFromdate in format of dd/MM/yyyy (as 31/03/2014) or durations like 5d or 3h, etc.
dateTodate in format of dd/MM/yyyy (as 31/03/2014) or durations like 5d or 3h, etc.
source
  • OPERATION: email sent manually
  • BULK: email sent in bulk operation

  • EVENT: email sent by JETI event notification

  • WORKFLOW: email sent by JETI postfunction

  • AUTOREPLY: email sent as autoreply for an incoming email
subjectsubject of the email that was sent, SQL wildcards accepted
issuekey of the issue that was sent
  • 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)

Examples

ExampleWhat it finds
issue in sentInEmail( "john@company.com")issues that were sent to john@company.com (either to or cc or bcc)
issue in sentInEmail("to=john@company.com, sender=awilson, dateFrom=22/04/2014, dateTo=5d")issues that were sent by user "awilson", to john@company.com, between April 22, 2014 and 5 days ago.
issue in sentInEmail( "to=john@company.comcc=anne@mycompany.combcc=projectemailaddress@mycompany.com, sender=awilson, dateFrom=22/04/2014, dateTo=-5d, source=OPERATION")issues that were sent by user "awilson", to john@company.com, copied to anne@mycompany.com, bcced to projectemailaddress@mycompany.com, between April 22, 2014 and 5 days ago, manually.
issue in sentInEmail( "issue=FOO-13")issue FOO-13 if it was sent
  • No labels