Tableau Connector for Jira Assets

Build 24.0.9060

ObjectSchema

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

Select

The connector uses the Jira Assets API to process the query. The filter is executed client-side within the connector.

Insert

To add an ObjectSchema, you must specify at least the Name and ObjectSchemaKey.
  INSERT INTO ObjectSchema (Name, ObjectSchemaKey)
    VALUES ('ObjectSchemaTest', 'OST')

Update

To update an item, you must specify at least the field and the new value.
UPDATE	ObjectSchema 
SET 	Name='ObjectSchemaUpdated', Description='TestDescription'
WHERE	Id=1

Delete

To delete a ObjectSchema, you must specify its ID.

For example:

DELETE FROM ObjectSchema WHERE ID=1

Columns

Name Type ReadOnly Description
Id [KEY] String False

The Id of the ObjectSchema.

Name String False

The Name of the ObjectSchema.

Description String False

The Description of the ObjectSchema.

WorkspaceId String False

The WorkspaceId of the ObjectSchema.

GlobalId String False

The GlobalId of the ObjectSchema.

ObjectSchemaKey String False

The ObjectSchemaKey of the ObjectSchema.

Status String False

The Status of the ObjectSchema.

Created Datetime False

The Created at of the ObjectSchema.

Updated Datetime False

The Updated at of the ObjectSchema.

ObjectCount Integer False

The ObjectCount of the ObjectSchema.

ObjectTypeCount Integer False

The ObjectTypeCount of the ObjectSchema.

CanManage Boolean False

The CanManage of the ObjectSchema.

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