Month: September 2023

In Jira we have the concept of Sprints and Versions. We've already covered Using Jira JQL to Search for Issues in a Sprint. In this post we look at JQL statements and functions you can use to search based on Versions. A Version in Jira is a milestone in your project. Think of it as a 'name' that points to a snapshot of something you want to release. Usually we'll have two version fields 1. Affects Version – the version of the app/product where we found the issue 2. Fix Version – the version of the app/product where we included the fix for the issue You may need to configure your issue layout to show both of these fields. If...

Let's take a look at using date fields and operators with Jira's query language. There are a few 'gotchas' to watch out for when using date values. Having said that there are also some really useful functions that will help you identify exactly what you need from your date based JQL queries Now the most straight forward example is something along the lines of project = "DX" and createdDate > 2023-7-03 Important to take into account that “greater than” is taken as the start of day 23-08-03. Jira JQL with Dates So really this query really means project = "DX" and createdDate >= 2023-07-03 For clarity and to avoid confusion sometimes it's better to work with times as well. Adds...

Usually everything you do in Jira is orientated around a sprint. Your current sprint. Or perhaps even a past sprint or a future sprint. In which case you're going to come up against scenarios where you need a neat list of issues related to a sprint. In this post we look at three Jira JQL functions that you can use to help you search for issues in a particular sprint. If you're looking to find a list of issues that are related in some way to a particular sprint then we need to delve into a few JQL functions. Fundamentally an issue can be in Future Sprints, Open Sprints and Closed Sprints. The Backlog view will show us the Open...

In this post we show you how to use Jira's advanced JQL language to search for related issues. Often in Jira you'll want to search and find issues that are related to another issue. Perhaps you have Child issues or Linked issues for a particular issue you're working on. You just need to list, in the search results, all these related issues. In Jira there are two ways to relate issues to each other… Two Ways to Relate Issues 1. parent / child – created with the 'Add a child issue' feature2. linked issues – created with the 'Link Issue' feature In our example above we have an Epic (issue key SCR-26) that has both child issues AND linked issues....