Excel Add-In for Jira Assets

Build 24.0.9060

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
The following filters are processed server-side, but are not required:

  • 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.

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