Find all object types for this object schema in Jira Assets.

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

The following filters are processed server-side but are not required:

• ExcludeAbstract supports the following operators: =

    SELECT * FROM ObjectSchemaObjectType WHERE ObjectSchemaId = 123
    SELECT * FROM ObjectSchemaObjectType WHERE ObjectSchemaId IN (123, 1234)
    SELECT * FROM ObjectSchemaObjectType WHERE ObjectSchemaId = 123 AND ExcludeAbstract=true

Columns

Name	Type	Description
Id [KEY]	String	The Id of the ObjectSchemaObjectType.
Name	String	The Name of the ObjectSchemaObjectType.
Description	String	The Description of the ObjectSchemaObjectType.
WorkspaceId	String	The WorkspaceId of the ObjectSchemaObjectType.
GlobalId	String	The GlobalId of the ObjectSchemaObjectType.
IconId	String	The IconId of the ObjectSchemaObjectType.
IconName	String	The IconName of the ObjectSchemaObjectType.
IconUrl16	String	The IconUrl16 of the ObjectSchemaObjectType.
IconUrl48	String	The IconUrl48 of the ObjectSchemaObjectType.
Position	Integer	The Position of the ObjectSchemaObjectType.
Created	Datetime	The Created at of the ObjectSchemaObjectType.
Updated	Datetime	The Updated at of the ObjectSchemaObjectType.
ObjectCount	Integer	The ObjectCount of the ObjectSchemaObjectType.
ParentObjectTypeId	Integer	The id of the parent object type.
Type	Integer	The type of the attribute.
ObjectSchemaId [KEY]	String	The ObjectSchemaId of the ObjectSchemaObjectType.
Inherited	Boolean	Describes if this object type is configured for inheritance i.e. it's children inherits the attributes of this object type.
AbstractObjectType	Boolean	The ParentObjectTypeId of the ObjectSchemaObjectType.
ParentObjectTypeInherited	Boolean	Describes if this object types parent is inherited i.e. this object type has attributes that are inherited from one or more parents.
ExcludeAbstract	Boolean	If true, filters out Abstract Object Types from the results.