invantive documentation
Invantive Support ForumsLog In / Sign Up

TicketsAll: Teamleader Focus Tickets

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Tickets

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 TicketsAll 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
assignee_id varchar2 Assignee ID filters on the platform, writable
c_escalatie char itgen_teamleader_c_escalatie filters on the platform, writable
c_testtext varchar2 itgen_teamleader_c_testtext filters on the platform, writable
closed_at datetime Closed at filters on the platform, writable
created_at datetime Created at filters on the platform, writable
customer_id varchar2 Customer ID filters on the platform, writable
id varchar2 ID filters on the platform, writable
last_message_at datetime Last Message at filters on the platform, writable
milestone_id varchar2 Milestone ID filters on the platform, writable
participant_customer_id varchar2 Participant Customer ID filters on the platform, writable
project_id varchar2 Project ID filters on the platform, writable
reference int32 Reference filters on the platform, writable
status_id varchar2 Status ID filters on the platform, writable
subject varchar2 Subject filters on the platform, writable

Release Notes

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