SSIS Components for Jira Assets

Build 24.0.9060

ObjectTypeAttributes

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

Select

The component 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 component.

  • Objecttypeid supports the following operators: =, IN
  • OnlyValueEditable supports the following operators: =
  • IncludeValuesExist supports the following operators: =
  • ExcludeParentAttributes supports the following operators: =
  • IncludeChildren supports the following operators: =

The following queries are processed server side: 

    SELECT * FROM ObjectTypeAttributes WHERE Objecttypeid = 123
    SELECT * FROM ObjectTypeAttributes WHERE OnlyValueEditable = true
    SELECT * FROM ObjectTypeAttributes WHERE IncludeValuesExist = true
    SELECT * FROM ObjectTypeAttributes WHERE ExcludeParentAttributes = true
    SELECT * FROM ObjectTypeAttributes WHERE ExcludeParentAttributes = true
    SELECT * FROM ObjectTypeAttributes WHERE IncludeChildren = true
	,etc.

Insert

To add a new ObjectTypeAttributes, you must specify at least the ObjectTypeId, Name and Type. 
  INSERT INTO ObjectTypeAttributes (ObjectTypeId, Name, Type,defaultTypeId)
		VALUES (3, 'testAttr', 0, 0)

Update

An Update operation requires three parameters: Id, DefaultTypeId and ObjectTypeId.

To update an item, you must specify the field and the new value. 

UPDATE	ObjectTypeAttributes
SET		Name = 'NewName', DefaultTypeId=0
WHERE	ObjectTypeID=3 AND Id=257

Delete

To delete an ObjectTypeAttributes, you must specify its ID.

For example: 

DELETE FROM ObjectTypeAttributes WHERE ObjectTypeAttributes=1 AND ID=36

Columns

Name Type ReadOnly Description
Objecttypeid [KEY] String False

The ObjectTypeId filter of the ObjectTypeAttributes.

OnlyValueEditable Boolean False

The OnlyValueEditable filter of the ObjectTypeAttributes.

IncludeValuesExist Boolean False

The IncludeValuesExist filter of the ObjectTypeAttributes.

ExcludeParentAttributes Boolean False

The ExcludeParentAttributes filter of the ObjectTypeAttributes.

IncludeChildren Boolean False

The IncludeChildren filter of the ObjectTypeAttributes.

Id [KEY] String False

The Id of the ObjectTypeAttributes.

WorkspaceId String False

The WorkspaceId of the ObjectTypeAttributes.

GlobalId String False

The GlobalId of the ObjectTypeAttributes.

Name String False

The Name of the ObjectTypeAttributes.

Label String False

The Label of the ObjectTypeAttributes.

DefaultTypeId Integer False

The DefaultTypeId of the ObjectTypeAttributes.

DefaultTypeName String False

The DefaultTypeName of the ObjectTypeAttributes.

TypeValue String False

The TypeValue of the ObjectTypeAttributes.

TypeValueMulti String False

The TypeValueMulti of the ObjectTypeAttributes.

AdditionalValue String False

The AdditionalValue of the ObjectTypeAttributes.

ReferenceType String False

The ReferenceType of the ObjectTypeAttributes.

ReferenceObjectTypeId String False

The ReferenceObjectTypeId of the ObjectTypeAttributes.

ReferenceObjectType String False

The referenceObjectType of the ObjectTypeAttributes.

Editable Boolean False

The Editable of the ObjectTypeAttributes.

System Boolean False

The System of the ObjectTypeAttributes.

Sortable Boolean False

The Sortable of the ObjectTypeAttributes.

Summable Boolean False

The Summable of the ObjectTypeAttributes.

Indexed Boolean False

The indexed of the ObjectTypeAttributes.

Indexed Boolean False

The indexed of the ObjectTypeAttributes.

MaximumCardinality Integer False

The MaximumCardinality of the ObjectTypeAttributes.

Suffix String False

The Suffix of the ObjectTypeAttributes.

ObjectAttributeExists Boolean False

The ObjectAttributeExists of the ObjectTypeAttributes.

Removable Boolean False

The Removable of the ObjectTypeAttributes.

Hidden Boolean False

The Hidden of the ObjectTypeAttributes.

IncludeChildObjectTypes Boolean False

The IncludeChildObjectTypes of the ObjectTypeAttributes.

UniqueAttribute Boolean False

The UniqueAttribute of the ObjectTypeAttributes.

RegexValidation String False

The RegexValidation of the ObjectTypeAttributes.

QlQuery String False

The QlQuery of the ObjectTypeAttributes.

Options String False

The Options of the ObjectTypeAttributes.

Position Integer False

The Position of the ObjectTypeAttributes.

ObjectTypeId [KEY] String False

The Id of the ObjectTypeAttributes.

ObjectTypeWorkspaceId String False

The WorkspaceId of the ObjectTypeAttributes.

ObjectTypeGlobalId String False

The GlobalId of the ObjectTypeAttributes.

ObjectTypeDescription String False

The Description of the ObjectTypeAttributes.

ObjectTypeName String False

The Name of the ObjectTypeAttributes.

ObjectTypeIconId String False

The IconId of the ObjectTypeAttributes.

ObjectTypeIconName String False

The IconName of the ObjectTypeAttributes.

ObjectTypeIconUrl16 String False

The IconUrl16 of the ObjectTypeAttributes.

ObjectTypeIconUrl48 String False

The IconUrl48 of the ObjectTypeAttributes.

ObjectTypePosition Integer False

The Position of the ObjectTypeAttributes.

ObjectTypeCreated Datetime False

The Created at of the ObjectTypeAttributes.

ObjectTypeUpdated Datetime False

The Updated at of the ObjectTypeAttributes.

ObjectTypeObjectCount Integer False

The ObjectCount of the ObjectTypeAttributes.

ObjectTypeParentObjectTypeId Integer False

The ParentObjectTypeId of the ObjectTypeAttributes.

ObjectTypeObjectSchemaId String False

The ObjectSchemaId of the ObjectTypeAttributes.

ObjectTypeInherited Boolean False

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

ObjectTypeAbstractObjectType Boolean False

The ParentObjectTypeId of the ObjectTypeAttributes.

ObjectTypeParentObjectTypeInherited Boolean False

The ParentObjectTypeInherited of the ObjectTypeAttributes.

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