JDBC Driver for Jira Service Desk

Build 22.0.8462

RequestTypes

This resource represents a request type.

Select

The driver will use the Jira Service Desk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • 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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462