This app provides more powerful queries while searching issues or making filters. With the help of this app, managers could get more powerful reports by using filters and could optimize their workload.
Here is an example of a searching issue with the last commented by "Skywalker". It is shown in the screenshot.
You can find the query reference at the bottom of the page and also you can use the table of content in the below.
Find issues according to the number of attachments.
Query | Supported Operators |
---|---|
attachmentsCount | = , != , < , > , <= , >= |
Example:
Find issues having attachments:
1 | attachmentsCount > 0 |
---|
Find issues that have an attachment according to a file name.
Query | Supported Operators |
---|---|
attachmentFileName | ~ , !~ , is , is not |
Example:
Find issues that have an attachment whose name is "document".
1 | attachmentsFileName ~ "document" |
---|
Find issues that have an attachment added by a particular user
Query | Supported Operators |
---|---|
attachedByUser | = , != , is , is not , in , not in |
Example:
Find issues that have an attachment added by "Luke Skywalker".
1 | attachedByUser = "Luke Skywalker" |
---|
Find issues that have an attachment added by a particular user. This query provides a partial match on the name of
the user.
Query | Supported Operators |
---|---|
attachedByUserFullName | ~ , !~ , is , is not |
Example:
Find issues that have an attachment added by "Luke".
1 | attachedByUserFullName ~ "Luke" |
---|
To search for issues according to attachment number.
Query | Supported Operators |
---|---|
attachedOnDate | endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear() |
Example:
Find issues that attachment has been added in this year.
1 | attachedOnDate > startOfYear() |
---|
To search for issues according to attachment size. (in MB)
Query | Supported Operators |
---|---|
attachmentSize | = , != , < , > , <= , >= |
Example:
Find issues with attachments whose size are bigger than 1 MB.
1 | attachmentSize > 1 |
---|
Find issues that have an attachment according to a file extension.
Query | Supported Operators |
---|---|
attachmentExtension | = , != , is , is not , in , not in |
Example:
Find issues with attachments with "PNG" extension.
1 | attachmentExtension = "PNG" |
---|
Find issues according to the number of comments.
Query | Supported Operators |
---|---|
commentsCount | = , != , < , > , <= , >= |
Example:
Find issues having comments:
1 | commentsCount > 0 |
---|
Find issues that have a comment added by a particular user
Query | Supported Operators |
---|---|
commentedByUser | = , != , is , is not , in , not in |
Example:
Find issues that have a comment added by "Luke Skywalker".
1 | commentedByUser = "Luke Skywalker" |
---|
Find issues that have a comment added by a particular user. This query provides a partial match on the name of
the user.
Query | Supported Operators |
---|---|
commentedByUserFullName | ~ , !~ , is , is not |
Example:
Find issues that have a comment added by "Luke".
1 | commentedByUserFullName ~ "Luke" |
---|
To search for issues according to comment added date.
Query | Supported Operators |
---|---|
commentedDate | endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear() |
Example:
Find issues with comments that added today.
1 | commentedDate >= startOfDay() |
---|
To search for issues according to comment edited date.
Query | Supported Operators |
---|---|
commentedUpdatedDate | endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear() |
Example:
Find issues with comments that edited today.
1 | commentedUpdatedDate >= startOfDay() |
---|
Find issues that have the last comment added by a particular user
Query | Supported Operators |
---|---|
lastCommentedByUser | = , != , is , is not , in , not in |
Example:
Find issues that have the last comment added by "Luke Skywalker".
1 | lastCommentedByUser = "Luke Skywalker" |
---|
Find issues that have the last comment added by a particular user. This query provides a partial match on the name of
the user.
Query | Supported Operators |
---|---|
lastCommentedByUserFullName | ~ , !~ , is , is not |
Example:
Find issues with commented by "luke" lastly:
1 | lastCommentedByUserFullName ~ "Luke" |
---|
Find issues according to the number of links.
Query | Supported Operators |
---|---|
linksCounts | = , != , < , > , <= , >= |
Example:
Find issues with links:
1 | linksCount > 0 |
---|
Find issues that link to a particular issue.
Query | Supported Operators |
---|---|
linksIssue | = , != , is , is not , not in , in |
Example:
Find issues that link to "DEV-2":
1 | linksIssue = "DEV-2" |
---|
Find issues that are linked by a particular issue.
Query | Supported Operators |
---|---|
linkedBy | = , != , is , is not , not in , in |
Example:
Find issues that are linked by "TEST-2":
1 | linkedBy = "TEST-2" |
---|
Find issues that are linked according to link type.
Query | Supported Operators |
---|---|
linkedType | = , != , is , is not , not in , in |
Example:
Find issues that are linked whose type is "is blocked by":
1 | linkedType = "is blocked by" |
---|
Find issues that link according to link type.
Query | Supported Operators |
---|---|
linksType | = , != , is , is not , not in , in |
Example:
Find issues that link whose type is "blocks":
1 | linksType = "blocks" |
---|
Find issues that are linked according to linked issue status.
Query | Supported Operators |
---|---|
linkedIssueStatus | = , != , is , is not , not in , in |
Example:
Find issues that are linked whose issue status is "Open":
1 | linkedIssueStatus = "Open" |
---|
Find issues that link according to link issue status.
Query | Supported Operators |
---|---|
linksIssueStatus | = , != , is , is not , not in , in |
Example:
Find issues that link whose issue status is "Open":
1 | linksIssueStatus = "Open" |
---|
Find issues that are linked according to linked issue status category.
Query | Supported Operators |
---|---|
linkedIssueStatusCategory | = , != , is , is not , not in , in |
Example:
Find issues that are linked whose issue status category is "In Progress":
1 | linkedIssueStatusCategory = "In Progress" |
---|
Find issues that link according to link issue status category.
Query | Supported Operators |
---|---|
linksIssueStatusCategory | = , != , is , is not , not in , in |
Example:
Find issues that link whose issue status category is "In Progress":
1 | linkedIssueStatusCategory = "In Progress" |
---|
Find issues that are linked according to linked issue status type.
Query | Supported Operators |
---|---|
linkedIssueType | = , != , is , is not , not in , in |
Example:
Find issues that are linked whose issue type is "Sub-task":
1 | linkedIssueType = "Sub-task" |
---|
Find issues that link according to linked issue status type.
Query | Supported Operators |
---|---|
linksIssueType | = , != , is , is not , not in , in |
Example:
Find issues that link whose issue type is "Sub-task":
1 | linksIssueType = "Sub-task" |
---|
Find issues that are linked according to linked issue status priority.
Query | Supported Operators |
---|---|
linkedIssuePriority | = , != , is , is not , not in , in |
Example:
Find issues that are linked whose issue priority is "Medium":
1 | linkedIssuePriority = Medium |
---|
Find issues that link according to linked issue status priority.
Query | Supported Operators |
---|---|
linksIssuePriority | = , != , is , is not , not in , in |
Example:
Find issues that link whose issue priority is "Medium":
1 | linksIssuePriority = Medium |
---|
Find issues that link according to the number of links.
Query | Supported Operators |
---|---|
linksIssuesCount | = , != , < , > , <= , >= |
Example:
Find issues with outward link:
1 | linksIssuesCount > 0 |
---|
Find issues that are linked according to number of links.
Query | Supported Operators |
---|---|
linkedByIssuesCount | = , != , < , > , <= , >= |
Example:
Find issues with inward link:
1 | linkedByIssuesCount > 0 |
---|
Find issues according to the number of subtasks.
Query | Supported Operators |
---|---|
subTaskCounts | = , != , < , > , <= , >= |
Example:
Find issues with subtasks:
1 | subTaskCounts > 0 |
---|
Find issues according to a summary of a subtask.
Query | Supported Operators |
---|---|
subTaskSummary | ~ , !~ , is , is not |
Example:
Find issues with a summary of the subtask is "test is required":
1 | subTasksSummary ~ "test is required" |
---|
Find issues according to a key of a subtask.
Query | Supported Operators |
---|---|
subTaskKey | = , != , is , is not , in , not in |
Example:
Find issues with a key of the subtask is "TEST-1":
1 | subTaskKey = "TEST-1" |
---|
Find issues according to a priority of a subtask.
Query | Supported Operators |
---|---|
subTaskPriority | = , != , is , is not , in , not in |
Example:
Find issues with a priority of subtask is "Medium":
1 | subTaskPriority = "Medium" |
---|
Find issues according to an issue type of a subtask.
Query | Supported Operators |
---|---|
subTaskIssueType | = , != , is , is not , in , not in |
Example:
Find issues with an issue type of subtask is "Task":
1 | subTaskIssueType = "Task" |
---|
Find issues according to a status of a subtask.
Query | Supported Operators |
---|---|
subTaskStatus | = , != , is , is not , in , not in |
Example:
Find issues with an issue status of a subtask is "Open":
1 | subTaskStatus = "Open" |
---|
Find issues according to a status category of a subtask.
Query | Supported Operators |
---|---|
subTaskStatusCategory | = , != , is , is not , in , not in |
Example:
Find issues with an issue status category of a subtask is "To Do":
1 | subTaskStatusCategory = "To Do" |
---|
To search for issues according to the affected version number.
Query | Supported Operators |
---|---|
affectedVersionCount | = , != , < , > , <= , >= |
Example:
Find issues with affected version:
1 | affectedVersionCount > 0 |
---|
To search for issues according to affected version released or not.
Query | Supported Operators |
---|---|
affectedVersionReleased | = |
Example:
1 | affectedVersionRelased = "True" |
---|---|
2 | affectedVersionRelased = "False" |
To search for issues according to the affected version release date
Query | Supported Operators |
---|---|
affectedVersionReleasedDate | endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear() |
Example:
1 |
---|
To search for issues according to the affected version archived or not.
Query | Supported Operators |
---|---|
affectedVersionArchived | = |
Example:
1 | affectedVersionArchived = "True" |
---|---|
2 | affectedVersionArchived = "False" |
To search for issues according to fix version number.
Query | Supported Operators |
---|---|
fixVersionCount | = , != , < , > , <= , >= |
Example:
Find issues with fix version:
1 | fixVersionCount > 0 |
---|
To search for issues according to fix version released or not.
Query | Supported Operators |
---|---|
fixVersionReleased | = |
Example:
1 | fixVersionRelased = "True" |
---|---|
2 | fixVersionRelased = "False" |
To search for issues according to the fix version release date
Query | Supported Operators |
---|---|
fixVersionReleasedDate | endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear() |
Example:
1 |
---|
To search for issues according to fix version archived or not.
Query | Supported Operators |
---|---|
fixVersionArchived | = |
Example:
1 | fixVersionArchived = "True" |
---|---|
2 | fixVersionArchived = "False" |