Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×Hi Team We have a field labeled "Technical Product Owner" with a checkbox that can be marked as "Yes." However, when we try to filter the results, we get incorrect outcomes. We have over 1,000 ticke...
Hi, I want a dashboard with timespent by user but jql only get all time by issue. So Is possible without plugins? Thanks
Hi Everyone, I am new to Jira and I have had to learn JQL very fast. We have also migrated to the cloud. I have this JQL query working in the old Jira environment but not in the Cloud. I h...
Hello! I'm currently trying to gather metrics and would like to display monthly metrics for our tickets and the YTD of specific issue types. I tried to create a smart filter for the months but it's ...
...ueue JQL. Anyone dealt with the same issue and found a way to differentiate between languages in a queues JQL?
Hi I created a Kanban board with query-based swimlanes (component = ...). The problem is, when I have more than 1 components the ticket will show X times (X = number of components in ticket). I woul...
Hi, the engineers in my team are in different time zones, and I'm trying to filter out the tickets based on user time zone of ticket assignees, can JQL filter call the timezone from user?
...lease: Projectrak allows you to export project history from Jira to CSV. Simple and effective. Take advantage of project data with JQL Save time by searching for specific issues b...
Hi, atlassian community! Please i need your help !) How i can find issue from jql , witch in status = 7 day ? (no more and no less)
I regard Atlassian and Jira with equal parts admiration and frustrated irritation. This question is in the latter camp. Someone asked me how to show the number of issues at each status over the last...
在使用 Jira 进行项目管理时,你是否遇到过这些困扰: 想快速找出所有即将到期的任务,却要一个个翻看 需要统计团队成员的工作量,但不知从何下手 想追踪特定模块的事务,却无法精确筛选 如果你也有类似困扰,那么 JQL(Jira Query Language)正是你需要掌握的利器。今天就让我们一起来学习这个强大的查询工具! J...
Hi guys, Before, I ve used not status changed after -8h to find issue where status has been not changed for 8. But now, I need it is 8 working hours (8h30 - 12h and 13h30 - 17h30) Coul...
In a custom defined drop-down field, I had defined one of the options with a certain name 'ABC' which I later changed to 'XYZ'. After the change the JQL search to filter on this value is not r...
Hello, I am trying to create a "split process" of sorts in which: Person 1 submits a request type ticket creating Issue A. I then have an Automation which emails Person 2 with a direct link to com...
Hello I would like to create an advanced JQL to filter topics included in a sprint before it starts in order to trace the commitment given by team during sprint planning event. I know that I...
...hose tickets listed in linkedtype are of type Epic. I don't know if JQL is capable of finding this for me thank you in advance
...his with built in JQL but if there is an marketplace app, I would be happy to explore. If your recommending a marketplace app, please also include how you would use that app to accomplish not j...
Wondering if there's been a change to the JQL for a current Sprint? I've used this query for a while and lately it's telling me: "Your project and sprint selection are invalid" Q...
I'm trying to figure out HOw to gather data in a Dataplane Graph for: Time from Assigned to IN progress, where Assigning a person to an issue happens while the issue is in a Ready status This basica...
Hello, I am trying to send an alert filtered by jql to a slack channel and I have not been successful. Yes I do it in a basic way if it sends when a ticket is created, but in jql it does not a...
I'm confused by the difference between these two properties in JQL. As far as I know, there's only one due date per issue, and these are obviously not custom fields. Can someone t...
...ctual date well enough for use in automations: issue.customfield_12345.substring(29,39) Now, I want to create a JQL query to give me the set of issues with a due date this coming month. JQL doesn't s...
Hello, dear community! I need to search tickets that were resolved exactly 11 months ago. Can you give me, please?
...My question would be how can I provide each story to be on Gantt Chart? I tried to put JQL to separate two Gantt Chart by Stories to reduce the numbers of issues. But there are no JQL to s...
...filter with data from two different projects on the same line. This would be trivial in SQL but in JQL? Anyone would know by any chance?
Copied to clipboard