Power BI Connector for Jira Assets

Build 24.0.9062

ObjectSchemaObjectType

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

Select

The 本製品 uses the Jira Assets API to process the request. The rest of the filter is executed client-side within the 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062