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
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
Last updated