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