Versions Compared

Old Version 5

changes.mady.by.user Jonathan Muse

Saved on

compared with

New Version 6

changes.mady.by.user Jonathan Muse

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Version published after converting to the new editor


Excerpt
hiddentrue

Fields from Jira Service Desk supported by the SIL language.

...

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


...