ODBC Driver for Jira Service Management

Build 23.0.8839

RequestTypes

This resource represents a request type.

Select

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 本製品.

  • ServiceDeskId supports the '=' operator.
  • ID supports the '=' operator.
  • GroupIds supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM RequestTypes WHERE ServiceDeskId = '1'
SELECT * FROM RequestTypes WHERE Id = '10012'
SELECT * FROM RequestTypes WHERE GroupIds = '12'

Columns

Name Type Description
Id [KEY] String The ID of the request type.
ServiceDeskId [KEY] String The Id of the service desk.
GroupIds String The IDs of the groups that this request type is part of.
Name String The Name of the request type.
Description String The description of the request type.
PortalId String The Id of the customer portal associated with the service desk project.
IssueTypeId String The Id of the issue type the request type is based upon.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
SearchQuery String String to be used to filter the results.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839