Unable to use lastComment and lastUpdated in the linkedIssuesOf subquery

Question

Hello,

I am trying to write a query to get all the Jira tickets in a first-level project (here PRJ1) that are linked to second-level projects tickets which (these last tickets) were last updated (with a status transition or a comment and so on) more than 3 months ago.

The query I have written so far is:

project = PRJ1 AND status = "Passed to Dev" AND issuetype in (Bug, Incident, Problem, Task) AND issueFunction in linkedIssuesOf("issueFunction in lastComment("before -3M")", "To fix") AND issueFunction in linkedIssueOf("issueFunction in lastUpdated("before -3M"))", "To fix") ORDER BY updated

Nevertheless, Jira informs me that:

Error in the JQL Query: Expecting ')' or ',' but got 'before'. (line 1, character 142)

How can the linkedIssueOf feature be used with lastComment and lastUpdated subqueries? I am aware that the syntax should be:

linkedIssuesOf(Subquery, [link name])

Thanks a lot in advance.

Walter Buggenhout · Answer

Hi @Stefano D_Angelo,

If you want to include all link types, you can just omit the "to fix" parameter from the query. However, if you want to retrieve multiple specific link types, you might have to combine multiple issuefuntion in linkedIssuesOf() statements, where you specify the desired link type separately.

If that's the case, then be very careful to use parentheses in the right places for consistent results.

Good luck with that last bit!

Stefano D_Angelo · Answer

Hello @Walter Buggenhout, I referred to some other documentation where it says 'M' could stand for months but I might have misread it!

Thank you so much, now it works!

One last question (if possible): how could I include all the link types (or at least more than just one) in the linkedIssueOf argument and not just To fix?

Thank you very much.

Walter Buggenhout · Answer

Hi @Stefano D_Angelo,

I hadn't paid much attention to that part of your query, but M for months does not exist as far as I know. You can use "w" for weeks or "d" for days instead. M is used for minutes (although it is normally spelled with a small 'm').

I would replace before -30M  with before -90d. It is not entirely correct, but should come pretty close!