How to use JQL queries as Dashboard filters?

We are excited to announce that the VIEW app now supports limited JQL (Jira Query Language) queries in VIEW filters. This BETA feature allows users to use JQL statements for quick filtering of the data displayed in the VIEW.

How to Use Limited JQL in VIEW Global Filters

To utilize limited JQL queries in VIEW global filters, follow these steps:

1. Navigate to VIEW

   • Go to the desired VIEW and select advanced in the filter panel

2. Enter Your JQL Query:

   • Type your JQL query into the input field. For example:

     project = "VIEW26" AND issuetype = "Bug" AND status = "Open"

3. Apply the Filter:

   • Click on the "Apply " button to execute the JQL query and update the displayed data.

JQL Queries

While we aim to support a wide range of JQL queries, there are currently some limitations. Below is a list of supported and unsupported JQL functionalities:

Supported JQL Queries:

• Basic field searches (e.g., project = "VIEW26")

• Status searches (e.g., status = "Open")

• Issue type searches (e.g., issuetype = "Bug")

• Assignee searches (e.g., assignee = "john.doe")

• JQL Keywords: All.

• JQL Operators: All except CONTAINS (~), DOES NOT CONTAIN (!~), WAS, WAS IN, WAS NOT IN, WAS NOT & CHANGED.

• JQL fields: All except Approvals, Attachments, Comment, Description, Issue link, Issue link type, Last viewed, Request type, SLA, Text, Time spent & Worklog comment.

  • For fields like Created, Due etc with Field Type as Date only “yyyy-mm-dd“ format is supported.

  • For Priority field only =, !=, IS, IS NOT, IN, NOT IN are supported.

Unsupported JQL Queries:

• Advanced JQL functions (e.g., membersOf("developers"))

• Historical searches (e.g., status was "In Progress")

• Custom fields not indexed for JQL (e.g., certain add-on custom fields)

• Subqueries (e.g., nested queries with parentheses)

• Text searches with wildcards (e.g., summary ~ "test*")

• Advanced JQL operators ( e.g WAS, WAS IN, WAS NOT IN, WAS NOT, CHANGED)

Examples of JQL Queries

Here are a few examples of how you can use JQL queries in VIEW global filters:

1. All open bugs in the VIEW26 project:

   project = "VIEW26" AND issuetype = "Bug" AND status = "Open"

2. Issues assigned to a specific user:

   assignee = "john.doe"

3. Tasks in a specific sprint:

   Sprint = "Sprint 10" AND issuetype = "Task"

Troubleshooting

If you encounter any issues while using JQL queries in VIEW global filters, please contact our support team at support@view26.com.