Name: GISDeptTest.dbo.tblWorkOrder
Display Field: ReqUserDept
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 12023c06f64b4493a140798550421f7e
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
workorderid
(
type: esriFieldTypeOID, alias: WorkOrderID
)
-
workorderno
(
type: esriFieldTypeInteger, alias: workorderno
)
-
reqtypeid
(
type: esriFieldTypeInteger, alias: reqtypeid
)
-
requserid
(
type: esriFieldTypeInteger, alias: requserid
)
-
requserdept
(
type: esriFieldTypeString, alias: requserdept, length: 30
)
-
requserdeptid
(
type: esriFieldTypeInteger, alias: requserdeptid
)
-
otherrequestor
(
type: esriFieldTypeString, alias: otherrequestor, length: 50
)
-
mapareainterest
(
type: esriFieldTypeString, alias: mapareainterest, length: 1073741822
)
-
reqcomment
(
type: esriFieldTypeString, alias: reqcomment, length: 1073741822
)
-
urgencytypeid
(
type: esriFieldTypeInteger, alias: urgencytypeid
)
-
dateneed
(
type: esriFieldTypeDate, alias: dateneed, length: 8
)
-
datetime
(
type: esriFieldTypeString, alias: datetime, length: 10
)
-
datetimeid
(
type: esriFieldTypeInteger, alias: datetimeid
)
-
timeused
(
type: esriFieldTypeDouble, alias: TimeUsed
)
-
completed
(
type: esriFieldTypeSmallInteger, alias: completed
)
-
completedate
(
type: esriFieldTypeDate, alias: completedate, length: 8
)
-
completenotes
(
type: esriFieldTypeString, alias: completenotes, length: 1073741822
)
-
mgrcomment
(
type: esriFieldTypeString, alias: mgrcomment, length: 1073741822
)
-
assigntoid
(
type: esriFieldTypeInteger, alias: assigntoid
)
-
assigndate
(
type: esriFieldTypeDate, alias: assigndate, length: 8
)
-
cdate
(
type: esriFieldTypeDate, alias: cdate, length: 8
)
-
mdate
(
type: esriFieldTypeDate, alias: mdate, length: 8
)
-
muser
(
type: esriFieldTypeInteger, alias: muser
)
-
mgruserid
(
type: esriFieldTypeInteger, alias: mgruserid
)
-
mgrdatetime
(
type: esriFieldTypeDate, alias: mgrdatetime, length: 8
)
-
point_x
(
type: esriFieldTypeDouble, alias: point_x
)
-
point_y
(
type: esriFieldTypeDouble, alias: point_y
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata