ObjectSchemaAttributes
Find all object type attributes for this object schema.
Select
The add-in uses the Jira Assets API to process the request. The rest of the filter is executed client-side within the add-in.The following filters are processed server-side, and are required:
- ObjectSchemaId supports the following operators: =, IN
- Name supports the following operators: =
- Extended supports the following operators: =
- OnlyValueEditable supports the following operators: =
SELECT * FROM ObjectSchemaAttributes WHERE ObjectSchemaId = 123 SELECT * FROM ObjectSchemaAttributes WHERE ObjectSchemaId IN (123, 1234) SELECT * FROM ObjectSchemaAttributes WHERE ObjectSchemaId = 123 AND Name='test' SELECT * FROM ObjectSchemaAttributes WHERE ObjectSchemaId = 123 AND Extended=true SELECT * FROM ObjectSchemaAttributes WHERE ObjectSchemaId = 123 AND OnlyValueEditable=true
Columns
Name | Type | Description |
ObjectSchemaId [KEY] | String | The ObjectSchemaId filter of the ObjectSchemaAttributes. |
Id [KEY] | String | The Id of the ObjectSchemaAttributes. |
WorkspaceId | String | The WorkspaceId of the ObjectSchemaAttributes. |
GlobalId | String | The GlobalId of the ObjectSchemaAttributes. |
Name | String | The Name of the ObjectSchemaAttributes. |
Label | String | The Label of the ObjectSchemaAttributes. |
DefaultTypeId | Integer | The DefaultTypeId of the ObjectSchemaAttributes. |
DefaultTypeName | String | The DefaultTypeName of the ObjectSchemaAttributes. |
TypeValue | String | The TypeValue of the ObjectSchemaAttributes. |
TypeValueMulti | String | The TypeValueMulti of the ObjectSchemaAttributes. |
AdditionalValue | String | The AdditionalValue of the ObjectSchemaAttributes. |
ReferenceObjectTypeId | Integer | The ReferenceObjectTypeId of the ObjectSchemaAttributes. |
ReferenceObjectType | String | The ReferenceObjectType of the ObjectSchemaAttributes. |
Editable | Boolean | The Editable of the ObjectSchemaAttributes. |
System | Boolean | The System of the ObjectSchemaAttributes. |
Indexed | Boolean | The indexed of the ObjectSchemaAttributes. |
Sortable | Boolean | The Sortable of the ObjectSchemaAttributes. |
Summable | Boolean | The Summable of the ObjectSchemaAttributes. |
MinimumCardinality | Integer | The MinimumCardinality of the ObjectSchemaAttributes. |
MaximumCardinality | Integer | The MaximumCardinality of the ObjectSchemaAttributes. |
Suffix | String | The Suffix of the ObjectSchemaAttributes. |
Removable | Boolean | The Removable of the ObjectSchemaAttributes. |
ObjectAttributeExists | Boolean | The ObjectAttributeExists of the ObjectSchemaAttributes. |
Hidden | Boolean | The Hidden of the ObjectSchemaAttributes. |
IncludeChildObjectTypes | Boolean | The IncludeChildObjectTypes of the ObjectSchemaAttributes. |
UniqueAttribute | Boolean | The UniqueAttribute of the ObjectSchemaAttributes. |
RegexValidation | Boolean | The RegexValidation of the ObjectSchemaAttributes. |
QlQuery | Boolean | The QlQuery of the ObjectSchemaAttributes. |
Options | String | The Options of the ObjectSchemaAttributes. |
Position | Integer | The Position of the ObjectSchemaAttributes. |
ReferenceTypeId | String | The ReferenceTypeId of the ObjectSchemaAttributes. |
ReferenceTypeWorkspaceId | String | The ReferenceTypeWorkspaceId of the ObjectSchemaAttributes. |
ReferenceTypeGlobalId | String | The ReferenceTypeGlobalId of the ObjectSchemaAttributes. |
ReferenceTypeName | String | The ReferenceTypeName of the ObjectSchemaAttributes. |
ReferenceTypeDescription | String | The ReferenceTypeDescription of the ObjectSchemaAttributes. |
ReferenceTypeColor | String | The ReferenceTypeColor of the ObjectSchemaAttributes. |
ReferenceTypeUrl16 | String | The ReferenceTypeUrl16 of the ObjectSchemaAttributes. |
ReferenceTypeRemovable | Boolean | The ReferenceTypeRemovable of the ObjectSchemaAttributes. |
ReferenceTypeObjectSchemaId | String | The ReferenceTypeObjectSchemaId of the ObjectSchemaAttributes. |
ObjectTypeId | String | The ObjectTypeId of the ObjectType. |
ObjectTypeName | String | The ObjectTypeName of the ObjectType. |
ObjectTypeDescription | String | The ObjectTypeDescription of the ObjectType. |
ObjectTypeWorkspaceId | String | The ObjectTypeWorkspaceId of the ObjectType. |
ObjectTypeGlobalId | String | The ObjectTypeGlobalId of the ObjectType. |
ObjectTypeIconId | String | The ObjectTypeIconId of the ObjectType. |
ObjectTypeIconName | String | The ObjectTypeIconName of the ObjectType. |
ObjectTypeIconUrl16 | String | The ObjectTypeIconUrl16 of the ObjectType. |
ObjectTypeIconUrl48 | String | The ObjectTypeIconUrl48 of the ObjectType. |
ObjectTypePosition | Integer | The ObjectTypePosition of the ObjectType. |
ObjectTypeCreated | Datetime | The ObjectTypeCreated at of the ObjectType. |
ObjectTypeUpdated | Datetime | The ObjectTypeUpdated at of the ObjectType. |
ObjectTypeObjectCount | Integer | The ObjectTypeObjectCount of the ObjectType. |
ObjectTypeParentObjectTypeId | Integer | The ObjectTypeParentObjectTypeId of the ObjectType. |
ObjectTypeObjectSchemaId | String | The ObjectTypeObjectSchemaId of the ObjectType. |
ObjectTypeInherited | Boolean | Describes if this object type is configured for inheritance i.e. it's children inherits the attributes of this object type. |
ObjectTypeAbstractObjectType | Boolean | The ObjectTypeAbstractObjectType of the ObjectType. |
ObjectTypeParentObjectTypeInherited | Boolean | The ObjectTypeParentObjectTypeInherited of the ObjectType. |
OnlyValueEditable | Boolean | The OnlyValueEditable filter of the ObjectSchemaAttributes. |
Extended | Boolean | The Extended filter of the ObjectSchemaAttributes. |