Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

The

...

examples on this page describe how to

...

build a JQL search using JQL Search Extensions.

On this page:

Table of Contents
minLevel1
maxLevel7
excludeTry it free

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.

...

Info

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

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

...

Examples

Find issues with attachments containing the phrase

...

specification

...

Code Block
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

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

...

Examples

Find issues with attachments:

Code Block
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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

...

Examples

Find issues with attachments added by "Jane Potter". 

Code Block
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

(tick)

(tick)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error) 

...

Examples

Find issues with attachments attached on particular dates. 

Code Block
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

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(tick)

(tick)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

...

Examples 

Find issues with attachments with PNG

...

or JPG extensions. 

Code Block
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

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(tick)

(tick)

(error)

(error)

(error)

(error)

(error)

(error)

(error)

...

Examples 

Find issues with an attachment name containing

...

screenshot

...

Code Block
attachmentName ~ "screenshot"