order - "Auftrag" 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 "order".
Other retrievable fields of order are:
'oid' - (INT, 11) OID,
'fk_o_shopid' - (INT, 11) Shop,
'orderid' - (TEXT, 63) Auftrags-Nr.,
'fk_o_persid' - (INT, 11) Kunde,
'o_time_ordered' - (DATETIME) Bestelldatum,
'total_netto' - (FLOAT, 13,2) ∑ Gesamt, Netto,
'total_brutto' - (FLOAT, 13,2) ∑ Gesamt, Brutto,
'personid' - (TEXT, 32) Kunden-Nr.,
'persid' - (INT, 11) ,
'o_orderid_external' - (TEXT, 255) Externe Auftrags-Nr.,
'fk_o_posid' - (INT, 11) POS Channel (ID),
'fk_o_stid' - (INT, 11) Status,
'fk_o_st_id' - (INT, 11) Versandart,
'o_pers_reftext' - (TEXT) Kunden-Referenztext,
'o_pers_seq_nr' - (INT, 11) Auftrags-Sequenz-Nr.,
'quantity' - (FLOAT, 13,1) Bestellmenge,
'drvd_total_vat' - (FLOAT, 13,2) MwSt. (Gesamt),
'currency' - (TEXT, 3) Währung,
'otitle' - (TEXT) Auftragstitel,
'otext' - (TEXT) Auftragsbeschreibung,
'o_type' - (TEXT, 15) Auftragstyp,
'o_valid_until' - (DATETIME) Gültig bis,
'o_txt_header' - (TEXT) Kopf-Text,
'o_txt_footer' - (TEXT) Fuß-Text,
'invoice_gender' - (TEXT) Anrede (R),
'invoice_title' - (TEXT) Titel (R),
'invoice_firstname' - (TEXT) Vorname (R),
'invoice_lastname' - (TEXT) Nachname (R),
'invoice_company' - (TEXT) Firma (R),
'invoice_addrextra' - (TEXT) Adressenzusatz,
'invoice_street' - (TEXT) Straße (R),
'invoice_housenr' - (TEXT) Hausnummer (R),
'invoice_zip' - (TEXT) PLZ (R),
'invoice_town' - (TEXT) Ort (R),
'invoice_country' - (TEXT, 2) Land (R),
'invoice_type' - (TEXT) Rechnungsart,
'invoice_email' - (TEXT) E-Mail (R),
'invoice_taxidentnumber' - (TEXT) USt.ID-Nr.,
'invoice_taxident_status' - (TEXT) USt.ID-Nr. Status,
'invoice_third_country_export' - (TEXT) Ausfuhrbescheinigung,
'invoice_lang_iso' - (TEXT, 2) Rechnungssprache,
'drvd_invoice_street_housenr' - (TEXT) Straße+Nr (R),
'deliver_gender' - (TEXT) Anrede (L),
'deliver_title' - (TEXT) Titel (L),
'deliver_firstname' - (TEXT) Vorname (L),
'deliver_lastname' - (TEXT) Nachname (L),
'deliver_company' - (TEXT) Firma (L),
'deliver_addrextra' - (TEXT) Adressenzusatz,
'deliver_street' - (TEXT) Straße (L),
'deliver_housenr' - (TEXT) Hausnummer (L),
'deliver_zip' - (TEXT) PLZ (L),
'deliver_town' - (TEXT) Ort (L),
'deliver_country' - (TEXT, 2) Land (L),
'deliver_date_req' - (TEXT) Kunden-Wunschtermin,
'deliver_phone' - (TEXT) Telefon,
'deliver_email' - (TEXT) E-Mail (L),
'deliver_comment' - (TEXT) Liefer-Hinweise,
'drvd_deliver_street_housenr' - (TEXT) Straße+Nr (L),
'deliver_notes_xdata' - (DATA) Lieferhinweise,
'ip_address' - (TEXT) IP-Adresse,
'o_referrer' - (TEXT) Referrer,
'o_useragent' - (TEXT) User-Agent,
'o_comment' - (TEXT) Kundenkommentar,
'o_comment_internal' - (TEXT) Interner Bestellhinweis,
'o_lock_time' - (DATETIME) Bearbeitungs-Sperre (Zeitpunkt),
'o_lock_user' - (TEXT, 31) Bearbeitungs-Sperre (Benutzer),
'o_insert_time' - (DATETIME) Angelegt am,
'o_update_time' - (DATETIME) Geändert am,
'o_insert_user' - (TEXT, 127) Ersteller,
'o_update_user' - (TEXT, 127) Letzte Änderung durch,
'fk_o_campid' - (INT, 11) Kampagne,
'drvd_o_shoplabel' - (TEXT) Shop,
'pos_addrline' - (TEXT) Adresszeile (POS),
'drvd_invoice_address' - (TEXT) Auftrag-Rg.Adresse,
'drvd_deliver_address' - (TEXT) Auftrag-Lfg.Adresse,
'o_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
'fk_o_companyaccount_subaccount_persid' - (INT, 11) Unteraccount,
'companyaccount_subaccount_personid' - (TEXT) Unteraccount Kunden-Nr.,
'companyaccount_subaccount_email' - (TEXT) Unteraccount E-Mail ,
'companyaccount_subaccount_firstname' - (TEXT) Unteraccount Vorname,
'companyaccount_subaccount_lastname' - (TEXT) Unteraccount Nachname,
'fk_o_mrch_id' - (INT, 11) Verkaufender Anbieter,
'fk_o_parent_oid' - (INT, 11) Hauptauftrag,
'drvd_parent_orderid' - (TEXT) Hauptauftrag,
'o_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
'mrch_id' - (INT, 11) ,
'fk_mrch_persid' - (INT, 11) Kundenkonto des Anbieters,
'mrch_code' - (TEXT, 31) Anbieter-Nr.,
'mrch_code_external' - (TEXT) Externe Anbieternr.,
'mrch_name' - (TEXT) Anbietername,
'mrch_description' - (TEXT) Beschreibung,
'mrch_xdata' - (DATA) Zusatzdaten,
'mrch_xsettings' - (DATA) Einstellungen,
'mrch_active' - (INT, 1) Aktiv,
'mrch_insert_user' - (TEXT, 127) Ersteller,
'mrch_update_user' - (TEXT, 127) Letzte Änderung durch,
'mrch_insert_time' - (DATETIME) Angelegt am,
'mrch_update_time' - (DATETIME) Geändert am,
'o_periodic_time_first' - (DATETIME) Abo-Startdatum,
'o_periodic_time_last' - (DATETIME) Abo-Enddatum,
'o_periodic_time_next' - (DATETIME) Nächste Abo-Ausführung,
'o_periodic_timeorder_offset' - (TEXT, 31) Abweichendes Auftragsdatum,
'o_periodic_time_strict' - (INT, 1) Strikt,
'o_periodic_exec_period' - (TEXT, 31) Abo-Intervall,
'o_periodic_exec_inprogress' - (INT, 1) Wird gerade ausgeführt,
'o_periodic_xdata' - (DATA) ,
'drvd_weekday_timeordered' - (TEXT) Wochentag,
'drvd_hour_timeordered' - (TEXT) Stunde,
'drvd_month_timeordered' - (TEXT) Bestellmonat,
'drvd_dayofmonth_timeordered' - (TEXT) Bestelltag im Monat,
'drvd_timeonly_timeordered' - (TEXT) Bestellzeit,
'drvd_cluster_seq' - (TEXT) Erst-/Wiederkauf,
'campaign_name' - (TEXT, 127) Kampagne,
'shipping_type_label' - (TEXT, 63) Versandart,
'shipping_type_grp_name' - (TEXT, 63) Versandart-Gruppe,
'shipping_type_deliver_category' - (TEXT, 31) Lieferkategorie,
'order_state_transtime' - (DATETIME) Transaktionszeit,
'order_state_code' - (TEXT, 63) Auftragsstatus (Code),
'order_state_color' - (TEXT, 15) Status-Farbe,
'order_state_name' - (TEXT) Auftragsstatus (Name),
'order_state_name_public' - (TEXT) Auftragsstatus (öffentlicher Name),
'posid' - (INT, 11) ,
'pos_name' - (TEXT, 127) POS Channel,
'pos_shortdesc' - (TEXT) Kurzbeschreibung,
'available' - (INT, 1) Verfügbar,
'default_pos' - (INT, 1) Default,
'pos_xsettings' - (DATA) Einstellungen,
'pos_insert_user' - (TEXT, 127) Ersteller,
'pos_update_user' - (TEXT, 127) Letzte Änderung durch,
'pos_insert_time' - (DATETIME) Angelegt am,
'pos_update_time' - (DATETIME) Geändert am,
'api_channel_token' - (TEXT) API-Channel-Token,
'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,
'datasetaddedfield' - (TEXT) ,
#}
{% set dataList = hublify.dataset('order')
.fields([
'oid',
'orderid',
])
.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 "order".
Other retrievable fields of order are:
'oid' - (INT, 11) OID,
'fk_o_shopid' - (INT, 11) Shop,
'orderid' - (TEXT, 63) Auftrags-Nr.,
'fk_o_persid' - (INT, 11) Kunde,
'o_time_ordered' - (DATETIME) Bestelldatum,
'total_netto' - (FLOAT, 13,2) ∑ Gesamt, Netto,
'total_brutto' - (FLOAT, 13,2) ∑ Gesamt, Brutto,
'personid' - (TEXT, 32) Kunden-Nr.,
'persid' - (INT, 11) ,
'o_orderid_external' - (TEXT, 255) Externe Auftrags-Nr.,
'fk_o_posid' - (INT, 11) POS Channel (ID),
'fk_o_stid' - (INT, 11) Status,
'fk_o_st_id' - (INT, 11) Versandart,
'o_pers_reftext' - (TEXT) Kunden-Referenztext,
'o_pers_seq_nr' - (INT, 11) Auftrags-Sequenz-Nr.,
'quantity' - (FLOAT, 13,1) Bestellmenge,
'drvd_total_vat' - (FLOAT, 13,2) MwSt. (Gesamt),
'currency' - (TEXT, 3) Währung,
'otitle' - (TEXT) Auftragstitel,
'otext' - (TEXT) Auftragsbeschreibung,
'o_type' - (TEXT, 15) Auftragstyp,
'o_valid_until' - (DATETIME) Gültig bis,
'o_txt_header' - (TEXT) Kopf-Text,
'o_txt_footer' - (TEXT) Fuß-Text,
'invoice_gender' - (TEXT) Anrede (R),
'invoice_title' - (TEXT) Titel (R),
'invoice_firstname' - (TEXT) Vorname (R),
'invoice_lastname' - (TEXT) Nachname (R),
'invoice_company' - (TEXT) Firma (R),
'invoice_addrextra' - (TEXT) Adressenzusatz,
'invoice_street' - (TEXT) Straße (R),
'invoice_housenr' - (TEXT) Hausnummer (R),
'invoice_zip' - (TEXT) PLZ (R),
'invoice_town' - (TEXT) Ort (R),
'invoice_country' - (TEXT, 2) Land (R),
'invoice_type' - (TEXT) Rechnungsart,
'invoice_email' - (TEXT) E-Mail (R),
'invoice_taxidentnumber' - (TEXT) USt.ID-Nr.,
'invoice_taxident_status' - (TEXT) USt.ID-Nr. Status,
'invoice_third_country_export' - (TEXT) Ausfuhrbescheinigung,
'invoice_lang_iso' - (TEXT, 2) Rechnungssprache,
'drvd_invoice_street_housenr' - (TEXT) Straße+Nr (R),
'deliver_gender' - (TEXT) Anrede (L),
'deliver_title' - (TEXT) Titel (L),
'deliver_firstname' - (TEXT) Vorname (L),
'deliver_lastname' - (TEXT) Nachname (L),
'deliver_company' - (TEXT) Firma (L),
'deliver_addrextra' - (TEXT) Adressenzusatz,
'deliver_street' - (TEXT) Straße (L),
'deliver_housenr' - (TEXT) Hausnummer (L),
'deliver_zip' - (TEXT) PLZ (L),
'deliver_town' - (TEXT) Ort (L),
'deliver_country' - (TEXT, 2) Land (L),
'deliver_date_req' - (TEXT) Kunden-Wunschtermin,
'deliver_phone' - (TEXT) Telefon,
'deliver_email' - (TEXT) E-Mail (L),
'deliver_comment' - (TEXT) Liefer-Hinweise,
'drvd_deliver_street_housenr' - (TEXT) Straße+Nr (L),
'deliver_notes_xdata' - (DATA) Lieferhinweise,
'ip_address' - (TEXT) IP-Adresse,
'o_referrer' - (TEXT) Referrer,
'o_useragent' - (TEXT) User-Agent,
'o_comment' - (TEXT) Kundenkommentar,
'o_comment_internal' - (TEXT) Interner Bestellhinweis,
'o_lock_time' - (DATETIME) Bearbeitungs-Sperre (Zeitpunkt),
'o_lock_user' - (TEXT, 31) Bearbeitungs-Sperre (Benutzer),
'o_insert_time' - (DATETIME) Angelegt am,
'o_update_time' - (DATETIME) Geändert am,
'o_insert_user' - (TEXT, 127) Ersteller,
'o_update_user' - (TEXT, 127) Letzte Änderung durch,
'fk_o_campid' - (INT, 11) Kampagne,
'drvd_o_shoplabel' - (TEXT) Shop,
'pos_addrline' - (TEXT) Adresszeile (POS),
'drvd_invoice_address' - (TEXT) Auftrag-Rg.Adresse,
'drvd_deliver_address' - (TEXT) Auftrag-Lfg.Adresse,
'o_pay_profile_xdata' - (DATA) Zahlungsziel-Daten,
'fk_o_companyaccount_subaccount_persid' - (INT, 11) Unteraccount,
'companyaccount_subaccount_personid' - (TEXT) Unteraccount Kunden-Nr.,
'companyaccount_subaccount_email' - (TEXT) Unteraccount E-Mail ,
'companyaccount_subaccount_firstname' - (TEXT) Unteraccount Vorname,
'companyaccount_subaccount_lastname' - (TEXT) Unteraccount Nachname,
'fk_o_mrch_id' - (INT, 11) Verkaufender Anbieter,
'fk_o_parent_oid' - (INT, 11) Hauptauftrag,
'drvd_parent_orderid' - (TEXT) Hauptauftrag,
'o_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
'mrch_id' - (INT, 11) ,
'fk_mrch_persid' - (INT, 11) Kundenkonto des Anbieters,
'mrch_code' - (TEXT, 31) Anbieter-Nr.,
'mrch_code_external' - (TEXT) Externe Anbieternr.,
'mrch_name' - (TEXT) Anbietername,
'mrch_description' - (TEXT) Beschreibung,
'mrch_xdata' - (DATA) Zusatzdaten,
'mrch_xsettings' - (DATA) Einstellungen,
'mrch_active' - (INT, 1) Aktiv,
'mrch_insert_user' - (TEXT, 127) Ersteller,
'mrch_update_user' - (TEXT, 127) Letzte Änderung durch,
'mrch_insert_time' - (DATETIME) Angelegt am,
'mrch_update_time' - (DATETIME) Geändert am,
'o_periodic_time_first' - (DATETIME) Abo-Startdatum,
'o_periodic_time_last' - (DATETIME) Abo-Enddatum,
'o_periodic_time_next' - (DATETIME) Nächste Abo-Ausführung,
'o_periodic_timeorder_offset' - (TEXT, 31) Abweichendes Auftragsdatum,
'o_periodic_time_strict' - (INT, 1) Strikt,
'o_periodic_exec_period' - (TEXT, 31) Abo-Intervall,
'o_periodic_exec_inprogress' - (INT, 1) Wird gerade ausgeführt,
'o_periodic_xdata' - (DATA) ,
'drvd_weekday_timeordered' - (TEXT) Wochentag,
'drvd_hour_timeordered' - (TEXT) Stunde,
'drvd_month_timeordered' - (TEXT) Bestellmonat,
'drvd_dayofmonth_timeordered' - (TEXT) Bestelltag im Monat,
'drvd_timeonly_timeordered' - (TEXT) Bestellzeit,
'drvd_cluster_seq' - (TEXT) Erst-/Wiederkauf,
'campaign_name' - (TEXT, 127) Kampagne,
'shipping_type_label' - (TEXT, 63) Versandart,
'shipping_type_grp_name' - (TEXT, 63) Versandart-Gruppe,
'shipping_type_deliver_category' - (TEXT, 31) Lieferkategorie,
'order_state_transtime' - (DATETIME) Transaktionszeit,
'order_state_code' - (TEXT, 63) Auftragsstatus (Code),
'order_state_color' - (TEXT, 15) Status-Farbe,
'order_state_name' - (TEXT) Auftragsstatus (Name),
'order_state_name_public' - (TEXT) Auftragsstatus (öffentlicher Name),
'posid' - (INT, 11) ,
'pos_name' - (TEXT, 127) POS Channel,
'pos_shortdesc' - (TEXT) Kurzbeschreibung,
'available' - (INT, 1) Verfügbar,
'default_pos' - (INT, 1) Default,
'pos_xsettings' - (DATA) Einstellungen,
'pos_insert_user' - (TEXT, 127) Ersteller,
'pos_update_user' - (TEXT, 127) Letzte Änderung durch,
'pos_insert_time' - (DATETIME) Angelegt am,
'pos_update_time' - (DATETIME) Geändert am,
'api_channel_token' - (TEXT) API-Channel-Token,
'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,
'datasetaddedfield' - (TEXT) ,
#}
{% set dataList = hublify.dataset('order')
.fields([
'oid',
'orderid',
])
.filter('oid','<something>')
.one()
%}
api(). ... - create
For how-to insert a record...
api(). ... - update
For how-to update a record...
WHAT ELSE, you'd like ??
...