---
title: "JQL aliases and functions (reference)"
canonical: "https://support.appfire.com/space/JQLSEARCH/604212489/JQL%20aliases%20and%20functions%20(reference)"
format: markdown
---
> ❌ The instructions on this page may be out of date and this page is kept in place only as a historical reference.
> ❌ 
> ❌ Please go to to the new documentation page to see the newest JQL aliases and functions:
> ❌ 
> ❌ 👉 [https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209395](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209395) 👈



> ℹ️ The instructions on this page describe how to execute a JQL search using extensions from [JQL Search Extensions](https://marketplace.atlassian.com/plugins/jql-extensions/cloud/overview).
> ℹ️ 
> ℹ️ **JQL aliases** added by the app are accessible from Jira [advanced search](https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-764478330.html). **JQL functions** are accessible from [Extended Search](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209464) screen or via [Extended Search filters](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209567) in Jira advanced search.

  


# JQL aliases

## Searching for attachments

### 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 |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**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 |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**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 |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**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:

- [Note on aggregation of dates](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-aggregation-of-dates)
- [Note on dates with timestamps](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-dates-with-time)


**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**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 |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**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 |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues with an attachment name containing "screenshot". 

```
attachmentName ~ "screenshot"  
```

  


## Searching for subtasks

### ParentSummary

Search for subtasks with a parent's summary containing a particular text. 

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find subtasks which parents summary contains text "Test"

```
parentSummary ~ "Test"  
```


### ParentPriority

Search for subtasks with a parent of a particular Priority.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find subtasks which parent is of a "Blocker" priority. 

```
parentPriority = Blocker
```


### ParentIssueType

Search for subtasks with a parent of a particular Issue Type.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find subtasks with a parent of issue type "Test".

```
parentIssueType = "Test"
```


### ParentStatus

Search for subtasks with a parent of a particular Status.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find subtasks with a parent which is "In Progress". 

```
parentStatus = "In Progress"
```


### ParentStatusCategory

Search for subtasks with a parent of a particular Status Category.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find subtasks with a parent in "To Do" status category.

```
parentStatusCategory= "To Do"
```

  


## Searching for issues with subtasks 

### SubtasksCount

Search for issues that have a particular number of subtasks. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues with subtasks

```
subtasksCount > 0 
```


### SubtaskSummary

Search for issues that have subtasks where summary contains particular text. 

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues which subtasks summary contains text "Test"

```
subtaskSummary ~ "Test"  
```


### SubtaskKey

Search for issues that have subtasks with a particular key. 

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues with subtask with key ABC-123

```
subtaskKey = ABC-123
```


### SubtaskPriority

Search for issues that have subtasks with a particular Priority.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues with subtasks which have a "Blocker" priority. 

```
subtaskPriority = Blocker
```


### SubtaskIssueType

Search for issues that have subtasks with a particular Issue Type.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues with subtasks of issue type "Test".

```
subtaskIssueType = "Test"
```


### SubtaskStatus

Search for issues that have subtasks with a particular Status.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues which have subtasks "In Progress". 

```
subtaskStatus = "In Progress"
```


### SubtaskStatusCategory

Search for issues that have subtasks with a particular Status Category.

**SUPPORTED OPERATORS ** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues which have "To Do" status category.

```
subtaskStatusCategory = "To Do"
```

  


## Searching for comments 

### CommentsCount

Search for issues that have a particular number of comments. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues with comments

```
commentsCount > 0 
```


### CommentedByUser

Search for issues that were commented by a particular user. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were commented by Jane Potter. 

```
commentedByUser = "Jane Potter"
```


### CommentLastCreatedBy

Search for issues that were last commented by a particular user. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were last commented by admin. 

```
commentLastCreatedBy= "admin"
```


### CommentLastUpdatedBy

Search for issues with a comment last updated by a particular user. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues with a comment last updated by admin. 

```
commentLastUpdatedBy= "admin"
```


### CommentedOnDate

Search for issues which were commented on a particular date. This keyword works with date related JQL functions:

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

Also see:

- [Note on aggregation of dates](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-aggregation-of-dates)
- [Note on dates with time](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-dates-with-time)


**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were commented on 13th or 14th of March, 2016

```
commentUpdatedDate >= "2016/03/13" AND commentUpdatedDate < "2016/03/15"
commentedOnDate < now()
```


### CommentedUpdatedOnDate

Search for issues which comment was updated on a particular date. This keyword works with date related JQL functions:

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

Also see:

- [Note on aggregation of dates](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-aggregation-of-dates)
- [Note on dates with time](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-dates-with-time)


**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues with comments updated on 13th or 14th of March, 2016

```
commentUpdatedDate >= "2016/03/13" AND commentUpdatedDate < "2016/03/15"
commentUpdatedDate < now()
```


### CommentLastCreatedOnDate

Search for issues which were last commented on a particular date. This keyword works with date related JQL functions:

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

Also see:

- [Note on dates with time](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-dates-with-time)


**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were commented more than 2 days ago:

```
commentLastCreatedOnDate < -2d
```


### CommentLastUpdatedOnDate

Search for issues with comments updated on a particular date. This keyword works with date related JQL functions:

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

Also see:

- [Note on dates with time](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-dates-with-time)


**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were commented more than 2 days ago:

```
commentLastUpdatedOnDate < -2d
```


## Searching for versions

### AffectedVersionsArchived 

Search for issues with [affected version archived](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which affected version is archived 

```
affectedVersionsArchived > 0
```


### AffectedVersionsReleased

Search for issues with [affected version released](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which affected version is released.

```
affectedVersionsReleased > 0
```

Find issues which no affected version is released. 

```
affectedVersionsReleased = 0
```


### AffectedVersionsOpened

Search for issues with [affected version opened](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which affected version is opened. 

```
affectedVersionsOpened > 0
```


### AffectedVersionsCount

Search for issues with a particular number of [affected versions](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which have affected versions. 

```
affectedVersionsCount > 0
```


### AffectedVersionReleaseDate

Search for issues which affected version was released on a particular date. This keyword works with date related JQL functions:

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

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which affected version was released on 13th or 14th of March, 2016

```
affectedVersionReleasedDate = "2016/03/14" OR affectedVersionReleasedDate = "2016/03/13"
affectedVersionReleasedDate in ("2016/03/14", "2016/03/13")
affectedVersionReleasedDate < now()
```


### FixVersionsArchived

Search for issues with [fix version archived](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which affected version is archived 

```
fixVersionsArchived > 0
```


### FixVersionsReleased

Search for issues with [fix version released](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which fix version is released.

```
fixVersionsReleased > 0
```

Find issues with no fix version released. 

```
fixVersionsReleased = 0
```


### FixVersionsOpened

Search for issues with [fix version opened](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which fix version is opened. 

```
fixVersionsOpened > 0
```


### FixVersionsCount

Search for issues with a particular number of [fix versions](https://confluence.atlassian.com/jira/managing-versions-185729543.html). 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which have fix versions.

```
fixVersionsCount > 0
```


### FixVersionReleaseDate

Search for issues which fix version was released on a particular date. This keyword works with date related JQL functions:

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

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which fix version was released on 13th or 14th of March, 2016

```
fixVersionReleaseDate = "2016/03/14" OR fixVersionReleaseDate = "2016/03/13"
fixVersionReleaseDate in ("2016/03/14", "2016/03/13")
fixVersionReleaseDate < now()
```


## Searching for links

### LinksCount

Search for issues with a particular number of links. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which have links. 

```
linksCount > 0
```


### LinkedBy

Search for issues that are linked by particular issues. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were linked by JQL-3 or JQL-5. 

```
linkedBy in (JQL-3, JQL-5)
```


### LinksIssue

Search for issues which links a particular issue. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which link JQL-3 or JQL-5

```
linksIssue in (JQL-3, JQL-5)
```


### LinkType

Search for issues which have a particular link type. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find all issues which are blocked by another issue

```
linkType = "is blocked by"
```


### LinkedIssueStatus

Search for issues which are linked or link issues with a particular status. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find all issues which are linked by issues in "To Do" status. 

```
linkedIssueStatus = "To Do"
```


### LinkedIssueStatusCategory

Search for issues which are linked or link issues with a particular status category. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find all issues which are linked or link issues in status category "Done"

```
linkedIssueStatusCategory = Done
```


### LinkedIssueType

Search for issues which are linked or link issue with a particular issue type. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find all issues which are linked by Bugs. 

```
linkedIssueType = Bug
```


### LinkedIssuePriority

Search for issues which are linked or links issues with a particular priority. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find all issues which are linked by high priority issues.

```
linkedIssuePriority = "High"
```


### LinksIssuesCount

Search for issues which link to a particular number of issues. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which link more than 5 issues.

```
linksIssuesCount > 5
```


### LinkedByIssuesCount

Search for issues which are linked by a particular number of issues. 

**SUPPORTED OPERATORS** 

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES** 

Find issues which are linked by more than 10 issues. 

```
linkedByIssueCount > 10 
```


### LinkedByIssueProject

Search for issues which are linked by issues from a particular project. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find all issues which are linked by issues from project JQL

```
linkedByIssueProject = JQL
```


### LinksIssueProject

Search for issues which link to issues from a particular project. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find all issues which link to issues from project JQL

```none
linksIssueProject= JQL
```



## Searching for remote links

> 📝 Remote links are now called *web links* in the Jira user interface.

### RemoteLinkUrl

Search for issues which contain the remote link with the URL.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which contain both URLs:

```
remoteLinkUrl in ("http://digitaltoucan.com/our-products/jql-search-extensions/", "https://google.com")
```


### RemoteLinkUrlPartialMatch

Like remoteLinkUrl but supports partial match. All the slashes are replaced with spaces. Words match will differ depending on your [word stemming](https://confluence.atlassian.com/jirasoftwarecloud/search-syntax-for-text-fields-764478343.html#Searchsyntaxfortextfields-stemmingWordstemming) configuration in Jira.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which contain digitaltoucan in the URL.

```
remoteLinkUrlPartialMatch ~ digitaltoucan
```


### RemoteLinkApplicationName

Search for issues which contain the remote link to an application like Confluence.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which link to confluence:

```
remoteLinkApplicationName="Confluence"
```


### RemoteLinkApplicationType

Similar to remoteLinkApplicationName but matches the application identifier.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which link to confluence:

```
remoteLinkApplicationType="com.atlassian.confluence"
```


### RemoteLinkHost

Matches the host part of the remote link.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which link to [jqlsearchextensions.atlassian.net](http://jqlsearchextensions.atlassian.net/):

```
remoteLinkHost="jqlsearchextensions.atlassian.net"
```


### RemoteLinkQuery

Matches the query part of the remote link.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which link to URLs like [http://host.com/path?pageId=1234](http://host.com/path?pageId=1234)

```
remoteLinkQuery="pageId=1234"
```


### RemoteLinkPath

Matches the path part of the remote link.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which link to URLs like [http://host.com/path?pageId=1234](http://host.com/path?pageId=1234)

```
remoteLinkPath="/path"
```


### RemoteLinkTitle

Find issues with a remote link title

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues with title My Page

```
remoteLinkTitle="My Page"
```


### RemoteLinkTitlePartialMatch

Find issues that contain text in the remote link title. Words match will differ depending on your [word stemming](https://confluence.atlassian.com/jirasoftwarecloud/search-syntax-for-text-fields-764478343.html#Searchsyntaxfortextfields-stemmingWordstemming) configuration in Jira.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which contain Digital Toucan in the remote link title:

```
remoteLinkTitlePartialMatch ~ "Digital Toucan"
```


### RemoteLinkRelationship

Find issues with a remote link of a particular type.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues with that were mentioned in Confluence.

```
remoteLinkRelationship="mentioned in"
```


### RemoteLinksCount

Search for issues that contain a particular number of remote links.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues with more than 5 remote links:

```
remoteLinksCount > 5
```

  


## Searching for updates and time logs

### UpdatedByUsersCount

Search for issues which were updated by a particular number of users. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues updated by more than 5 users. 

```
updatedByUsersCount > 5
```


### UpdatedBy

Search for issues which were updated by a particular user/users. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were updated by Helen or Daniel:

```
updatedBy in ("helen", "daniel")
```


### TransitionedBy

Search for issues which were transitioned by a particular user/users. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were transitioned by Helen or Daniel:

```
transitionedBy in ("daniel", "helen")
```


### LoggedTimeBy

Search for issues on which particular users reported time. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues on which Helen or Daniel reported time. 

```
loggedTimeBy in ("daniel", "helen")
```


### UpdatedOnDates

Search for issues which were updated on a particular date. This keyword works with date related JQL functions:

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

Also see:

- [Note on aggregation of dates](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-aggregation-of-dates)
- [Note on dates with time](https://jqlsearchextensions.atlassian.net/wiki/spaces/JQLSEARCH/pages/3375124/JQL%2Baliases%2Band%2Bfunctions%2Breference#Note-on-dates-with-time)


**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were updated on 13th or 14th of March, 2016

```
updatedOnDates in ("2016/03/14", "2016/03/13")
updatedOnDates < now()
```


### LastUpdatedBy

Search for issues that were last updated by a particular user. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues that were last updated by admin. 

```
lastUpdatedBy="admin"
```

  


## Searching for projects 

### MovedProjects

Search for issues which were moved between projects. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which belonged to a different project and were moved. For instance, the following query finds issues which were in projects SEARCH and DATA. 

```
movedProjects in ("SEARCH", "DATA")
```

**Warning: **Due to Jira plugin system limitation it is impossible to build a command which supports searching from/to. The query will find all issues which were in SEARCH or DATA at some point. 


### MovedProjectsCount

Search for issues which were moved between a number of projects. 

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

Find issues which were moved between 2 or more projects. 

```
movedProjectsCount >= 2
```

  


## Searching for field comparisons

### HasSameUpdatedAndCreatedDate

Search for issues which were not updated since creation

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

```
hasSameUpdatedAndCreatedDate = "true"
```


### HasSameAssigneeAndReporter

Search for issues with the same assignee and reporter

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

```
hasSameAssigneeAndReporter = "true"
```


### HasSameVersions

Search for issues with the same fix and affected versions.

**SUPPORTED OPERATORS **

| = | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

**EXAMPLES**

```
hasSameVersions = "true"
```

  


## Epic 

The following JQL extensions work on epics only

- **issuesInEpicCount** - search for epics with a particular number of child issues regardless of issue type
- **bugsInEpicCount** - search for epics with a particular number of bugs
- **storiesInEpicCount** - search for epics with a particular number of stories** **
- **issuesInEpicToDoCount** - search for epics with a particular number of child issues in "To Do" status category
- **issuesInEpicInProgressCount** - search for epics with a particular number of child issues in "In Progress" status category
- **issuesInEpicDoneCount** - search for epics with a particular number of child issues in "Done" status category
- **bugsInEpicToDoCount** - search for epics with a particular number of bugs in "To Do" status category
- **bugsInEpicInProgressCount** - search for epics with a particular number of bugs in "In Progress" status category
- **bugsInEpicDoneCount** - search for epics with a particular number of bugs in "Done" status category
- **storiesInEpicToDoCount** - search for epics with a particular number of stories in "To Do" status category
- **storiesInEpicInProgressCount** - search for epics with a particular number of stories in "in Progress" status category
- **storiesInEpicDoneCount** - search for epics with a particular number of stories in "Done" status category

## Note on aggregation of dates

In case there are more than 100 timestamps to be stored for a particular date related JQL keyword the timestamps will be aggregated by day with time reset to start of the day (midnight). This means that the keyword won't be time sensitive, it will only be date sensitive for a particular Jira issue. 

This applies to the following keywords: 

- **attachedOnDate**
- **updatedOnDates**
- **commentedOnDate**
- **commentUpdatedDate **

For example if the issue was updated 150 times over a course of 5 days, the updatedOnDates queries for that particular issue will see 5 timestamps for each day only.

## Note on dates with time

Most Jira date fields also contain the time component. Jira doesn’t currently support convenient use of `=` and `IN` operators with timestamps. You should use the comparison operators instead: `<`, `<=`, `>`, `>=`

The following JQL aliases contain timestamps:

- **attachedOnDate**
- **updatedOnDates**
- **commentedOnDate**
- **commentUpdatedDate **

For example, this query fails to find issues  commented on a particular day:   
`commentedOnDate="2020/06/01"`   
Jira returns an empty result even if there are issues that were commented on 1 June.

The workaround is to search for the range of dates:   
`commentedOnDate>="2020/06/01" AND commentedOnDate<"2020/06/02"`  
Jira returns issues that were commented between midnight 1 June and midnight 2 June.