You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Join now to unlock these features and more
I am very new to Jira so I apologize if this seems very basic. I have a filter where I include the LinkedIssue ID. I want to also include the Forecasted Go-Live date of the LinkedIssue (not just of the issue itself) How can I accomplish this?
welcome to the community!
To see the go-live date of your linked issues (or any field of your linked issues), you would have to include these issues into your search result, as separate line items. This, unfortunately, is a little trickier in Jira, as Jira doesn't natively support joins or subqueries (in database query lingo).
A few ways forward:
If you want to run your query dynamically, without stitching things together as described above, you'll need extra tooling:
Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira:
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies. These issue hierarchies can be based on Jira's built-in parent/child relationships (like task/sub-task) and/or based on issue links. With this, you can build a view like the one above in just a couple of clicks.
Any questions just let me know,
As much as I would love to use third party tools, it's not anything I have authorization (or money) to do, so I'd probably want to go with your first suggestion. How would I accomplish this part " and then use the issue keys in an OR issueLink in (<main-issue-key-1>, <main-issue-key-2>, ...) clause" Would it be part of the same JSQL query?
Hi @Jennifer Hart,
no worries - yes, this would be part of the same JQL query. So, if you first do -
project = SSU AND issuetype = "Client Software Upgrade" AND status in (Discovery, "Go-Live Support", New, Pending, Planning, Scheduled) AND assignee in (EMPTY)
- then grab the issue keys of the result, and add them to the query like so -
(project = SSU AND issuetype = "Client Software Upgrade" AND status in (Discovery, "Go-Live Support", New, Pending, Planning, Scheduled) AND assignee in (EMPTY)) OR issueLink in (<main-issue-key-1>, <main-issue-key-2>, ...)
- then you should get all relevant issues. Does that work?
The challenge then is to get them into a meaningful order. As said above, you'll likely want to play around with ORDER BY clauses, but I'm not sure how and if you'd achieve the expected outcome.
Looking at the logic I don't think it's what I'm looking for. What you have does seem like like it is including the date field in the query. I don't need to look for issues within a certain issuelink-every issue I have will have a corresponding linkedissue and each wil have a forecasted date that I'd like to see next to each other to do a visual compare. I hope that makes sense.
every issue I have will have a corresponding linkedissue and each wil have a forecasted date that I'd like to see next to each other to do a visual compare
Yep, I think I get it. The problem is that this won't be possible; if you retrieve an issue via JQL, you can't just see another issue's field(s).
To see the other issue's field(s), the other issue must also be in your JQL filter result, as it's own line item.
That's what I've been trying to achieve here. Does this make sense?
Hi @Jennifer Hart -- Welcome to the Atlassian Community!
Would you please post the JQL you are trying to use?
And...are you trying to filter on that other field or just display the values for the issues found?
Hi @Bill Sheboy
This is what I have so far for the JSQL. Basically, I'd like to add another column that would be the Forecasted Go-Live date of the Linked issue.
project = SSU AND issuetype = "Client Software Upgrade" AND status in (Discovery, "Go-Live Support", New, Pending, Planning, Scheduled) AND assignee in (EMPTY) order by created DESC
At the right side of that view, above the displayed issues, there is a Columns drop-down list to select which fields are displayed for the search.
Is that a custom field your team has added or is it from a marketplace addon?
Is that a field from Advanced Roadmap? I am not using that tool and so cannot check that.
Would you please show an image where you see that field in the UI?
If it is a calculated field from Advanced Roadmaps, I would also expect it cannot be reported upon with an issue search.
As you note it is an out-of-the-box field and not calculated, I am unclear why it would not be reportable with an issue search. I did a quick search of the public backlog and do not see this symptom noted.
You are on a premium license, and so I suggest working with your Jira Site Admin to submit a ticket to Atlassian Support here: https://support.atlassian.com/contact/#/
When you hear back from them, please post what you learn to benefit the community. Thanks!