Excel Add-In for Jira Assets

Build 24.0.9060

ObjectConnectedTickets

Relation between Jira issues and Assets objects.

Select

The add-in will use 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 ObjectConnectedTickets WHERE ObjectId = 123
    SELECT * FROM ObjectConnectedTickets WHERE ObjectId IN (123, 1234)

Columns

Name Type Description
ObjectId [KEY] String The ObjectId of the ObjectConnectedTickets.
Id [KEY] String The Id of the ObjectConnectedTickets.
WorkspaceId String The WorkspaceId of the ObjectConnectedTickets.
GlobalId String The GlobalId of the ObjectConnectedTickets.
Key String The Key of the ObjectConnectedTickets.
Reporter String The Reporter of the ObjectConnectedTickets.
Created Datetime The Created at of the ObjectConnectedTickets.
Updated Datetime The Updated at of the ObjectConnectedTickets.
Title String The Title at of the ObjectConnectedTickets.
StatusName String The StatusName at of the ObjectConnectedTickets.
StatusDescription String The StatusDescription at of the ObjectConnectedTickets.
StatusColorName String The StatusColorName at of the ObjectConnectedTickets.
TypeName String The TypeName at of the ObjectConnectedTickets.
TypeDescription String The TypeDescription at of the ObjectConnectedTickets.
TypeIconUrl String The TypeIconUrl at of the ObjectConnectedTickets.
PriorityName String The PriorityName at of the ObjectConnectedTickets.
PriorityIconUrl String The PriorityIconUrl at of the ObjectConnectedTickets.

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