Page Comparison

...

Excerpt

hidden	true

Fields from Jira Service Desk Management supported by the SIL language.

Supported Custom Fields

Excerpt

Custom Field

Read/Write

SIL Type

Value

Approvals

Read-only

Code Block
JApproval[]

List of JApproval structures.

Customer Request Type

Read/Write

string

A composite string containing portal key / request key.

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

Code Block

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/Write

string[]

A list of organizations names

Request Participants

Read/Write

string[]

A list of users that are participants in Service

Desk

Management customer portal request
Satisfaction	Read-only	number	The customer satisfaction rate
Satisfaction date	Read-only	date	The request feedback date
SLA CustomField Type	Read-only	JSlaInformation	A JSlaInformation structure

Examples

Code Block

// 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

Versions Compared

Old Version 6

New Version 7

Key

Supported Custom Fields

Examples