Skip to end of banner
Go to start of banner

Attachments JQL functions

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

The instructions on this page describe how to execute a JQL search using JQL Search Extensions.

Attachments JQL Aliases

AttachmentContent

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

Please keep in mind that it is sometimes impossible to extract text from files. Complex PDFs and Excel files are the most problematic. Having said that in over 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". 

attachmentContent ~ "specification"


AttachmentsCount 

Search for issues that have a particular attachments number. 

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:

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". 

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()

Also see:

 

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. 

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 of 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

(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". 

attachmentName ~ "screenshot"  

  • No labels