Daniel Turczanski - JQL Search Extensions Atlassian Partner

Hi @Evert Morren, You can use JQL to match the issues. Standard JQL doesn't easily allow searching for exact words, special phrases and patterns. To get the wildcard support, use our professional indexing service JQL Search Extensions After you install the app, you can simply search: issue in wildcardMatch("description",…

Hi @Karthik Balasubramanian and @Hari Viswanathan, As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for. 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. If your use…

Hi @wonggoulney , 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 you can find the results quickly using our professional indexing service JQL Search Extensions After…

Hi @Janakiraman S , Standard JQL doesn't easily allow searching for exact words, special phrases and patterns. You may use our professional indexing service JQL Search Extensions After you install the app you can simply search: issue in wildcardMatch("country", "IT") Check out the docs for more information. I hope this…

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 you can find the results quickly using our professional indexing service JQL Search Extensions After you install the…

JQL filtering is powerful, but you can hit its limits in more complex workflows. You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations, and - you guessed it - text patterns.…

Hi @Álvaro Galvez Garrido , 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 you can find the results quickly using our professional indexing service: * JQL Search…

Hi @Ashish Bijlwan , Check out our app JQL Search Extensions. It has support of Advanced Roadmaps (Portfolio): * parentsOfIssuesInQuery() * parentsOfIssuesInQueryRecursive() * childrenOfIssuesInQuery() * childrenOfIssuesInQueryRecursive() And a lot of remote links aliases: remoteLinksCount > 0 See the documentation for…

Hi As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for. 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…

Hi, With standard JQL, you can only get a list of of epic's children if you know the epic key: parentEpic=MYEPIC-1 As a next step, you can use our app to find the child issues based on criteria of the epic: issue in childrenOfIssuesInQueryRecursive("project='ACME' and type=Epic and Team='Team 2'") Check out the…

JQL filtering is powerful, but you can hit its limits in more complex workflows. You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations and comments. So, if you're serious…

Hi, With standard JQL, you can only get a list of issues that have a particular issue link type: issuelinktype="included in sales opportunity" As a next step, you can use our app to find only the issues that have dependencies that are still not done: issue in linkedIssuesOfQuery("resolution is empty", "includes in sales…

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 you can quickly find the results using our professional indexing service: * JQL Search Extensions After you install…

Hi, With standard JQL, you can only get a list of issues that have a particular issue link type: issuelinktype="depends on" OR issuelinktype="dependency" As a next step, you can use our app to find only the issues that have dependencies that are still not done: issue in linkedIssuesOfQuery("resolution is empty",…

You may be able to achieve the same auto-linking functionality with the Jira automation feature which is included in Jira cloud.

Hi @[deleted] JQL filtering is powerful, but you can hit its limits in more complex workflows. You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations, dependencies, and, you…

Hi @Alekhya karkala Check out our app, JQL Search Extensions. Hopefully, marketplace installation numbers speak for themselves :) You can schedule a call with us or contact support and we can help with any specific questions you have.

Hi @Timothy Fischer It's: https://myCompany.atlassian.net/rest/api/2/search?jql=%22Parent%20Link%22=PRJ-8888 Make sure to: * include the REST api and its version in the path * URL encode the white space characters

JQL filtering is powerful, but you can hit its limits in more complex workflows. You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations, dependencies, and, you guessed it,…

Hi @Joel Hofer , @Megha Sinhaasks how to get the same results in Jira Cloud. 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 you can…

Hi @JosieWolfe Why not use a JQL filter as a source of issues in the box? This way you should be able to get a list of issues by executing the filter.

JQL filtering is powerful but you can hit its limits in more complex workflows. You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations and dependencies. So, if you're serious…

Node Red looks interesting. Why not use the Jira and Confluence REST API with Node Red then?

Olá @Rafael Thomaz! I don't think it's possible with standard JQL. You can try our app JQL Search Extensions and the subtasksCount extension: subtasksCount>0

Hi @Kashif Saleem, as others already posted, you can get approximate results with issueLinkType, or, if you happen to have our app JQL Search Extensions, you can use linkedIssueType extension: linkedIssueType!=Story or linkedIssueType is empty

If you have our app, JQL Search Extensions, you should go through the examples in Advanced Roadmaps integration.

Hi @Sam Gerzon It's not possible with standard JQL and it sounds like you need a JQL extensions app. I described how our app can help with sourcing the issues here: Advanced Roadmaps integration. In particular, have a look at the "Source a subset of epics with their full hierarchy" example. Link to the app in case you…

Hi @Roman Wolf , I described how the version ordering works here, in the Basics section: Searching issues by version with JQL The ordering wasn't intuitive to me before I discovered the rule.

Hey @Sanket Salvi , I don't think it's currently possible. You can get the results manually by getting all the bugs in the previous 2 sprint and checkng the creation time. What do you need the results for?

Hi @Abhijit Kulkarni , 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…