invantive documentation
Invantive Support ForumsLog In / Sign Up

TicketMessagesAll: Teamleader Focus Ticket Messages

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Ticket Messages

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table TicketMessagesAll are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
body varchar2 Body filters on the platform, writable
created_at datetime Created at filters on the platform, writable
message_id varchar2 Message ID filters on the platform, writable
sent_by_id varchar2 Sent By ID filters on the platform, writable
ticket_assignee_id varchar2 Assignee ID filters on the platform, writable
ticket_c_escalatie char itgen_teamleader_c_escalatie filters on the platform, writable
ticket_c_testtext varchar2 itgen_teamleader_c_testtext filters on the platform, writable
ticket_closed_at datetime Closed at filters on the platform, writable
ticket_created_at datetime Created at filters on the platform, writable
ticket_customer_id varchar2 Customer ID filters on the platform, writable
ticket_id varchar2 ID filters on the platform, writable
ticket_last_message_at datetime Last Message at filters on the platform, writable
ticket_milestone_id varchar2 Milestone ID filters on the platform, writable
ticket_participant_customer_id varchar2 Participant Customer ID filters on the platform, writable
ticket_project_id varchar2 Project ID filters on the platform, writable
ticket_reference int32 Reference filters on the platform, writable
ticket_status_id varchar2 Status ID filters on the platform, writable
ticket_subject varchar2 Subject filters on the platform, writable
type varchar2 Type filters on the platform, writable One of customer, internal or thirdParty.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: