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

             Other retrievable fields of persongroup are:
                       '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,
                       'person_count' - (INT) Kundenanzahl,
                       'time_personlast' - (DATETIME) Kunde zuletzt hinzugefügt am,
                       'time_personfirst' - (DATETIME) Erster Kunde hinzugefügt am,
                       'grp_shopuserright_profiles' - (TEXT) Gruppen-Rollen,
                       'grp_shopuserright_rights' - (TEXT) Gruppen-Rechte,
                       'drvd_grp_prcgrp_label' - (TEXT, 127) Standard-Preisgruppe,
                #}
          {% set dataList = hublify.dataset('persongroup')
              .fields([
                  'grpid',
                  'grp_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 "persongroup".

             Other retrievable fields of persongroup are:
                       '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,
                       'person_count' - (INT) Kundenanzahl,
                       'time_personlast' - (DATETIME) Kunde zuletzt hinzugefügt am,
                       'time_personfirst' - (DATETIME) Erster Kunde hinzugefügt am,
                       'grp_shopuserright_profiles' - (TEXT) Gruppen-Rollen,
                       'grp_shopuserright_rights' - (TEXT) Gruppen-Rechte,
                       'drvd_grp_prcgrp_label' - (TEXT, 127) Standard-Preisgruppe,
                #}
          {% set dataList = hublify.dataset('persongroup')
              .fields([
                  'grpid',
                  'grp_name',
              ])
              .filter('grpid','<something>')
              .one()
          %}
      

api(). ... - create

For how-to insert a record...

api(). ... - update

For how-to update a record...

WHAT ELSE, you'd like ??

...