Attachments

The examples on this page describe how to build a JQL search using JQL Search Extensions.

On this page: 1 Attachments JQL keywords 1.1 attachmentContent 1.2 attachmentsCount 1.3 attachedByUser 1.4 attachedOnDate 1.5 attachmentExtension 1.6 attachmentName

On this page: 1 Attachments JQL keywords 1.1 attachmentContent 1.2 attachmentsCount 1.3 attachedByUser 1.4 attachedOnDate 1.5 attachmentExtension 1.6 attachmentName

Attachments JQL keywords

attachmentContent

Search for issues with attachments containing the provided phrase. The search functionality will find the provided phrase in PDF, Word (doc, docx), PowerPoint (ppt, pptx), Excel (xls and xslx), OpenOffice, and PlainText.

It is not always possible to extract text from files. Complex PDFs and Excel files are the most problematic, however, in 99% of cases, indexing is successful.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

Find issues with attachments containing the phrase specification.

attachmentContent ~ "specification"

attachmentsCount

Search for issues that have a specific number of attachments.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

Find issues with attachments:

attachmentsCount > 0

attachedByUser

Search for issues with attachments added by a particular user.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

Find issues with attachments added by "Jane Potter".

attachedByUser = "Jane Potter"

attachedOnDate

Search for issues with attachments added on a particular date. This JQL keyword works with date-related JQL functions:

endOfDay()
endOfMonth()
endOfWeek()
endOfYear()
lastLogin()
now()
startOfDay()
startOfMonth()
startOfWeek()
startOfYear()

See also:

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

Find issues with attachments attached on particular dates.

attachedOnDate >= "2016/03/14" and attachedOnDate < "2016/03/15" 
attachedOnDate < now()

attachmentExtension

Search for issues with attachments with a particular extension.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

Find issues with attachments with PNG or JPG extensions.

attachmentExtension = "png" OR attachmentExtension = "jpg"

attachmentName

Search for issues with attachments with a particular name.

Supported operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

Find issues with an attachment name containing screenshot.

attachmentName ~ "screenshot"