Name: IT_HelpDesk_Ticket

Display Field: TECH_USER_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: bd0a965c45c143198f9c11d09d69cee1

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 )
• JOB_TICKET_ID ( type: esriFieldTypeInteger, alias: JOB_TICKET_ID )
• ASSIGNED_TECH_ID ( type: esriFieldTypeDouble, alias: ASSIGNED_TECH_ID )
• TECH_CLIENT_ID ( type: esriFieldTypeDouble, alias: TECH_CLIENT_ID )
• TECH_DELETED ( type: esriFieldTypeDouble, alias: TECH_DELETED )
• TECH_EMAIL ( type: esriFieldTypeString, alias: TECH_EMAIL, length: 86 )
• TECH_EMPLOYMENT_STATUS ( type: esriFieldTypeString, alias: TECH_EMPLOYMENT_STATUS, length: 50 )
• TECH_FIRST ( type: esriFieldTypeString, alias: TECH_FIRST, length: 59 )
• TECH_LAST ( type: esriFieldTypeString, alias: TECH_LAST, length: 59 )
• TECH_INACTIVE ( type: esriFieldTypeDouble, alias: TECH_INACTIVE )
• TECH_LOCKED ( type: esriFieldTypeDouble, alias: TECH_LOCKED )
• TECH_USER_NAME ( type: esriFieldTypeString, alias: TECH_USER_NAME, length: 65 )
• GroupsAssigned ( type: esriFieldTypeString, alias: GroupsAssigned, length: 210 )
• IT_Team ( type: esriFieldTypeInteger, alias: IT_Team )
• CLIENT_ID ( type: esriFieldTypeDouble, alias: CLIENT_ID )
• CLIENT_FIRST ( type: esriFieldTypeString, alias: CLIENT_FIRST, length: 86 )
• CLIENT_LAST ( type: esriFieldTypeString, alias: CLIENT_LAST, length: 70 )
• CLIENT_DEPARTMENT ( type: esriFieldTypeString, alias: CLIENT_DEPARTMENT, length: 94 )
• LOCATION_NAME ( type: esriFieldTypeString, alias: LOCATION_NAME, length: 102 )
• PRIORITY_TYPE_NAME ( type: esriFieldTypeString, alias: PRIORITY_TYPE_NAME, length: 60 )
• DEPARTMENT_NAME ( type: esriFieldTypeString, alias: DEPARTMENT_NAME, length: 94 )
• STATUS_TYPE_NAME ( type: esriFieldTypeString, alias: STATUS_TYPE_NAME, length: 81 )
• REPORT_DATE ( type: esriFieldTypeDate, alias: REPORT_DATE, length: 8 )
• TicketAgeDays ( type: esriFieldTypeDouble, alias: TicketAgeDays )
• JOB_TIME ( type: esriFieldTypeDouble, alias: JOB_TIME )
• LAST_CLIENT_REMINDER_DATE ( type: esriFieldTypeDate, alias: LAST_CLIENT_REMINDER_DATE, length: 8 )
• LAST_CLIENT_UPDATE ( type: esriFieldTypeDate, alias: LAST_CLIENT_UPDATE, length: 8 )
• LAST_EMAIL_SEND_DATE ( type: esriFieldTypeDate, alias: LAST_EMAIL_SEND_DATE, length: 8 )
• LAST_REMINDER_DATE ( type: esriFieldTypeDate, alias: LAST_REMINDER_DATE, length: 8 )
• LAST_STATUS_UPDATE_TIME ( type: esriFieldTypeDate, alias: LAST_STATUS_UPDATE_TIME, length: 8 )
• LAST_UPDATED ( type: esriFieldTypeDate, alias: LAST_UPDATED, length: 8 )
• WORK_START_DATE ( type: esriFieldTypeDate, alias: WORK_START_DATE, length: 8 )
• WORK_END_DATE ( type: esriFieldTypeDate, alias: WORK_END_DATE, length: 8 )
• SUBJECT ( type: esriFieldTypeString, alias: SUBJECT, length: 304 )
• PROBLEM_TYPE_NAME ( type: esriFieldTypeString, alias: PROBLEM_TYPE_NAME, length: 84 )
• QUESTION_TEXT ( type: esriFieldTypeString, alias: QUESTION_TEXT, length: 4000 )
• FIRST_RESPONSE_DATE ( type: esriFieldTypeDate, alias: FIRST_RESPONSE_DATE, length: 8 )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: CLOSE_DATE, length: 8 )
• Days_Till_Closed ( type: esriFieldTypeDouble, alias: Days_Till_Closed )
• Closed_Year ( type: esriFieldTypeDouble, alias: Closed_Year )
• JOB_TICKET_DELETED ( type: esriFieldTypeInteger, alias: JOB_TICKET_DELETED )
• TECH_NAME ( type: esriFieldTypeString, alias: TECH_NAME, length: 255 )

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

  Iteminfo   Thumbnail   Metadata