Skip to end of banner
Go to start of banner

Jira Service Management Supported Fields

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Supported Custom Fields

Custom FieldRead/WriteSIL TypeValue
ApprovalsRead-only
JApproval[]
List of JApproval structures.

Customer Request Type

Read/Writestring

A composite string containing portal key / request key.

In order to get the list of such values, use the next query:

SELECT STRINGVALUE, COUNT(*) FROM jiraissue i 
LEFT JOIN customfieldvalue cfv 
ON i.id = cfv.ISSUE 
where cfv.customfield = (select id from customfield where cfname = 'Customer Request Type') 
GROUP BY STRINGVALUE;

Customer Organizations

Read/Writestring[]A list of organizations names

Request Participants

Read/Writestring[]A list of users that are participants in Service Desk customer portal request

Satisfaction

Read-onlynumberThe customer satisfaction rate

Satisfaction date

Read-onlydateThe request feedback date

SLA CustomField Type

Read-onlyJSlaInformationA JSlaInformation structure

Examples

// GET
runnerLog("1. Customer Organizations: " + customfield_10204);
runnerLog("2. Request Participants: " + customfield_10202);
runnerLog("3. Customer Request Type: " + customfield_10203);
runnerLog("4. Satisfaction: " + customfield_10011);
runnerLog("5. Satisfaction date: " + customfield_10012);

runnerLog(" 6.Approvals: ");
JApproval[] jApprovals = customfield_10100;
for(JApproval jApproval in jApprovals) {
	runnerLog(" Approval issueId: " + jApproval.issueId);
	runnerLog(" Approval name: " + jApproval.name);
	runnerLog(" Approval decision: " + jApproval.decision);
	runnerLog(" Approval createdDate: " + jApproval.createdDate);
	runnerLog(" Approval completedDate: " + jApproval.completedDate);
	runnerLog(" Approval statusId: " + jApproval.statusId);
	runnerLog(" Approval approvers: " + jApproval.approvers);
}


runnerLog(" 7.SLA: ");
JSlaInformation slaInfo = customfield_10017;
runnerLog("slaInfoName = " + slaInfo.name);
JSlaOngoingCycle slaOC = slaInfo.ongoingCycle;
runnerLog("---ongoingCycle---");
runnerLog("startTime = " + slaOC.startTime);    
runnerLog("breachTime = " + slaOC.breachTime);    
runnerLog("breached = " + slaOC.breached);    
runnerLog("paused = " + slaOC.paused);    
runnerLog("withinCalendarHours = " + slaOC.withinCalendarHours);    
runnerLog("goalDuration = " + slaOC.goalDuration);    
runnerLog("elapsedTime = " + slaOC.elapsedTime);    
runnerLog("remainingTime = " + slaOC.remainingTime);    
int indexCC = 1;
for(JSlaCompletedCycle slaCC in slaInfo.completedCycles) {
   runnerLog("---completedCycle " + indexCC + "---");    
   runnerLog("startTime = " + slaCC.startTime);    
   runnerLog("stopTime = " + slaCC.stopTime);    
   runnerLog("breached = " + slaCC.breached);    
   runnerLog("goalDuration = " + slaCC.goalDuration);    
   runnerLog("elapsedTime = " + slaCC.elapsedTime);    
   runnerLog("remainingTime = " + slaCC.remainingTime);    
   indexCC = indexCC + 1;
}


//SET
customfield_10204 = "user2_organization"; //Customer Organizations
customfield_10202 = "user"; //Request Participants
customfield_10203 = "real/getithelp"; //Customer Request Type
  • No labels