Excel Add-In for Jira Assets

Build 24.0.9060

Objects

Query Jira Assets objects.

Select

The add-in uses the Jira Assets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.

  • ID supports the following operators: =,!=,IS,IS NOT,IN,NOT IN
  • Name supports the following operators: =,!=,IS,IS NOT,IN,NOT IN
  • Label supports the following operators: =,!=,IS,IS NOT,IN,NOT IN
  • ObjectKey supports the following operators: =,!=,IS,IS NOT,IN,NOT IN
  • ObjectTypeId supports the following operators: =,!=,IS,IS NOT,IN,NOT IN
  • ObjectTypeName supports the following operators: =,!=,IS,IS NOT,IN,NOT IN
  • Created supports the following operators: =,>,>=,<,<=
  • Updated supports the following operators: =,>,>=,<,<=
The following queries are processed server-side: 
    SELECT * FROM Objects WHERE ID = 123
    SELECT * FROM Objects WHERE Name = 'Test'
    SELECT * FROM Objects WHERE Label = 'Test'
    SELECT * FROM Objects WHERE ObjectKey = 'KEY-1'
    SELECT * FROM Objects WHERE ObjectTypeName = 'ThisType'
    SELECT * FROM Objects WHERE Created = '2000-01-01'
    SELECT * FROM Objects WHERE Updated = '2000-01-01'
	,etc.

Insert

To add to Objects, you must specify at least the ObjectTypeId and Attributes. 
  INSERT INTO Objects (ObjectTypeId, ObjectAttributes, hasAvatar) 
  VALUES  (6, '[{"objectTypeAttributeId":"25","objectAttributeValues":[{"value":"DEP-4"}]} ,{"objectTypeAttributeId":"26","objectAttributeValues":[{"value":"testInserted"}]}]', false )

Update

To update an item via the Insert operation, you must specify the field and the new value. 
UPDATE	Objects
SET		hasAvatar = false
WHERE	ID=35

Delete

To delete from Objects, you must include the ID.

For example: 

DELETE FROM Objects WHERE ID=36

Columns

Name Type ReadOnly Description
Id [KEY] String False

The Id of the ObjectTypeAttribute.

WorkspaceId String False

The WorkspaceId of the ObjectTypeAttribute.

GlobalId String False

The GlobalId of the ObjectTypeAttribute.

Name String False

The Name of the ObjectTypeAttribute.

Label String False

The name of the object. This value is fetched from the attribute that is currently marked as label for the object type of this object.

ObjectKey String False

The external identifier for this object.

AvatarId String False

The AvatarId of the ObjectTypeAttribute.

AvatarWorkspaceId String False

The AvatarWorkspaceId of the ObjectTypeAttribute.

AvatarGlobalId String False

The AvatarGlobalId of the ObjectTypeAttribute.

AvatarUUID String False

The AvatarUUID of the ObjectTypeAttribute.

AvatarUrl16 String False

The URL of the icon to display with small resolution.

AvatarUrl48 String False

The URL of the icon to display with large resolution.

AvatarUrl72 String False

The URL of the icon to display with large resolution.

AvatarUrl144 String False

The URL of the icon to display with large resolution.

AvatarUrl288 String False

The URL of the icon to display with large resolution.

AvatarObjectId String False

A reference to the object that this avatar is associated with.

ObjectTypeId String False

The ObjectTypeId of the Objects.

ObjectTypeName String False

The ObjectTypeName of the Objects.

ObjectTypeDescription String False

The ObjectTypeDescription of the Objects.

ObjectTypeWorkspaceId String False

The ObjectTypeWorkspaceId of the Objects.

ObjectTypeGlobalId String False

The ObjectTypeGlobalId of the Objects.

ObjectTypeIconId String False

The ObjectTypeIconId of the Objects.

ObjectTypeIconName String False

The ObjectTypeIconName of the Objects.

ObjectTypeIconUrl16 String False

The ObjectTypeIconUrl16 of the Objects.

ObjectTypeIconUrl48 String False

The ObjectTypeIconUrl48 of the Objects.

ObjectTypePosition Integer False

The ObjectTypePosition of the Objects.

ObjectTypeCreated Datetime False

The ObjectTypeCreated at of the Objects.

ObjectTypeUpdated Datetime False

The ObjectTypeUpdated at of the Objects.

ObjectTypeObjectCount Integer False

The ObjectTypeObjectCount of the Objects.

ObjectTypeParentObjectTypeId Integer False

The ObjectTypeParentObjectTypeId of the Objects.

ObjectTypeType Integer False

The type of the attribute.

ObjectTypeObjectSchemaId String False

The ObjectTypeObjectSchemaId of the Objects.

ObjectTypeInherited Boolean False

Describes if this object type is configured for inheritance i.e. it's children inherits the attributes of this object type.

ObjectTypeAbstractObjectType Boolean False

The ObjectTypeParentObjectTypeId of the Objects.

ObjectTypeParentObjectTypeInherited Boolean False

The ObjectTypeParentObjectTypeInherited of the Objects.

ObjectAttributes String False

The ObjectAttributes of the Objects.

Created Datetime False

The Created at of the Objects.

Updated Datetime False

The Updated at of the Objects.

HasAvatar Boolean False

The HasAvatar at of the Objects.

Timestamp Integer False

The Timestamp of the Object.

SelfLink String False

The SelfLink of the Object.

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