Requests
This resource represents a request.
Select
Set IncludeCustomFields to true in order to retrieve fields and custom fields that are specific to a request type. By default, only the columns mentioned below will be pushed. Note that setting IncludeCustomFields to true will decrease performance.
The 本製品 will use the Jira Service Management API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- RequestID supports the '=' operator.
- RequestTypeID supports the '=' operator.
- ServiceDeskID supports the '=' operator.
- RequestOwnership supports the '=' operator.
- RequestStatus supports the '=' operator.
SELECT * FROM Requests WHERE RequestID = '10001' SELECT * FROM Requests WHERE RequestTypeID = '12' SELECT * FROM Requests WHERE ServiceDeskID = '2' SELECT * FROM Requests WHERE RequestOwnership = 'admin' SELECT * FROM Requests WHERE RequestStatus = 'OPEN_REQUESTS'
Columns
Name | Type | Description |
RequestId [KEY] | String | The ID of the request. |
RequestKey [KEY] | String | The Key of the request. |
RequestTypeId | String | The ID of the request type. |
ServiceDeskId | String | The Id of the service desk. |
CreatedDate | String | The date when the request is created. |
ReporterKey | String | The key of the reporter. |
ReporterDisplayName | String | The display name of the reporter. |
ReporterEmail | String | The email of the reporter. |
ReporterName | String | The name of the reporter. |
ReporterTimeZone | String | The time zone of the reporter. |
CurrentStatus | String | The current status of the request. |
RequestParticipants | String | The participants of the request. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
RequestOwnership | String | The owner of the request.
使用できる値は次のとおりです。OWNED_REQUESTS, PARTICIPATED_REQUESTS, ALL_REQUESTS |
RequestStatus | String | The status of the request.
使用できる値は次のとおりです。CLOSED_REQUESTS, OPEN_REQUESTS, ALL_REQUESTS |