Versions Compared

Old Version 3

changes.mady.by.user Jonathan Muse

Saved on

compared with

New Version 4

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

...