Set field value at creation, based on max field value

Scott Genevish November 2, 2016

I have a field, "Name", that I'd like to set automatically when an issue is created.  The values of this field will be in the form "Acme101623":

  • "Acme":  This is the same for every issue
  • "1016":  This is the current month and year.
  • "23":  This is a sequential number, starting at "01" at the beginning of the month, then will increment by 1 each time an issue is created.

So, for the next issue, I'd need to see all other issues where this field is "Acme1016nn", then increment the highest "nn" value by one to find the next value.  How can I do this?

Thanks,

-Scott

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 2, 2016

You'll need to write code to do this.  I'd keep it as simple as possible - a post-function that puts your data into a standard "read only custom field" (Those are intended to be populated by code).  As usual, I'd do it with the Script Runner, but creating an add-on to contain the post-function would work fine too.

The Acme, month and year are quite easy to do.  The sequential number is a bit more of a problem.  You'll need to store that number somewhere, which isn't that hard (active objects if you're coding your own add-on.  Script Runner, I'm less sure of), but you could run into "fun" with concurrency when two users are creating issues at much the same time.

Before you dive into piles of code though, could you explain the requirement from the users point of view though?  There might be a better way to meet the need.

 

Scott Genevish November 3, 2016

I'm migrating our asset tracking database to Jira.  This is the machine name, which follows this structure.  In the old system (a spreadsheet) it was easy to see what the most recent value of this field was and pick the next one.  

I'll look into script runner. 

Thanks,

-Scott

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events