...
| Excerpt | ||
|---|---|---|
| ||
 |
Overview
Teams have their own key insights for their Jira Software projects, agents need specific answers to be solved for their Jira Service Management queues, and so on and so forth. You could name more examples where a user need to perform a different query to search in Jira for relevant information. That’s why the Jira Query Language (JQL) was built for. It’s a powerful search based on clauses (field + operator + value) to return a list of issues, which for the sake of reuse, can be saved as filters. Projects in Jira require enough information to properly track their status and control a successful result. For doing so, Projectrak by DEISER provides a unique solution to add custom fields to projects, making data annotation a simple and smooth process. Review all the benefits that this app brings, like predefine fields ready right after installing it; the list view of projects to see your portfolio information at a glance; the release view to keep your version planning visible for all stakeholders, etc.
This gadget displays the result of a JQL PQL query or an existing filter, as a table or a chart. Select a predefined filter or Indicate a custom JQL Select filter or custom JQLPQL, then indicate the how you want to display the results View Type, the Columns you want to display in your report in case of a table (drag and drop to change the order), and performing grouping and/or aggregations (see next sections for further information).
Projectrak provides the Project Query Language (PQL), which is like the Jira Query Language (JQL), but to query data from your projects.
For example, to list all the issues projects in the “Teams in Space” project (project = “TIS”) and still pending to do (status = "TO DO") sorted by CreationDate in descending order (ORDER BY created DESC) you’ll type the following JQL query
project = "TIS" AND status = "TO DO" ORDER BY created DESC
Get started with JQL or have a look to the Advanced Search to master queries in Jirathe software category where the Country is Germany or the Continent is Europe, then use the following PQL query:
category = development AND ( Country = Germany OR Continent = Europe )
You can select any of the following visual metaphors to represent the resulted data by the JQL in the View Type field: Table, line chart, tile chart, pie chart, bar chart, grouped bar chart, stacked bar chart or multi line chart.
...