It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Possible to have multiple email subject lines write to the same Issue?

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)

1 answer

1 accepted

0 votes
Answer accepted

Are you able to add the issue key to the subject? That would solve the problem.

For example,

Email 1 = Example ABC Start (this creates the issue with key EXAMPLE-123)
Email 2 = Example ABC Escalate [EXAMPLE-123]

Email 3 = Example DEF Start [EXAMPLE-123]

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Teamwork

The Confluence blog has a brand-new look AND brand-new content!

Hey Community,  Last year, the Confluence team shipped "Team Central," a hub of articles and templates on topics like project planning, knowledge sharing, and more.  We're thrilled to...

28 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you