Versions Compared

Key

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

...

...

...

...

...

...

...

...

...

...

Warning

Looking for the documentation on the newest versions of Power Scripts for Jira 8? Click here and leave these dusty old pages behind!

Supported custom fields

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

...