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