IncidentsMilestoneInstances
The milestone instances associated with incidents.
Table-Specific Information
SELECT
The connector will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the connector.
SELECT * FROM IncidentsMilestoneInstances WHERE milestoneId = 12 SELECT * FROM IncidentsMilestoneInstances WHERE milestoneId > 15 SELECT * FROM IncidentsMilestoneInstances WHERE milestonelookUpName LIKE '%test' SELECT * FROM IncidentsMilestoneInstances WHERE milestoneId IN (12, 23, 123) SELECT * FROM IncidentsMilestoneInstances WHERE milestonelookUpName IS NOT NULL
Columns
| Name | Type | Description |
| IncidentsId | Long | The unique identifier of the incident. |
| MilestoneId | Long | Id of milestone. The ID of the associated milestone. |
| MilestonelookUpName | String | LookUpName of milestone. The ID of the associated milestone. |
| ResolutionDueTime | Datetime | The date and time when the associated resolution milestone is due. |