Name: ITSSQLSandbox.DBO.VW_EVENTCOMMENT_OPERATORDASHBOARD
Display Field: SUBMITTEDBY_NAME
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 1b50174a3b2b41729bcf47284bfe846a
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 10000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
EVENT_COMMENT_ID
(
type: esriFieldTypeDouble, alias: EVENT_COMMENT_ID
)
-
EVENT_ID
(
type: esriFieldTypeDouble, alias: EVENT_ID
)
-
CREATED_DATE
(
type: esriFieldTypeDate, alias: CREATED_DATE, length: 8
)
-
CREATED_BY
(
type: esriFieldTypeString, alias: CREATED_BY, length: 128
)
-
MODIFIED_DATE
(
type: esriFieldTypeDate, alias: MODIFIED_DATE, length: 8
)
-
MODIFIED_BY
(
type: esriFieldTypeString, alias: MODIFIED_BY, length: 128
)
-
MODIFIED_NUM
(
type: esriFieldTypeInteger, alias: MODIFIED_NUM
)
-
SUBMITTEDBY_NAME
(
type: esriFieldTypeString, alias: SUBMITTEDBY_NAME, length: 128
)
-
SUBMITTED_DATE
(
type: esriFieldTypeDate, alias: SUBMITTED_DATE, length: 8
)
-
COMMENTTYPE_ID
(
type: esriFieldTypeDouble, alias: COMMENTTYPE_ID
)
-
COMMENT_TEXT
(
type: esriFieldTypeString, alias: COMMENT_TEXT, length: 1000
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata