Daniel Turczanski - JQL Search Extensions Atlassian Partner

Hi @Mike_Hermann It's been a while but I think it may be helpful to people who are still looking for a cloud solution. You can consider using our professional indexing service * JQL Search Extensions After you install the app you can find issues from a previous sprint: issue in previousSprint("My board") Make sure to check…

To find the issues added after the sprint has started, you can consider using our professional indexing service: * JQL Search Extensions After you install the app you can find out what issues were added after the sprint started: issue in addedToSprintAfterStart("My board", "Sprint 5") Make sure to check out the…

Hi @Surya RK You can consider using our professional indexing service * JQL Search Extensions After you install the app you can find out what issues were added after the sprint started: issue in addedToSprintAfterStart("My board", "Sprint 5") Make sure to check out the documentation. I hope it helps!

Hi @True Indian Some good answers here already. You can also consider using our professional indexing service * JQL Search Extensions After you install the app you can find out what issues were added after the sprint started: issue in addedToSprintAfterStart("My board", "Sprint 5") Make sure to check out the documentation.…

Hi @marta eaton , Standard JQL doesn't easily allow searching for exact words, special phrases and patterns. You may consider using our professional indexing service: * JQL Search Extensions After you install the app you can simply search: issue in wildcardMatch("labels", "CR*") Check out the documentation for more…

Hi @Frederick Boudreau , Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search Extensions After you install the app you can simply search: JIRA DC/SERVER issue in epicOf("issuetype = Story and assignee=currentUser()") JIRA CLOUD: issue in…

Hi @David Booth , With standard JQL you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search Extensions After…

Hi @Martin Denham , With standard JQL you can only get a list of epics in the project and then run another search for all issues with the epic links returned by the first query. This only works if you want to do a one-off analysis. Standard JQL doesn't easily allow it but the results can be quickly found using our…

Ah yes, hi! 👋 Glad to see you in the forum :)

@cathyyou may find my answer helpful https://community.atlassian.com/t5/Jira-questions/JQL-query-to-find-child-issues-of-Initiative/qaq-p/461409#M497045

Hi @Abhi Singh , please upvote my answer if you find it helpful: https://community.atlassian.com/t5/Jira-questions/JQL-query-to-find-child-issues-of-Initiative/qaq-p/461409#M497045 Thanks!

Hi everyone, CC: @cathy @Abhi Singh In Jira Cloud you can currently find the children of initiative by specifying the issue key: issuekey in portfolioChildIssuesOf(MYKEY-1) You can specify multiple keys by duplicating the above query and connecting the queries with OR. To get children of initiatives based on more advanced…

Hi @Colum McAndrew , Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search Extensions After you install the app you can simply search: attachmentContent ~ "my text" Make sure to check the documentation. I hope this helps! Danie

Hi @Excelity , With standard JQL you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. Your use case is more dynamic than that. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: *…

Hi @Natasha Bartholomusz , With standard JQL you can specify the issue keys and find their links. You can also use multiple keys by connecting the clauses with OR. To query for links with nested JQL consider using our professional indexing service: * JQL Search Extensions After you install the app you can simply search:…

Hi @Koen Bruggeman , Standard JQL doesn't easily allow to search for a text with special phrases. You may consider using our professional indexing service: * JQL Search Extensions After you install the app you can simply search: issue in wildcardMatch("Organizations", "BE_*") Check out the docs for more information. I hope…

Hi @Siddharth Singhal , You can find tickets that were not commented in the last 2 days with our indexing service * JQL Search Extensions After you install the app you can create a filter "commented in the last 2 days": commentsCount > 0 AND commentedOnDate > -2d Then you can create a JQL query that returns the tickets…

Hi @Meytal BM , As Piotr has pointed out, standard JQL doesn't easily allow to search for a text with special phrases. You may consider using our professional indexing service: * JQL Search Extensions After you install the app you can simply search: issue in wildcardMatch("Department[Short text]", "*IS*") Check out the…

Hi @Darrel Jackson I can see you probably found a few workarounds already but if you're looking for solutions to improve your Advanced Roadmaps reporting you can consider using our indexing service * JQL Search Extensions The app makes it possible to list issues that belong to a certain hierarchy, even recursively. These…

Hi @Jana Csincsíková , Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search Extensions After you install the app you can simply search: movedProjects in ("SEARCH", "DATA") movedProjectsCount >= 2 You may want to check out the docs as well. I hope…

Hi @tayyaba , It looks like you're interested in seraching by remote links. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search Extensions After you install the app you can simply search: remoteLinkApplicationName="Confluence" You may want to check…

Hi, With standard JQL you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search Extensions After you install…

Hi @Svetlana Kom , With standard JQL you can only get a list of issues with summaries and export them to Excel for further processing. This works if you want to do a one-off analysis. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search Extensions…

Hi With standard JQL you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. Your use case is more dynamic than that. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service: * JQL Search…

Hi @Natasha Cronen , Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service. If you are still looking for a solution you can check out: * JQL Search Extensions After you install the app you can simply search: assignee = ncronen OR issue in…

Hi @Thomas Fritzen You can search for issues that have a link of type "covered by" linkType="covered by" and display the linked issues column in Jira search. You'll be able to see the linked issue keys without any other additional information. This answer explains how to use Google sheets to generate reports with more…

Hey everyone, If you have a strong requirement to get the subtasks that are in the sprint you may consider our indexing service: * JQL Search Extensions Your query will look like this: sprint = "sprint" OR issue in subtasksOfParentsInQuery("sprint = 'sprint'") You can read more in the docs. I hope it's helpful to people…

Nice one, any plans of making it available in Advanced Search outside of project view?

@Kristina Leclerc Tests should be linked to requirements issues with standard Jira links. You can find issues that are linked to your epic with: issue in linkedIssues("MYEPIC-123", "is covered by") If you only have a handful of issue keys you want to check this search should work just fine but if you have more advanced use…

@Rawan Bardini yes you're right. This is a link to the server/DC docs. I'll post another answer