Using Jira 6.1 and Service Desk
I'm creating tickets via mail handler, but have a need for emails with slightly different subject lines to write to the same issue. Is there a way to set a filter on how Jira reads the subject line? Example
Email 1 = Example ABC Start (this creates the issue)
Email 2 = Example ABC Escalate (this I need added to the above issue)
Email 3 = Example DEF Start (would create new issue)
I don't think so, these are automated emails coming from a monitoring system, maybe I could use API calls once the first email creates the issue to plug it into the monitoring system email? BUT if I could do it, here's the second question part:
I don't have the issue key in the database for 6.1 but I do see it in the UI (from a view maybe?) the jiraissue table now has issuenum that corresponds to the numeric value of the key I see on screen. So is the mailhandler looking for the key as presented in the UI or the database value?
Ah, that is a bit trickier. Yes -- the mail handler looks for the key as presented in the UI. You need the project key and issue number in order to uniquely identify a particular issue.
Here's a SQL query that can piece that together for you:
SELECT concat(project_key.project_key, '-', jiraissue.issuenum) as 'issuekey', summary FROM jira.jiraissue JOIN jira.project_key ON jiraissue.project = project_key.project_id;
There is also a pretty decent REST API for this, if that option is any better for you.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Any other country that celebrates Midsummer holiday (this friday 22 June)?
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs