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

Ignat_kzkpyx

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_kzkpyx

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;
}