ObjectSchemaAttributes
Find all object type attributes for this object schema.
Select
The connector uses the Jira Assets API to process the request. The rest of the filter is executed client-side within the connector.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. |