ObjectReferenceInfo
Find all references for an object.
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:
- 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. |