calculates text field, script too long

Hi all,

I'm creating a new business project in JIRA, each issue has the following fields:

  • supplier code 
  • supplier description

I wuold like automatically compile the supplier description based on the supplier code that is a text free field.

I tried to use the calculated text field, but the problem is that I have more than 4000 possible supplier and my script become too long and when i insert it in the description i receive an error...

Do you know a way to solve this problem?

Thank you!

Simona

 

6 answers

How does your code looks like? Have you tried any other way of displaying this like the Cascading Select Custom field? 4000 seems a very long list, are all those active?

As I understand you need to get description for any of 4000 basing on it's code. Is is right?

Yes, it is correct! I need the description for each supplier code

<!-- @@Formula:
String suppliercode= issue.get("customfield_12462");

if (suppliercode.equals( "001" )) return "supplier 1";
if (suppliercode.equals( "002" )) return "supplier 2";
if (suppliercode.equals( "003" )) return "supplier 3";

etc...

 

-->

Can you help me?

Thank you!

Simona

I think you should use Map collection in this case. To make code more readable it better to put map filling into a function. Here is a code example how to do it, tune it to your needs:

import java.util.Map

Map&lt;String, String&gt; suppliersMap = new HashMap&lt;&gt;();

initiateMap(suppliersMap);

return suppliersMap.get("code " + 2053)

public initiateMap(Map&lt;String, String&gt; _map ) {
    for(int iSupl = 0; iSupl &lt; 4000; ++iSupl)
    _map.put("code " + iSupl, "desription " + iSupl);
}

sorry I wrote an example not inserting the correct values...

<!-- @@Formula:
String suppliercode= issue.get("customfield_12462");

if (suppliercode.equals( "001" )) return "Pippo";
if (suppliercode.equals( "AB4" )) return "Pluto";
if (suppliercode.equals( "C73" )) return "De cicco";

-->

so I don't think I can use an iterative code, but I am not so expert,... 

Simona

Sorry for the delay in the answer...yes , its are 4000 and all active... sad

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,109 views 4 9
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you