Name: Workorder

Display Field: status

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 4f369977157d42fab6a6538e28a4504a

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

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 )
• status ( type: esriFieldTypeString, alias: Status, length: 255 , Coded Values: [Closed: Closed] , [Open: Open] )
• datecreated ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• datemodified ( type: esriFieldTypeDate, alias: Date Modified, length: 8 )
• datestart ( type: esriFieldTypeDate, alias: Start Date, length: 8 )
• datedue ( type: esriFieldTypeDate, alias: Due Date, length: 8 )
• usercreated ( type: esriFieldTypeString, alias: Created By, length: 50 , Coded Values: [Mike K: Mike K] , [Steve S: Steve S] , [Reade D: Reade D] , ...17 more... )
• usermodified ( type: esriFieldTypeString, alias: Modified By, length: 50 , Coded Values: [Mike K: Mike K] , [Steve S: Steve S] , [Reade D: Reade D] , ...17 more... )
• title ( type: esriFieldTypeString, alias: Title, length: 255 )
• description ( type: esriFieldTypeString, alias: Description, length: 1000 )
• location ( type: esriFieldTypeString, alias: Location, length: 255 , Coded Values: [tbl_catch_basins: Catch Basins] , [tbl_feed_points: Feed Points] , [tbl_flare_ends: Flared Ends] , ...25 more... )
• category ( type: esriFieldTypeString, alias: Category, length: 50 , Coded Values: [Water: Water] , [Storm: Storm] , [Tree & Forestry: Tree & Forestry] , ...6 more... )
• priority ( type: esriFieldTypeString, alias: Priority, length: 50 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• datecompleted ( type: esriFieldTypeDate, alias: datecompleted, length: 8 )
• relfeatureglobalid ( type: esriFieldTypeGUID, alias: RelFeatureGlobalID, length: 38 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata