Daniel Turczanski - JQL Search Extensions Atlassian Partner

Hi, With standard JQL you can only get the direct children of epics. Subtasks are hard to fetch. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions. You can simply search for: issue in childrenOfIssuesInQueryRecursive("project='xxx' and…

Hi, @Andy Heinzer described what can be achieved with standard JQL. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions. You can simply search for: currentUser()lastUpdatedBy= You can read more in <a…

Hi Joe, With standard JQL you can only do some basic search Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions. To find active initiatives with cancelled epics: issue in parentsOfIssuesInQuery("status=Cancelled") and type=Initiative and…

Hey @Suresh_Kumar , If it's a one-off job you can always export the issues to a spreadsheet and do your analysis there. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions. This query finds finished issues with unfinished subtasks. issue in…

Vanilla JQL doesn't support it. You can export your issues to spreadsheet and process the data there. Obviously it only works for one off jobs. You can find such epics with our app JQL Search Extensions. If you install it you'll be able to perform this search: issuesInEpicCount = 0 I hope this helps!

Hi Scott, With standard JQL you can only get parents of specific epics. You may want to consider our professional indexing service JQL Search Extensions. After you install the app, you are able to find parent initiatives of epics witha particular label: issue in parentsOfIssuesInQuery("labels=mylabel and type=Epic")

Hi James, I see some great workarounds proposed here but if you want JQL to support your workflow, you should consider using our app JQL Search Extensions. To filter out subtasks and stories in your particular status, add this to your board filter: parentStatus != "Your status" and status != "Your status" Have a look at…

Hey @Thomas Fritzen it's only available if you install our app. The link is in my answer.

Hi, With standard JQL you can only find children of specific epics. Standard JQL doesn't easily allow it but the results can be found dynamically using our professional indexing service JQL Search Extensions. You can find children of epics with a particular component: issue in childrenOfEpicsInQuery("component='My…

Hi, Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions. You can search for issues that link to your specific confluence pages: remoteLinkApplicationName="Confluence" AND remoteLinkTitlePartialMatch ~ YOUR_PAGE_ID You can check out the…

Hi, With standard JQL you can implement this for very simple cases as Jack described it. Standard JQL doesn't easily allow it but advanced linking scenarios can be implemented using our professional indexing service JQL Search Extensions. You can for example show issues from other projects that are linked by your JSM…

Hi, With standard JQL you can only execute your subquery, export the results and manually construct another JQL using the export epic issue keys. It works if it's just a one off job. Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions. You…

Hi Anh, JQL Search Extensions is our app and it integrates well with Jira's native search. Feel free to reach out to our support for help. Thanks!

Hi @Maria Z , The function that accept a subquery as a parameter are part of JQL Search Extensions indexing service. To use childrenOfEpicsInQuery make sure to go to Apps->JQL Search Extensions->Extended search. I hope this helps!

Hey, It's a well known problem with the tilde operator - it's an approximate text match. If you need an exact text match you'll need an app like JQL Search Extensions: exact text match in JQL 

Hi Shyam, Nested JQL is not supported out of the box in Jira. An alternative to using an app like JQL Search Extensions that support subqueries, is to manually create the results: * search for for tickets that satisfy the first JQL * export to Excel and copy the users * create a second JQL query with the users from the…

Hey, you can do it with JQL Search Extensions "true" and created < -30mhasSameUpdatedAndCreatedDate =

Hey, You can do it with JQL Search Exensions For example: linkedByIssueProject="Project A" You can find more in the documentation

Hey Luis, Are you trying to find subtasks of a single story? If so use this JQL: assignee=currentUser() AND parent=STORY-KEY

In next-gen projects it's the parent field that points to the epic. This returns the issues without epics: parent is empty

Hi @Stephen Herrick , It's not a native solution but you can try our app JQL Search Extensions. It supports subqueries for links, subtasks and epics.

@Angela Boston why not just use: issuetype="Creative Request" and issue in subTaskOf("issuetype='Creative Request'")

Hi Janene, that's because parentOfQuery is only meant to be used with subtasks and their parents. Portfolio relationships are not supported.

Hi Alexis, You can easily find it with JQL Search Extensions In the cloud: commentedByUser="your user" On server: issue in commentedByUser("your user")

Hi Paolo, You can use JQL Search Extensions with its subquery keywords. for example epicOfQuery.

Hi, an alternative is to use JQL Search Extensions

Hi, you can use JQL Search Extensions plugin for that: documentation Otherwise, you won't be able to create a filter. You could manually perform a search for epics with labels and then export that result and perform another manual search for issues with Epic Link within the epics you've found in the first search.

Hi Mike, you can also run subqueries with Jql Search Extensions For example: issue in subtaskOf("priority = High")

Hi, you can use Jql Search Extensions In cloud: linkType = "is blocked by" or linkType = "blocks" Server: issue in linkType("is blocked by") or issue in linkType("blocks")

Hi Michael, JQL Search Extensions adds a bunch of keywords for comments. After installing the plugin you can then use the following JQL: commentsCount > 0 Full documentation is here.