campaign - "Kampagne" Hublify-CMS - Template Examples
Below you can find some auto-generated examples for direct use within your Hublify-CMS' twig templates.
dataset().all()
Hint: For best performance, retrieve only those fields you really need!
Autogenerated twig-templating source code:
{# Get all records from dataset "campaign".
Other retrievable fields of campaign are:
'campid' - (INT, 11) ,
'fk_camp_shopid' - (INT, 11) Shop,
'camp_name' - (TEXT, 127) Kampagnen-Name,
'camp_short_desc' - (TEXT, 127) Kurzbeschreibung,
'camp_objective' - (TEXT, 65536) Zielsetzung,
'camp_desc' - (TEXT) Beschreibung,
'camp_active' - (INT, 2) Aktiv,
'camp_color' - (TEXT, 31) Farbcode,
'camp_time_start' - (DATETIME) Startzeit,
'camp_time_end' - (DATETIME) Endzeit,
'camp_urlvarvalue' - (TEXT, 31) URL Variablenwert,
'camp_source' - (TEXT, 31) Quelle,
'camp_medium' - (TEXT, 31) Medium,
'camp_term' - (TEXT, 31) Begriff,
'camp_content' - (TEXT, 31) Inhalt,
'camp_campaign' - (TEXT, 31) Zusatz-Name,
'camp_track_interval' - (INT, 11) Erkennungszeitraum,
'camp_trackvars' - (TEXT) Tracking-Variablen,
'camp_tracing_javascript' - (TEXT) Verfolgungs-Javascript,
'camp_tracing_code' - (TEXT) Verfolgungs-Code,
'camp_external_id' - (TEXT, 63) Externer Kampagnen-Id,
'camp_external_src' - (TEXT, 127) Externer Kampagnen-Quelle,
'camp_person_grpid' - (INT, 11) Kundengruppe,
'camp_prc_col' - (TEXT, 63) Preisspalte,
'camp_prc_mode' - (TEXT, 7) Preismodus,
'camp_expected_order_revenue' - (FLOAT, 13,4) Erwarteter Umsatz (Order),
'camp_expected_order_cnt' - (INT, 11) Erwartete Anzahl (Order),
'camp_expected_lead_cnt' - (INT, 11) Erwartete Anzahl (Leads),
'camp_expected_impression_cnt' - (INT, 11) Erwartete Impressions,
'camp_expected_costs' - (FLOAT, 13,4) Erwartete Kosten,
'camp_costs_actual' - (FLOAT, 13,4) Kosten - aktuell,
'camp_costs_initial' - (FLOAT, 13,4) Kosten, einmalig,
'camp_costs_po_abs' - (FLOAT, 13,4) Kosten pro Order, absolut (CPO-a),
'camp_costs_po_perc' - (FLOAT, 8,4) Kosten pro Order, prozentual (CPO-p),
'camp_costs_pi_abs' - (FLOAT, 13,4) Kosten pro Impression, absolut (CPI),
'camp_commission_initial' - (FLOAT, 13,4) Provision, einmalig,
'camp_commission_po_abs' - (FLOAT, 13,4) Provision per Order, absolut,
'camp_commission_po_perc' - (FLOAT, 8,4) Provision per Order, prozentual,
'camp_commission_pi_abs' - (FLOAT, 13,4) Provision pro Impression,
'camp_progress_data' - (DATA) Verlaufsdaten,
'camp_insert_user' - (TEXT, 127) Ersteller,
'camp_update_user' - (TEXT, 127) Letzte Änderung durch,
'camp_time_insert' - (DATETIME) Angelegt am,
'camp_time_update' - (DATETIME) Geändert am,
'drvd_camp_difftime_end_day' - (INT, 11) Zeit bis Ende,
#}
{% set dataList = hublify.dataset('campaign')
.fields([
'campid',
'camp_name',
])
.filter('','<something>')
.limit(10)
.all()
%}
dataset().one()
Hint: For best performance, retrieve only those fields you really need!
Autogenerated twig-templating source code:
{# Get one record from dataset "campaign".
Other retrievable fields of campaign are:
'campid' - (INT, 11) ,
'fk_camp_shopid' - (INT, 11) Shop,
'camp_name' - (TEXT, 127) Kampagnen-Name,
'camp_short_desc' - (TEXT, 127) Kurzbeschreibung,
'camp_objective' - (TEXT, 65536) Zielsetzung,
'camp_desc' - (TEXT) Beschreibung,
'camp_active' - (INT, 2) Aktiv,
'camp_color' - (TEXT, 31) Farbcode,
'camp_time_start' - (DATETIME) Startzeit,
'camp_time_end' - (DATETIME) Endzeit,
'camp_urlvarvalue' - (TEXT, 31) URL Variablenwert,
'camp_source' - (TEXT, 31) Quelle,
'camp_medium' - (TEXT, 31) Medium,
'camp_term' - (TEXT, 31) Begriff,
'camp_content' - (TEXT, 31) Inhalt,
'camp_campaign' - (TEXT, 31) Zusatz-Name,
'camp_track_interval' - (INT, 11) Erkennungszeitraum,
'camp_trackvars' - (TEXT) Tracking-Variablen,
'camp_tracing_javascript' - (TEXT) Verfolgungs-Javascript,
'camp_tracing_code' - (TEXT) Verfolgungs-Code,
'camp_external_id' - (TEXT, 63) Externer Kampagnen-Id,
'camp_external_src' - (TEXT, 127) Externer Kampagnen-Quelle,
'camp_person_grpid' - (INT, 11) Kundengruppe,
'camp_prc_col' - (TEXT, 63) Preisspalte,
'camp_prc_mode' - (TEXT, 7) Preismodus,
'camp_expected_order_revenue' - (FLOAT, 13,4) Erwarteter Umsatz (Order),
'camp_expected_order_cnt' - (INT, 11) Erwartete Anzahl (Order),
'camp_expected_lead_cnt' - (INT, 11) Erwartete Anzahl (Leads),
'camp_expected_impression_cnt' - (INT, 11) Erwartete Impressions,
'camp_expected_costs' - (FLOAT, 13,4) Erwartete Kosten,
'camp_costs_actual' - (FLOAT, 13,4) Kosten - aktuell,
'camp_costs_initial' - (FLOAT, 13,4) Kosten, einmalig,
'camp_costs_po_abs' - (FLOAT, 13,4) Kosten pro Order, absolut (CPO-a),
'camp_costs_po_perc' - (FLOAT, 8,4) Kosten pro Order, prozentual (CPO-p),
'camp_costs_pi_abs' - (FLOAT, 13,4) Kosten pro Impression, absolut (CPI),
'camp_commission_initial' - (FLOAT, 13,4) Provision, einmalig,
'camp_commission_po_abs' - (FLOAT, 13,4) Provision per Order, absolut,
'camp_commission_po_perc' - (FLOAT, 8,4) Provision per Order, prozentual,
'camp_commission_pi_abs' - (FLOAT, 13,4) Provision pro Impression,
'camp_progress_data' - (DATA) Verlaufsdaten,
'camp_insert_user' - (TEXT, 127) Ersteller,
'camp_update_user' - (TEXT, 127) Letzte Änderung durch,
'camp_time_insert' - (DATETIME) Angelegt am,
'camp_time_update' - (DATETIME) Geändert am,
'drvd_camp_difftime_end_day' - (INT, 11) Zeit bis Ende,
#}
{% set dataList = hublify.dataset('campaign')
.fields([
'campid',
'camp_name',
])
.filter('campid','<something>')
.one()
%}
api(). ... - create
For how-to insert a record...
api(). ... - update
For how-to update a record...
WHAT ELSE, you'd like ??
...