invantive documentation
Forum di supporto InvantiveAccedi / Registrati

StatisticsIncremental: Freshservice Statistics on Incremental Tables

insert update delete

  • Catalogo: Freshservice
  • Schema: Freshservice
  • Chiavi primarie: id
  • Label: Statistics on Incremental Tables

È possibile recuperare e modificare i dati utilizzando insert, update e delete.

Tickets.

Colonne della tabella

Di seguito sono riportate le colonne della tabella StatisticsIncremental. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
action_code varchar2 itgen_freshservice_action_code
bytes_retrieved int64 itgen_freshservice_bytes_retrieved
created_at datetime itgen_freshservice_created_at
download_group_name varchar2 itgen_freshservice_download_group_name
download_uid guid itgen_freshservice_download_uid
end_date_utc datetime itgen_freshservice_end_date_utc
end_overall_date_last_updated_utc datetime itgen_freshservice_end_overall_date_last_updated_utc
error_message varchar2 itgen_freshservice_error_message
first_date_last_updated_utc datetime itgen_freshservice_first_date_last_updated_utc
first_ticket_id int64 itgen_freshservice_first_ticket_id
from_cache char itgen_freshservice_from_cache
last_date_last_updated_utc datetime itgen_freshservice_last_date_last_updated_utc
last_ticket_id int64 itgen_freshservice_last_ticket_id
max_date_last_updated_utc datetime itgen_freshservice_max_date_last_updated_utc
max_ticket_id int64 itgen_freshservice_max_ticket_id
min_date_last_updated_utc datetime itgen_freshservice_min_date_last_updated_utc
min_ticket_id int64 itgen_freshservice_min_ticket_id
page_number int32 itgen_freshservice_page_number
page_registration_date_utc datetime itgen_freshservice_page_registration_date_utc
page_rows_added_count int64 itgen_freshservice_page_rows_added_count
page_rows_count int64 itgen_freshservice_page_rows_count
page_rows_overwritten_count int64 itgen_freshservice_page_rows_overwritten_count
pages_retrieved int32 itgen_freshservice_pages_retrieved
paging_code varchar2 itgen_freshservice_paging_code
rows_retrieved int64 itgen_freshservice_rows_retrieved
start_date_utc datetime itgen_freshservice_start_date_utc
start_overall_date_last_updated_utc datetime itgen_freshservice_start_overall_date_last_updated_utc
success_flag char itgen_freshservice_success_flag
table_name varchar2 itgen_freshservice_table_name
uid guid itgen_freshservice_uid
updated_since_utc datetime itgen_freshservice_updated_since_utc
url varchar2 itgen_freshservice_url

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: