I've been using linkedIssuesOf() function for a while but I don't know how to include a condition within linkedIssuesOf() where the date issue was the link between <fromdate> and <todate>
That specific JQL function is actually being provided by the scriptrunner plugin. When looking at their documentation on this function: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_linkedissuesof
It does not have any kind of date or time parameter that could be passed to the function to find when the link was created precisely. You could pass the function an additional JQL query in order to refine the results. However there isn't a clear JQL you can use to find exactly what you want. If you tried to use updated> date1 and updated<date2 You might find the issues you want, but this would also include any other issues that have had any kind of update to them, not just the creation of a link.
However if you're using Jira Server, and you have access to the SQL database, you could probably find out this information through some SQL hackery. I played around with this a bit and I think I found a SQL query you could use to find the time when issue links where created for issues with something like this:
SELECT p.pkey || '-' || i.issuenum AS Issuekey, cg.ID, cg.issueid, cg.AUTHOR, cg.CREATED, ci.FIELD, ci.OLDVALUE, ci.OLDSTRING, ci.NEWVALUE AS LinkedIssuekey, ci.NEWSTRING
FROM changegroup cg
inner join jiraissue i on cg.issueid = i.id
inner join project p on i.project = p.id
inner join changeitem ci on ci.groupid = cg.id
where ci.field='Link'
The created field returned by these results will be the time when the issue link was created.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.