ODBC Driver for Jira Assets

Build 24.0.9060

ObjectTypes

Create, update, and query the ObjectType in Jira Assets.

Select

The driver uses the Jira Assets 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.

  • ID supports the following operators: =, IN
  • ObjectSchemaId supports the following operators: =, IN

The following queries are processed server-side: 

    SELECT * FROM ObjectTypes WHERE ID = 123
    SELECT * FROM ObjectTypes WHERE ID IN (1, 123)
	,etc.

Insert

To add an ObjectType, you must specify at least the ObjectSchemaId, Name and IconId. 
  INSERT INTO ObjectTypes (ObjectSchemaId, Name, IconId)
    VALUES (1, 'TypeTest', 1)

Update

To update an item via the Insert operation, you must specify the field and the new value. 
UPDATE	ObjectTypes 
SET 	Name='TestObjectUpdated', IconId=2, Description='TestDescription'
WHERE	Id=1

Delete

To delete an ObjectType, you must specify the ID.

For example: 

DELETE FROM ObjectTypes WHERE ID=1

Columns

Name Type ReadOnly Description
Id [KEY] String False

The Id of the Objects.

Name String False

The Name of the Objects.

Description String False

The Description of the Objects.

WorkspaceId String False

The WorkspaceId of the Objects.

GlobalId String False

The GlobalId of the Objects.

IconId String False

The IconId of the Objects.

IconName String False

The IconName of the Objects.

IconUrl16 String False

The URL of the icon to display with small resolution.

IconUrl48 String False

The URL of the icon to display with large resolution.

Position Integer False

The Position of the Objects.

Created Datetime False

The Created at of the Objects. Format: date-time.

Updated Datetime False

The Updated at of the Objects. Format: date-time.

ObjectCount Integer False

The ObjectCount of the Objects.

ParentObjectTypeId Integer False

The id of the parent object type

Type Integer False

The type of the attribute.

ObjectSchemaId String False

The ObjectSchemaId of the Objects.

Inherited Boolean False

Describes if this object type is configured for inheritance i.e. it's children inherits the attributes of this object type.

AbstractObjectType Boolean False

The ParentObjectTypeId of the Objects.

ParentObjectTypeInherited Boolean False

The ParentObjectTypeInherited of the Objects.

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