Versions Compared

Key

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

...

...

...

...

...

...

...

...

...

...

Button handy
blanktrue
color#0052CC
nameSend Feedback
linkhttps://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=Jira+Service+Management+Supported+Fields+-+15481277
widthauto

Excerpt
hiddentrue

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