ObjectTypeAttributes
Create, update, and query the ObjectTypeAttribute in Jira Assets.
Select
The add-in 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 add-in.- 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. |