SSIS Components for Jira Assets

Build 24.0.9062

ObjectReferenceInfo

Find all references for an object.

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:

  • ObjectId supports the following operators: =, IN

    SELECT * FROM ObjectReferenceInfo WHERE ObjectId = 123
    SELECT * FROM ObjectReferenceInfo WHERE ObjectId IN (123, 1234)

Columns

Name Type Description
ObjectId [KEY] String The ObjectId of the ObjectTypeAttribute.
ReferenceTypeId String The ReferenceTypeId of the ObjectTypeAttribute.
ReferenceTypeWorkspaceId String The ReferenceTypeWorkspaceId of the ObjectTypeAttribute.
ReferenceTypeGlobalId String The ReferenceTypeGlobalId of the ObjectTypeAttribute.
ReferenceTypeName String The ReferenceTypeName of the ObjectTypeAttribute.
ReferenceTypeDescription String The ReferenceTypeDescription of the ObjectTypeAttribute.
ReferenceTypeColor String The ReferenceTypeColor of the ObjectTypeAttribute.
ReferenceTypeUrl16 String The ReferenceTypeUrl16 of the ObjectTypeAttribute.
ReferenceTypeRemovable Boolean The ReferenceTypeRemovable of the ObjectTypeAttribute.
ReferenceTypeObjectSchemaId String The ReferenceTypeObjectSchemaId of the ObjectTypeAttribute.
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 URL of the icon to display with small resolution.
ObjectTypeIconUrl48 String The URL of the icon to display with large resolution.
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.
ObjectTypeType Integer The type of the attribute.
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 Describes if this object types parent is inherited i.e. this object type has attributes that are inherited from one or more parents.
ObjectTypeParentObjectTypeInherited Boolean The ObjectTypeParentObjectTypeInherited of the ObjectType.
NumberOfReferencedObjects Integer The NumberOfReferencedObjects of the ObjectReferenceInfo.
OpenIssuesExists Boolean The OpenIssuesExists of the ObjectReferenceInfo.

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