Name: GISDeptTest.dbo.tblWorkOrder

Display Field: ReqUserDept

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cf83c53c91fb402c8b5829ae6594f10b

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

• workorderid ( type: esriFieldTypeOID, alias: WorkOrderID, editable: false, nullable: false, defaultValue: null, modelName: WorkOrderID )
• workorderno ( type: esriFieldTypeInteger, alias: workorderno, editable: true, nullable: true, defaultValue: null, modelName: workorderno )
• reqtypeid ( type: esriFieldTypeInteger, alias: reqtypeid, editable: true, nullable: true, defaultValue: null, modelName: reqtypeid )
• requserid ( type: esriFieldTypeInteger, alias: requserid, editable: true, nullable: true, defaultValue: null, modelName: requserid )
• requserdept ( type: esriFieldTypeString, alias: requserdept, editable: true, nullable: true, length: 30, defaultValue: null, modelName: requserdept )
• requserdeptid ( type: esriFieldTypeInteger, alias: requserdeptid, editable: true, nullable: true, defaultValue: null, modelName: requserdeptid )
• otherrequestor ( type: esriFieldTypeString, alias: otherrequestor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: otherrequestor )
• mapareainterest ( type: esriFieldTypeString, alias: mapareainterest, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mapareainterest )
• reqcomment ( type: esriFieldTypeString, alias: reqcomment, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: reqcomment )
• urgencytypeid ( type: esriFieldTypeInteger, alias: urgencytypeid, editable: true, nullable: true, defaultValue: null, modelName: urgencytypeid )
• dateneed ( type: esriFieldTypeDate, alias: dateneed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateneed )
• datetime ( type: esriFieldTypeString, alias: datetime, editable: true, nullable: true, length: 10, defaultValue: null, modelName: datetime )
• datetimeid ( type: esriFieldTypeInteger, alias: datetimeid, editable: true, nullable: true, defaultValue: null, modelName: datetimeid )
• timeused ( type: esriFieldTypeDouble, alias: TimeUsed, editable: true, nullable: true, defaultValue: null, modelName: timeused )
• completed ( type: esriFieldTypeSmallInteger, alias: completed, editable: true, nullable: true, defaultValue: null, modelName: completed )
• completedate ( type: esriFieldTypeDate, alias: completedate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: completedate )
• completenotes ( type: esriFieldTypeString, alias: completenotes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: completenotes )
• mgrcomment ( type: esriFieldTypeString, alias: mgrcomment, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mgrcomment )
• assigntoid ( type: esriFieldTypeInteger, alias: assigntoid, editable: true, nullable: true, defaultValue: null, modelName: assigntoid )
• assigndate ( type: esriFieldTypeDate, alias: assigndate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: assigndate )
• cdate ( type: esriFieldTypeDate, alias: cdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cdate )
• mdate ( type: esriFieldTypeDate, alias: mdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: mdate )
• muser ( type: esriFieldTypeInteger, alias: muser, editable: true, nullable: true, defaultValue: null, modelName: muser )
• mgruserid ( type: esriFieldTypeInteger, alias: mgruserid, editable: true, nullable: true, defaultValue: null, modelName: mgruserid )
• mgrdatetime ( type: esriFieldTypeDate, alias: mgrdatetime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: mgrdatetime )
• point_x ( type: esriFieldTypeDouble, alias: point_x, editable: true, nullable: true, defaultValue: null, modelName: point_x )
• point_y ( type: esriFieldTypeDouble, alias: point_y, editable: true, nullable: true, defaultValue: null, modelName: point_y )

Templates:

• Name: GISDeptTest.dbo.tblWorkOrder
  Description:
  Prototype:
  point_x: null
  point_y: null
  workorderno: null
  reqtypeid: null
  requserid: null
  requserdept: null
  requserdeptid: null
  otherrequestor: null
  mapareainterest: null
  reqcomment: null
  urgencytypeid: null
  dateneed: null
  datetime: null
  datetimeid: null
  timeused: null
  completed: null
  completedate: null
  completenotes: null
  mgrcomment: null
  assigntoid: null
  assigndate: null
  cdate: null
  mdate: null
  muser: null
  mgruserid: null
  mgrdatetime: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata