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