person - "Kunde" 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 "person".
Other retrievable fields of person are:
'persid' - (INT, 11) PersID,
'personid' - (TEXT, 32) Kunden-Nr.,
'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) Bestellfrequenz,
'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),
'person_invoice_default__adr_id' - (INT, 11) Adr.Id,
'person_invoice_default__adr_ref_type' - (TEXT, 31) Typ,
'person_invoice_default__adr_gender' - (TEXT) Anrede,
'person_invoice_default__adr_title' - (TEXT) Titel,
'person_invoice_default__adr_firstname' - (TEXT) Vorname,
'person_invoice_default__adr_lastname' - (TEXT) Nachname,
'person_invoice_default__adr_company' - (TEXT) Firma,
'person_invoice_default__adr_extra1' - (TEXT) Adressenzusatz,
'person_invoice_default__adr_street' - (TEXT) Straße,
'person_invoice_default__adr_housenr' - (TEXT) Hausnr.,
'person_invoice_default__adr_zip' - (TEXT) PLZ,
'person_invoice_default__adr_town' - (TEXT) Ort,
'person_invoice_default__adr_state_code' - (TEXT, 15) Bundesland (Code),
'person_invoice_default__adr_time_insert' - (DATETIME) Erstellt am,
'person_invoice_default__adr_time_update' - (DATETIME) Letzte Änderung,
'person_invoice_default__drvd_adr_state_name' - (TEXT) Bundesland,
'person_invoice_default__drvd_adr_state_path' - (TEXT) Bundesland (Pfad),
'person_delivery_default__adr_id' - (INT, 11) Adr.Id,
'person_delivery_default__adr_ref_type' - (TEXT, 31) Typ,
'person_delivery_default__adr_gender' - (TEXT) Anrede,
'person_delivery_default__adr_title' - (TEXT) Titel,
'person_delivery_default__adr_firstname' - (TEXT) Vorname,
'person_delivery_default__adr_lastname' - (TEXT) Nachname,
'person_delivery_default__adr_company' - (TEXT) Firma,
'person_delivery_default__adr_extra1' - (TEXT) Adressenzusatz,
'person_delivery_default__adr_street' - (TEXT) Straße,
'person_delivery_default__adr_housenr' - (TEXT) Hausnr.,
'person_delivery_default__adr_zip' - (TEXT) PLZ,
'person_delivery_default__adr_town' - (TEXT) Ort,
'person_delivery_default__adr_state_code' - (TEXT, 15) Bundesland (Code),
'person_delivery_default__adr_time_insert' - (DATETIME) Erstellt am,
'person_delivery_default__adr_time_update' - (DATETIME) Letzte Änderung,
'person_delivery_default__drvd_adr_state_name' - (TEXT) Bundesland,
'person_delivery_default__drvd_adr_state_path' - (TEXT) Bundesland (Pfad),
#}
{% set dataList = hublify.dataset('person')
.fields([
'persid',
'personid',
])
.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 "person".
Other retrievable fields of person are:
'persid' - (INT, 11) PersID,
'personid' - (TEXT, 32) Kunden-Nr.,
'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) Bestellfrequenz,
'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),
'person_invoice_default__adr_id' - (INT, 11) Adr.Id,
'person_invoice_default__adr_ref_type' - (TEXT, 31) Typ,
'person_invoice_default__adr_gender' - (TEXT) Anrede,
'person_invoice_default__adr_title' - (TEXT) Titel,
'person_invoice_default__adr_firstname' - (TEXT) Vorname,
'person_invoice_default__adr_lastname' - (TEXT) Nachname,
'person_invoice_default__adr_company' - (TEXT) Firma,
'person_invoice_default__adr_extra1' - (TEXT) Adressenzusatz,
'person_invoice_default__adr_street' - (TEXT) Straße,
'person_invoice_default__adr_housenr' - (TEXT) Hausnr.,
'person_invoice_default__adr_zip' - (TEXT) PLZ,
'person_invoice_default__adr_town' - (TEXT) Ort,
'person_invoice_default__adr_state_code' - (TEXT, 15) Bundesland (Code),
'person_invoice_default__adr_time_insert' - (DATETIME) Erstellt am,
'person_invoice_default__adr_time_update' - (DATETIME) Letzte Änderung,
'person_invoice_default__drvd_adr_state_name' - (TEXT) Bundesland,
'person_invoice_default__drvd_adr_state_path' - (TEXT) Bundesland (Pfad),
'person_delivery_default__adr_id' - (INT, 11) Adr.Id,
'person_delivery_default__adr_ref_type' - (TEXT, 31) Typ,
'person_delivery_default__adr_gender' - (TEXT) Anrede,
'person_delivery_default__adr_title' - (TEXT) Titel,
'person_delivery_default__adr_firstname' - (TEXT) Vorname,
'person_delivery_default__adr_lastname' - (TEXT) Nachname,
'person_delivery_default__adr_company' - (TEXT) Firma,
'person_delivery_default__adr_extra1' - (TEXT) Adressenzusatz,
'person_delivery_default__adr_street' - (TEXT) Straße,
'person_delivery_default__adr_housenr' - (TEXT) Hausnr.,
'person_delivery_default__adr_zip' - (TEXT) PLZ,
'person_delivery_default__adr_town' - (TEXT) Ort,
'person_delivery_default__adr_state_code' - (TEXT, 15) Bundesland (Code),
'person_delivery_default__adr_time_insert' - (DATETIME) Erstellt am,
'person_delivery_default__adr_time_update' - (DATETIME) Letzte Änderung,
'person_delivery_default__drvd_adr_state_name' - (TEXT) Bundesland,
'person_delivery_default__drvd_adr_state_path' - (TEXT) Bundesland (Pfad),
#}
{% set dataList = hublify.dataset('person')
.fields([
'persid',
'personid',
])
.filter('persid','<something>')
.one()
%}
api(). ... - create
For how-to insert a record...
api(). ... - update
For how-to update a record...
WHAT ELSE, you'd like ??
...