SSIS Components for Oracle Service Cloud

Build 24.0.9062

IncidentsMilestoneInstances

The milestone instances associated with incidents.

Table-Specific Information

SELECT

The 本製品 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 本製品.

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.

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