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 "paddress".

             Other retrievable fields of paddress are:
                       'adr_id' - (INT, 11) Adr.Id,
                       'personid' - (TEXT, 32) Kunden-Nr.,
                       'persid' - (INT, 11) Kunde,
                       'adr_ref_id' - (INT, 11) Kundennummer,
                       'drvd_adr_key' - (TEXT) Adresse,
                       'adr_ref_type' - (TEXT, 31) Typ,
                       'adr_gender' - (TEXT) Anrede,
                       'adr_gender_color' - (TEXT, 15) ,
                       'adr_title' - (TEXT) Titel,
                       'adr_firstname' - (TEXT) Vorname,
                       'adr_lastname' - (TEXT) Nachname,
                       'adr_company' - (TEXT) Firma,
                       'adr_extra1' - (TEXT) Adressenzusatz,
                       'adr_street' - (TEXT) Straße,
                       'adr_housenr' - (TEXT) Hausnr.,
                       'adr_zip' - (TEXT) PLZ,
                       'adr_town' - (TEXT) Ort,
                       'adr_state_code' - (TEXT, 15) Bundesland (Code),
                       'adr_country' - (TEXT, 3) Land,
                       'drvd_adr_address' - (TEXT) Adresse,
                       'adr_time_insert' - (DATETIME) Angelegt am,
                       'adr_time_update' - (DATETIME) Geändert am,
                       'drvd_adr_state_name' - (TEXT) Bundesland,
                       'drvd_adr_state_path' - (TEXT) Bundesland (Pfad),
                       'fk_p_grpid' - (INT, 11) Kundengruppe,
                       'fk_p_shopid' - (INT, 11) Shop,
                       'gender' - (TEXT) Anrede,
                       'gender_color' - (TEXT, 15) ,
                       'title' - (TEXT) Titel,
                       'salutation' - (TEXT) Anrede formal,
                       'firstname' - (TEXT) Vorname,
                       'lastname' - (TEXT) Nachname,
                       'bday' - (DATE) Geburtsdatum,
                       'drvd_age' - (INT) Alter,
                       'drvd_bday_days_until_next' - (INT) Nächster Geburtstag (in Tagen),
                       'drvd_bday_next' - (DATE) Nächster Geburtstag,
                       'company' - (TEXT) Firma,
                       'p_department' - (TEXT) Abteilung,
                       'p_job_position' - (TEXT) Position,
                       'address2' - (TEXT) Adressenzusatz,
                       'street' - (TEXT) Straße,
                       'housenr' - (TEXT) Hausnummer,
                       'zip' - (TEXT) PLZ,
                       'town' - (TEXT) Ort,
                       'state_code' - (TEXT, 15) Bundesland (Code),
                       'country' - (TEXT, 2) Land,
                       'drvd_person_name' - (TEXT) Kundenname (kombiniert),
                       'drvd_p_address' - (TEXT) Adresse,
                       'email' - (TEXT, 127) E-Mail,
                       'telephone' - (TEXT) Telefon,
                       'telephone_mobile' - (TEXT) Tel. mobil,
                       'telefax' - (TEXT) Fax,
                       'p_invoice_type' - (TEXT) Rechnungsart,
                       'p_invoice_email' - (TEXT) E-Mail (Rechnung),
                       'taxident' - (TEXT) Umsatzsteuer-ID,
                       'taxident_status' - (TEXT) Umsatzsteuer-ID-Status,
                       'score' - (INT, 7) Bonitätswert,
                       'score_time_set' - (DATETIME) Letzter Rating-Check,
                       'score_time_invalid' - (DATETIME) Abgelaufen am,
                       'svc_code' - (TEXT) Rating ServiceCode,
                       'svc_txt' - (TEXT) Rating ServiceText,
                       'p_login_username' - (TEXT, 63) Benutzername,
                       'p_login_pwd_encrypted' - (TEXT) Passwort (verschlüsselt),
                       'p_login_pwd_key' - (TEXT) Direct-Login-Token,
                       'p_login_time_last' - (DATETIME) Letzter Login,
                       'p_login_pwd_must_renew_after' - (DATETIME) Passwort-Änderung auffordern ab,
                       'p_login_pwd_key_timeout' - (DATETIME) Direct-Login-Token Timeout,
                       'p_login_pwd_last_renewed' - (DATETIME) Passwort zuletzt geändert,
                       'p_login_active' - (INT, 1) Aktiv,
                       'p_email_verify_token' - (TEXT, 32) ,
                       'p_email_verify_token_timeout' - (DATETIME) ,
                       'p_email_verified_time' - (DATETIME) ,
                       'p_login_mode' - (TEXT, 15) Login-Modus,
                       'p_login_2fa_code' - (TEXT) 2FA - Login Code,
                       'p_login_2fa_timeout' - (DATETIME) 2FA - Login Code Timeout,
                       'p_login_err_count' - (INT, 4) Anzahl Fehllogins,
                       'p_login_time_min' - (DATETIME) Login Sperrzeit,
                       'p_register_state' - (TEXT, 15) Registrierungsstatus,
                       'p_register_code' - (TEXT, 32) Registrierungscode,
                       'p_register_code_timeout' - (DATETIME) Registrierungscode Timeout,
                       'p_onetime_pwd' - (TEXT) Einmal-Passwort,
                       'p_onetime_pwd_timeout' - (DATETIME) Einmal-Passwort Timeout,
                       'p_login_state' - (TEXT, 15) Login Status,
                       'p_login_state_color' - (TEXT, 15) ,
                       'p_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_p_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'fk_p_prcgrp_id' - (INT, 11) Preisgruppe,
                       'p_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'p_person_prices' - (INT, 1) Persönliche Preise,
                       'fk_p_campid' - (INT, 11) Kampagne,
                       'p_allow_email_marketing' - (INT, 1) Zustimmung zu Marketing-Mails,
                       'drvd_emailmarketing_unsubscribetoken' - (TEXT) Token für Direktabmeldung Marketingmails,
                       'p_ip_address' - (TEXT, 15) IP-Adresse,
                       'p_referrer' - (TEXT) Referrer,
                       'p_useragent' - (TEXT) User Agent,
                       'p_personid_external' - (TEXT, 127) Externe Kunden-Nr.,
                       'p_comment_internal' - (TEXT) Interner Kommentar,
                       'p_locale' - (DATA) Locale Kunde,
                       'p_volfile' - (DATA) ,
                       'time_insert' - (DATETIME) Angelegt am,
                       'user_insert' - (TEXT, 127) Ersteller,
                       'time_update' - (DATETIME) Geändert am,
                       'user_update' - (TEXT, 127) Letzte Änderung durch,
                       'drvd_timeonly_timeinsert' - (TEXT) Angelegt (Uhrzeit),
                       'p_anonymize_time' - (DATETIME) Anoymisiert am,
                       'grpid' - (INT, 11) ,
                       'grp_name' - (TEXT, 127) Kundengruppe,
                       'description' - (TEXT) Beschreibung,
                       'grp_default' - (INT, 1) Default,
                       'grp_p_login_active' - (INT, 1) Kundenlogin Default Aktiv,
                       'grp_locale' - (DATA) Locale Kundengruppe,
                       'grp_state' - (TEXT, 63) Bestellstatus,
                       'grp_pos' - (TEXT, 63) POS Channel,
                       'prc_display_mode' - (TEXT, 15) Preisanzeige,
                       'grp_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'fk_grp_prcgrp_id' - (INT, 11) Standard-Preisgruppe,
                       'grp_persongrp_prices' - (INT, 1) Gruppenspezifische Preise,
                       'grp_price_col' - (TEXT, 31) Preisspalte,
                       'grp_discount_col' - (TEXT, 63) Preisspalte (Discount),
                       'grp_discount_start_col' - (TEXT, 63) Preisspalte (Discount Start),
                       'grp_discount_end_col' - (TEXT, 63) Preisspalte (Discount Ende),
                       'grp_price_dsc_scale_col' - (TEXT, 63) Preisspalte (Staffelpreise),
                       'grp_price_prcgrp_col' - (TEXT, 63) Preisgruppen-Spalte,
                       'grp_price_state_col' - (TEXT, 63) Spalte für Shop-Status
,
                       'grp_price_hide_price_dsp_col' - (TEXT, 63) Spalte für Preis ausblenden,
                       'grp_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_grp_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'data' - (DATA) Daten,
                       'grp_shopuserright_profiles' - (TEXT) Gruppen-Rollen,
                       'grp_shopuserright_rights' - (TEXT) Gruppen-Rechte,
                       'fk_p_companyaccount_parent_persid' - (INT) Firmenaccount,
                       'companyaccount_parent_personid' - (TEXT) Firmenaccount Kundennr.,
                       'companyaccount_parent_company' - (TEXT) Firmenaccount Firmenname,
                       'companyaccount_parent_taxident' - (TEXT) Firmenaccount Ust. ID,
                       'companyaccount_parent_street' - (TEXT) Firmenaccount Straße,
                       'companyaccount_parent_housenr' - (TEXT) Firmenaccount Hausnummer,
                       'companyaccount_parent_address2' - (TEXT) Firmenaccount Adresszusatz ,
                       'companyaccount_parent_zip' - (TEXT) Firmenaccount PLZ,
                       'companyaccount_parent_town' - (TEXT) Firmenaccount Ort,
                       'companyaccount_parent_country' - (TEXT) Firmenaccount Land,
                       'p_companyaccount_budget_cart_max' - (FLOAT, 10,2) Budget Warenkorb,
                       'p_companyaccount_cost_center_customer' - (TEXT) Kunden Kostenstelle,
                       'p_companyaccount_type' - (TEXT) ,
                       'p_companyaccount_xdata' - (DATA) ,
                       'p_accounting_debtor_account' - (TEXT) Buchhaltung Debitorenkonto,
                       'fk_pers_inv_reminder_profile' - (TEXT, 127) Mahnprofil,
                       'drvd_pers_inv_reminder_profile_name' - (TEXT, 127) angewendetes Mahnprofil,
                       'p_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
                       'p_shopuserright_profiles' - (TEXT) Benutzer-Rollen,
                       'p_shopuserright_rights' - (TEXT) Benutzer-Rechte,
                       'p_login_pwd_plain' - (TEXT, 64) Neues Passwort,
                       'camp_name' - (TEXT, 127) Kampagne,
                       'campid' - (INT, 11) ,
                       'drvd_order_timelast' - (DATETIME) Letzte Bestellung,
                       'drvd_order_timefirst' - (DATETIME) Erste Bestellung,
                       'drvd_order_frequency' - (FLOAT, 9,2) Bestell­frequenz,
                       'drvd_order_count' - (INT, 11) # Aufträge,
                       'p_profile_photo' - (TEXT) Bild,
                       'cy_locale' - (TEXT) Locale Land,
                       'drvd_person_state_name' - (TEXT) Bundesland (Name),
                       'drvd_person_state_path' - (TEXT) Bundesland (Pfad),
                #}
          {% set dataList = hublify.dataset('paddress')
              .fields([
                  'adr_id',
                  'drvd_adr_key',
              ])
              .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 "paddress".

             Other retrievable fields of paddress are:
                       'adr_id' - (INT, 11) Adr.Id,
                       'personid' - (TEXT, 32) Kunden-Nr.,
                       'persid' - (INT, 11) Kunde,
                       'adr_ref_id' - (INT, 11) Kundennummer,
                       'drvd_adr_key' - (TEXT) Adresse,
                       'adr_ref_type' - (TEXT, 31) Typ,
                       'adr_gender' - (TEXT) Anrede,
                       'adr_gender_color' - (TEXT, 15) ,
                       'adr_title' - (TEXT) Titel,
                       'adr_firstname' - (TEXT) Vorname,
                       'adr_lastname' - (TEXT) Nachname,
                       'adr_company' - (TEXT) Firma,
                       'adr_extra1' - (TEXT) Adressenzusatz,
                       'adr_street' - (TEXT) Straße,
                       'adr_housenr' - (TEXT) Hausnr.,
                       'adr_zip' - (TEXT) PLZ,
                       'adr_town' - (TEXT) Ort,
                       'adr_state_code' - (TEXT, 15) Bundesland (Code),
                       'adr_country' - (TEXT, 3) Land,
                       'drvd_adr_address' - (TEXT) Adresse,
                       'adr_time_insert' - (DATETIME) Angelegt am,
                       'adr_time_update' - (DATETIME) Geändert am,
                       'drvd_adr_state_name' - (TEXT) Bundesland,
                       'drvd_adr_state_path' - (TEXT) Bundesland (Pfad),
                       'fk_p_grpid' - (INT, 11) Kundengruppe,
                       'fk_p_shopid' - (INT, 11) Shop,
                       'gender' - (TEXT) Anrede,
                       'gender_color' - (TEXT, 15) ,
                       'title' - (TEXT) Titel,
                       'salutation' - (TEXT) Anrede formal,
                       'firstname' - (TEXT) Vorname,
                       'lastname' - (TEXT) Nachname,
                       'bday' - (DATE) Geburtsdatum,
                       'drvd_age' - (INT) Alter,
                       'drvd_bday_days_until_next' - (INT) Nächster Geburtstag (in Tagen),
                       'drvd_bday_next' - (DATE) Nächster Geburtstag,
                       'company' - (TEXT) Firma,
                       'p_department' - (TEXT) Abteilung,
                       'p_job_position' - (TEXT) Position,
                       'address2' - (TEXT) Adressenzusatz,
                       'street' - (TEXT) Straße,
                       'housenr' - (TEXT) Hausnummer,
                       'zip' - (TEXT) PLZ,
                       'town' - (TEXT) Ort,
                       'state_code' - (TEXT, 15) Bundesland (Code),
                       'country' - (TEXT, 2) Land,
                       'drvd_person_name' - (TEXT) Kundenname (kombiniert),
                       'drvd_p_address' - (TEXT) Adresse,
                       'email' - (TEXT, 127) E-Mail,
                       'telephone' - (TEXT) Telefon,
                       'telephone_mobile' - (TEXT) Tel. mobil,
                       'telefax' - (TEXT) Fax,
                       'p_invoice_type' - (TEXT) Rechnungsart,
                       'p_invoice_email' - (TEXT) E-Mail (Rechnung),
                       'taxident' - (TEXT) Umsatzsteuer-ID,
                       'taxident_status' - (TEXT) Umsatzsteuer-ID-Status,
                       'score' - (INT, 7) Bonitätswert,
                       'score_time_set' - (DATETIME) Letzter Rating-Check,
                       'score_time_invalid' - (DATETIME) Abgelaufen am,
                       'svc_code' - (TEXT) Rating ServiceCode,
                       'svc_txt' - (TEXT) Rating ServiceText,
                       'p_login_username' - (TEXT, 63) Benutzername,
                       'p_login_pwd_encrypted' - (TEXT) Passwort (verschlüsselt),
                       'p_login_pwd_key' - (TEXT) Direct-Login-Token,
                       'p_login_time_last' - (DATETIME) Letzter Login,
                       'p_login_pwd_must_renew_after' - (DATETIME) Passwort-Änderung auffordern ab,
                       'p_login_pwd_key_timeout' - (DATETIME) Direct-Login-Token Timeout,
                       'p_login_pwd_last_renewed' - (DATETIME) Passwort zuletzt geändert,
                       'p_login_active' - (INT, 1) Aktiv,
                       'p_email_verify_token' - (TEXT, 32) ,
                       'p_email_verify_token_timeout' - (DATETIME) ,
                       'p_email_verified_time' - (DATETIME) ,
                       'p_login_mode' - (TEXT, 15) Login-Modus,
                       'p_login_2fa_code' - (TEXT) 2FA - Login Code,
                       'p_login_2fa_timeout' - (DATETIME) 2FA - Login Code Timeout,
                       'p_login_err_count' - (INT, 4) Anzahl Fehllogins,
                       'p_login_time_min' - (DATETIME) Login Sperrzeit,
                       'p_register_state' - (TEXT, 15) Registrierungsstatus,
                       'p_register_code' - (TEXT, 32) Registrierungscode,
                       'p_register_code_timeout' - (DATETIME) Registrierungscode Timeout,
                       'p_onetime_pwd' - (TEXT) Einmal-Passwort,
                       'p_onetime_pwd_timeout' - (DATETIME) Einmal-Passwort Timeout,
                       'p_login_state' - (TEXT, 15) Login Status,
                       'p_login_state_color' - (TEXT, 15) ,
                       'p_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_p_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'fk_p_prcgrp_id' - (INT, 11) Preisgruppe,
                       'p_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'p_person_prices' - (INT, 1) Persönliche Preise,
                       'fk_p_campid' - (INT, 11) Kampagne,
                       'p_allow_email_marketing' - (INT, 1) Zustimmung zu Marketing-Mails,
                       'drvd_emailmarketing_unsubscribetoken' - (TEXT) Token für Direktabmeldung Marketingmails,
                       'p_ip_address' - (TEXT, 15) IP-Adresse,
                       'p_referrer' - (TEXT) Referrer,
                       'p_useragent' - (TEXT) User Agent,
                       'p_personid_external' - (TEXT, 127) Externe Kunden-Nr.,
                       'p_comment_internal' - (TEXT) Interner Kommentar,
                       'p_locale' - (DATA) Locale Kunde,
                       'p_volfile' - (DATA) ,
                       'time_insert' - (DATETIME) Angelegt am,
                       'user_insert' - (TEXT, 127) Ersteller,
                       'time_update' - (DATETIME) Geändert am,
                       'user_update' - (TEXT, 127) Letzte Änderung durch,
                       'drvd_timeonly_timeinsert' - (TEXT) Angelegt (Uhrzeit),
                       'p_anonymize_time' - (DATETIME) Anoymisiert am,
                       'grpid' - (INT, 11) ,
                       'grp_name' - (TEXT, 127) Kundengruppe,
                       'description' - (TEXT) Beschreibung,
                       'grp_default' - (INT, 1) Default,
                       'grp_p_login_active' - (INT, 1) Kundenlogin Default Aktiv,
                       'grp_locale' - (DATA) Locale Kundengruppe,
                       'grp_state' - (TEXT, 63) Bestellstatus,
                       'grp_pos' - (TEXT, 63) POS Channel,
                       'prc_display_mode' - (TEXT, 15) Preisanzeige,
                       'grp_price_factor' - (FLOAT, 10,4) Preis-Faktor,
                       'fk_grp_prcgrp_id' - (INT, 11) Standard-Preisgruppe,
                       'grp_persongrp_prices' - (INT, 1) Gruppenspezifische Preise,
                       'grp_price_col' - (TEXT, 31) Preisspalte,
                       'grp_discount_col' - (TEXT, 63) Preisspalte (Discount),
                       'grp_discount_start_col' - (TEXT, 63) Preisspalte (Discount Start),
                       'grp_discount_end_col' - (TEXT, 63) Preisspalte (Discount Ende),
                       'grp_price_dsc_scale_col' - (TEXT, 63) Preisspalte (Staffelpreise),
                       'grp_price_prcgrp_col' - (TEXT, 63) Preisgruppen-Spalte,
                       'grp_price_state_col' - (TEXT, 63) Spalte für Shop-Status
,
                       'grp_price_hide_price_dsp_col' - (TEXT, 63) Spalte für Preis ausblenden,
                       'grp_oo_set_label' - (TEXT, 63) Bestelloptionen-Profil,
                       'fk_grp_pay_profile_id' - (INT, 11) Zahlungsziel-Profil,
                       'data' - (DATA) Daten,
                       'grp_shopuserright_profiles' - (TEXT) Gruppen-Rollen,
                       'grp_shopuserright_rights' - (TEXT) Gruppen-Rechte,
                       'fk_p_companyaccount_parent_persid' - (INT) Firmenaccount,
                       'companyaccount_parent_personid' - (TEXT) Firmenaccount Kundennr.,
                       'companyaccount_parent_company' - (TEXT) Firmenaccount Firmenname,
                       'companyaccount_parent_taxident' - (TEXT) Firmenaccount Ust. ID,
                       'companyaccount_parent_street' - (TEXT) Firmenaccount Straße,
                       'companyaccount_parent_housenr' - (TEXT) Firmenaccount Hausnummer,
                       'companyaccount_parent_address2' - (TEXT) Firmenaccount Adresszusatz ,
                       'companyaccount_parent_zip' - (TEXT) Firmenaccount PLZ,
                       'companyaccount_parent_town' - (TEXT) Firmenaccount Ort,
                       'companyaccount_parent_country' - (TEXT) Firmenaccount Land,
                       'p_companyaccount_budget_cart_max' - (FLOAT, 10,2) Budget Warenkorb,
                       'p_companyaccount_cost_center_customer' - (TEXT) Kunden Kostenstelle,
                       'p_companyaccount_type' - (TEXT) ,
                       'p_companyaccount_xdata' - (DATA) ,
                       'p_accounting_debtor_account' - (TEXT) Buchhaltung Debitorenkonto,
                       'fk_pers_inv_reminder_profile' - (TEXT, 127) Mahnprofil,
                       'drvd_pers_inv_reminder_profile_name' - (TEXT, 127) angewendetes Mahnprofil,
                       'p_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
                       'p_shopuserright_profiles' - (TEXT) Benutzer-Rollen,
                       'p_shopuserright_rights' - (TEXT) Benutzer-Rechte,
                       'p_login_pwd_plain' - (TEXT, 64) Neues Passwort,
                       'camp_name' - (TEXT, 127) Kampagne,
                       'campid' - (INT, 11) ,
                       'drvd_order_timelast' - (DATETIME) Letzte Bestellung,
                       'drvd_order_timefirst' - (DATETIME) Erste Bestellung,
                       'drvd_order_frequency' - (FLOAT, 9,2) Bestell­frequenz,
                       'drvd_order_count' - (INT, 11) # Aufträge,
                       'p_profile_photo' - (TEXT) Bild,
                       'cy_locale' - (TEXT) Locale Land,
                       'drvd_person_state_name' - (TEXT) Bundesland (Name),
                       'drvd_person_state_path' - (TEXT) Bundesland (Pfad),
                #}
          {% set dataList = hublify.dataset('paddress')
              .fields([
                  'adr_id',
                  'drvd_adr_key',
              ])
              .filter('adr_id','<something>')
              .one()
          %}
      

api(). ... - create

For how-to insert a record...

api(). ... - update

For how-to update a record...

WHAT ELSE, you'd like ??

...