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
| Field | Description |
|---|---|
| to | recipient to which the email was sent, SQL wildcards allowed |
| cc | copy recipient to which the email was sent, SQL wildcards allowed |
| bcc | blind copy recipient to which the email was sent, SQL wildcards allowed |
| sender | Jira username or email address of the sender |
| dateFrom | date in format of dd/MM/yyyy (as 31/03/2014) or durations like 5d or 3h, etc. |
| dateTo | date in format of dd/MM/yyyy (as 31/03/2014) or durations like 5d or 3h, etc. |
| source |
|
| subject | subject of the email that was sent, wildcards accepted |
| issue | key 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
| Example | What 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.com, cc=anne@mycompany.com, bcc=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 |