how to get issue type name by issue type id? (besides of of SQL request to DB)

[Ignat]

Hello everyone.

I use createIssue() routine in my script. This routine gnneeds the issue type name as an input.

To make the script resistant to issue type renaming I'd like to put issue type id instaead of issue type name in it. I know how to find out the id, but do do not the convinient way to transform it to name

[Ignat · Accepted solution]

function getIssueTypeNameById(int issueID) {
    string issueTypeName;
    string query = 
        "SELECT \"PNAME\" FROM \"ISSUETYPE\" WHERE \"ID\" = " + issueID;
    // runnerLog(query);
    issueTypeName = sql("JiraDS", query);
    if (iissueTypeName == "") {
        issueTypeName = "not found";
    }
    return issueTypeName;
}

[Antoine Berry]

Hello @Ignat ,

I believe that you can use the id instead of the name when creating the parameters for the issue creation : 

def issueFactory = ComponentAccessor.getIssueFactory()
def issueManager = ComponentAccessor.getIssueManager()

MutableIssue newIssue = issueFactory.getIssue()
newIssue.setRepoter(....
...)
newIssue.setIssueTypeId(12345)

Map<String,Object> newIssueParams = ["issue" : newIssue] as Map<String,Object>

issueManager.createIssueObject(user, newIssueParams)

Note that createIssueObject() should be better as it is not deprecated.

[Ignat]

sorry. I havn't mentioned - I usr SIL. not groovy

[Piyush A (STR)]

Try to get the issue types of the project and then get the id Vaue

https://docs.atlassian.com/software/jira/docs/api/REST/7.11.0/#api/2/project-getProject

[Ignat]

it was my first thought. but rest is slow and I ended upt with direct SQL request to db solution