Versions Compared

Old Version 4

changes.mady.by.user Jonathan Muse

Saved on

compared with

New Version 5

changes.mady.by.user Jonathan Muse

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue

Fields from Jira Service Desk supported by the SIL language.

Supported Custom Fields

Excerpt


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:

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

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

...