price_person - "Kundensprezifischer Preis" 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 "price_person".
Other retrievable fields of price_person are:
'prcpers_id' - (INT, 11) ,
'fk_prcpers_pcode' - (TEXT, 127) Produktcode,
'fk_prcpers_persid' - (INT, 11) Kunde,
'fk_prcpers_shopid' - (INT, 11) Shop,
'prcpers_price' - (FLOAT, 13,2) Brutto-Preis,
'prcpers_discount' - (FLOAT, 13,2) Discountpreis,
'prcpers_discount_start' - (DATETIME) Discount gültig ab,
'prcpers_discount_end' - (DATETIME) Discount gültig bis,
'fk_prcpers_prcgrp_id' - (INT, 11) Preisgruppe,
'prcpers_dsc_scale' - (DATA) Preisstaffel,
'prcpers_state' - (INT, 3) Kundenpreis Status,
'prcpers_state_color' - (TEXT, 15) ,
'prcpers_xdata' - (DATA) ,
'prcpers_insert_time' - (DATETIME) Angelegt am,
'prcpers_insert_user' - (TEXT, 127) Ersteller,
'prcpers_update_time' - (DATETIME) Geändert am,
'prcpers_update_user' - (TEXT, 127) Letzte Änderung durch,
'vat' - (FLOAT, 6,2) ,
'personid' - (TEXT) Kunden-Nr.,
'persid' - (INT, 11) PersID,
'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,
'fk_p_companyaccount_parent_persid' - (INT) Firmenaccount,
'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,
'p_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
'p_shopuserright_profiles' - (TEXT) Benutzer-Rollen,
'p_shopuserright_rights' - (TEXT) Benutzer-Rechte,
#}
{% set dataList = hublify.dataset('price_person')
.fields([
'prcpers_id',
'fk_prcpers_pcode',
])
.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 "price_person".
Other retrievable fields of price_person are:
'prcpers_id' - (INT, 11) ,
'fk_prcpers_pcode' - (TEXT, 127) Produktcode,
'fk_prcpers_persid' - (INT, 11) Kunde,
'fk_prcpers_shopid' - (INT, 11) Shop,
'prcpers_price' - (FLOAT, 13,2) Brutto-Preis,
'prcpers_discount' - (FLOAT, 13,2) Discountpreis,
'prcpers_discount_start' - (DATETIME) Discount gültig ab,
'prcpers_discount_end' - (DATETIME) Discount gültig bis,
'fk_prcpers_prcgrp_id' - (INT, 11) Preisgruppe,
'prcpers_dsc_scale' - (DATA) Preisstaffel,
'prcpers_state' - (INT, 3) Kundenpreis Status,
'prcpers_state_color' - (TEXT, 15) ,
'prcpers_xdata' - (DATA) ,
'prcpers_insert_time' - (DATETIME) Angelegt am,
'prcpers_insert_user' - (TEXT, 127) Ersteller,
'prcpers_update_time' - (DATETIME) Geändert am,
'prcpers_update_user' - (TEXT, 127) Letzte Änderung durch,
'vat' - (FLOAT, 6,2) ,
'personid' - (TEXT) Kunden-Nr.,
'persid' - (INT, 11) PersID,
'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,
'fk_p_companyaccount_parent_persid' - (INT) Firmenaccount,
'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,
'p_merchant_xdata' - (DATA) Anbieter (Zusatzdaten),
'p_shopuserright_profiles' - (TEXT) Benutzer-Rollen,
'p_shopuserright_rights' - (TEXT) Benutzer-Rechte,
#}
{% set dataList = hublify.dataset('price_person')
.fields([
'prcpers_id',
'fk_prcpers_pcode',
])
.filter('prcpers_id','<something>')
.one()
%}
api(). ... - create
For how-to insert a record...
api(). ... - update
For how-to update a record...
WHAT ELSE, you'd like ??
...