ObjectConnectedTickets
Relation between Jira issues and Assets objects.
Select
The connector will use the Jira Assets API to process the request. The rest of the filter is executed client side within the connector. 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. |