StatisticsIncremental: Freshservice Statistics on Incremental Tables
insert update delete
- Katalog:
Freshservice - Schema:
Freshservice - Primärschlüssel:
id - Label: Statistics on Incremental Tables
Mit insert, update und delete können Daten abgerufen und geändert werden.
Zusammenfassung
Tickets.
Tabellenspalten
Die Spalten der Tabelle StatisticsIncremental sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
action_ |
varchar2 |
itgen_freshservice_action_code | |||
bytes_ |
int64 |
itgen_freshservice_bytes_retrieved | |||
created_ |
datetime |
itgen_freshservice_created_at | |||
download_ |
varchar2 |
itgen_freshservice_download_group_name | |||
download_ |
guid |
itgen_freshservice_download_uid | |||
end_ |
datetime |
itgen_freshservice_end_date_utc | |||
end_ |
datetime |
itgen_freshservice_end_overall_date_last_updated_utc | |||
error_ |
varchar2 |
itgen_freshservice_error_message | |||
first_ |
datetime |
itgen_freshservice_first_date_last_updated_utc | |||
first_ |
int64 |
itgen_freshservice_first_ticket_id | |||
from_ |
char |
itgen_freshservice_from_cache | |||
last_ |
datetime |
itgen_freshservice_last_date_last_updated_utc | |||
last_ |
int64 |
itgen_freshservice_last_ticket_id | |||
max_ |
datetime |
itgen_freshservice_max_date_last_updated_utc | |||
max_ |
int64 |
itgen_freshservice_max_ticket_id | |||
min_ |
datetime |
itgen_freshservice_min_date_last_updated_utc | |||
min_ |
int64 |
itgen_freshservice_min_ticket_id | |||
page_ |
int32 |
itgen_freshservice_page_number | |||
page_ |
datetime |
itgen_freshservice_page_registration_date_utc | |||
page_ |
int64 |
itgen_freshservice_page_rows_added_count | |||
page_ |
int64 |
itgen_freshservice_page_rows_count | |||
page_ |
int64 |
itgen_freshservice_page_rows_overwritten_count | |||
pages_ |
int32 |
itgen_freshservice_pages_retrieved | |||
paging_ |
varchar2 |
itgen_freshservice_paging_code | |||
rows_ |
int64 |
itgen_freshservice_rows_retrieved | |||
start_ |
datetime |
itgen_freshservice_start_date_utc | |||
start_ |
datetime |
itgen_freshservice_start_overall_date_last_updated_utc | |||
success_ |
char |
itgen_freshservice_success_flag | |||
table_ |
varchar2 |
itgen_freshservice_table_name | |||
uid |
guid |
itgen_freshservice_uid | |||
updated_ |
datetime |
itgen_freshservice_updated_since_utc | |||
url |
varchar2 |
itgen_freshservice_url |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: