Fields from Jira Service Management supported by the SIL language.
...
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 Management customer portal request