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

             Other retrievable fields of product are:
                       'xc__active' - (INT, 1) Aktiv,
                       'xc__searchable' - (INT, 1) Suchbar,
                       'xc__version' - (INT, 11) Version,
                       'xc__current' - (INT, 1) Aktuell,
                       'xc__insert_user' - (TEXT, 127) Ersteller,
                       'xc__insert_time' - (DATETIME) Angelegt am,
                       'xc__valid' - (INT, 1) Valide,
                       'xc__update_time' - (DATETIME) Geändert am,
                       'xc__install_time' - (DATETIME) Installiert am,
                       'xc__publish_start' - (DATETIME) Veröffentlichung (Start),
                       'xc__publish_end' - (DATETIME) Veröffentlichung (Ende),
                       'xc__update_user' - (TEXT, 127) Letzte Änderung durch,
                       'xc__ecms_data' - (TEXT) eCMS-Daten,
                       'xc__id' - (INT, 11) ID,
                       'drvd_xc_display' - (TEXT) Titel,
                       'drvd_is_master' - (INT, 1) Ist Masterprodukt,
                       'drvd_categories' - (DATA) Kategorien,
                       'category_code_list' - (TEXT) Kategoriecode-Liste,
                       'category_path_list' - (TEXT) Kategoriepfad-Liste,
                       'node_id' - (INT) ,
                       'node_code' - (TEXT, 63) ,
                       'node_path' - (TEXT) Kategoriepfad,
                       'node_idfather' - (INT, 11) ,
                       'ngr_id' - (INT, 11) ,
                       'lft' - (INT, 11) ,
                       'rgt' - (INT, 11) ,
                       'drvd_category_code' - (TEXT) Kategorie-Code,
                       'drvd_category_id' - (INT) ,
                       'drvd_category_name' - (TEXT) Kategorie-Name,
                       'drvd_category_path' - (TEXT) Kategorie-Pfad,
                       'pcode' - (TEXT) Produktcode,
                       'name' - (TEXT) Name,
                       'master_pcode' - (TEXT) Varianten-Master PCode,
                       'prdv_color' - (TEXT) Varianten-Farbe,
                       'prdv_size' - (TEXT) Varianten-Größe,
                       'prdv_other' - (TEXT) Varianten-Ausführung,
                       'prd_comment' - (TEXT) Kommentar,
                       'files_doc' - (DATA) Produkt-Dateien,
                       'pack_amount' - (FLOAT) Verpackungs­menge,
                       'pack_unit' - (TEXT) Verpackungs­einheit,
                       'prd_ingr_amount' - (FLOAT) Verpackungs­inhalt (Menge),
                       'prd_ingr_unit' - (TEXT) Verpackungs­inhalt (Einheit),
                       'prd_weight' - (FLOAT) Produktgewicht,
                       'prd_virtual' - (TEXT) Virtuelles Produkt,
                       'products_replace' - (DATA) Nachfolge­produkte,
                       'pcode_manufacturer' - (TEXT) Hersteller-PCode,
                       'brand' - (TEXT) Brand,
                       'products_upselling' - (DATA) Upselling-Produkte,
                       'products_related' - (DATA) Zugehörige Produkte,
                       'orderitem_name' - (TEXT) Auftrags­posten-Name,
                       'orderitem_text' - (TEXT) Auftrags­posten-Text,
                       'marketing_name' - (TEXT) Marketing-Name,
                       'marketing_teaser' - (TEXT) Marketing-Teaser,
                       'marketing_image' - (DATA) Marketing-Bild,
                       'new_product' - (TEXT) Neues Produkt?,
                       'special_offer_product' - (TEXT) Special-Offer Produkt?,
                       'plugin' - (TEXT) Plugin,
                       'meta_title' - (TEXT) Produkt-Meta-Titel,
                       'meta_keywords' - (TEXT) Produkt-Meta-Keywords,
                       'meta_description' - (TEXT) Produkt-Meta-Beschreibung,
                       'meta_robots_noindex' - (TEXT) Produkt-Meta-Robots-NoIndex,
                       'meta_robots_nofollow' - (TEXT) Produkt-Meta-Robots-NoFollow,
                       'marketing_image_background' - (DATA) Marketing-Hintergrundbild,
                       'marketing_overlay_html' - (TEXT) Marketing-Overlay-HTML,
                       'description_seo' - (TEXT) SEO-Beschreibung,
                       'prd_width' - (FLOAT) Produktgröße - Breite,
                       'prd_height' - (FLOAT) Produktgröße - Höhe,
                       'prd_depth' - (FLOAT) Produktgröße - Tiefe,
                       'prd_rating_avg' - (FLOAT) ,
                       'prd_rating_cnt' - (TEXT) ,
                       'convertable_pack_unit' - (DATA) ,
                       'prd_accounting_cost_center' - (TEXT) Buchhaltung Kostenstelle,
                       'prd_accounting_revenue_account' - (TEXT) Buchhaltung Erlöskonto,
                       'base_color' - (TEXT) Grundfarbe,
                       'html_canonical' - (TEXT) ,
                       'pack_size_width' - (TEXT) Verpackungs­größe - Breite,
                       'pack_size_height' - (TEXT) Verpackungs­größe - Höhe,
                       'pack_size_depth' - (TEXT) Verpackungs­größe - Tiefe,
                       'pack_weight' - (FLOAT) Verpackungs­gewicht,
                       'features' - (DATA) ,
                       'drvd_features__feature__label' - (text, 255) ,
                       'drvd_features__feature__name' - (text) ,
                       'drvd_features__feature__short_description' - (text) ,
                       'drvd_features__feature__description' - (text) ,
                       'drvd_features__feature__type' - (text, 63) ,
                       'gtin' - (TEXT) GTIN/EAN,
                       'ppn' - (TEXT) PPN,
                       'origin_country' - (TEXT) Ursprungsland,
                       'customs_tariff_number' - (TEXT) HS-Tariff-Code,
                       'customs_value_amount' - (TEXT) ,
                       'customs_description' - (TEXT) Zoll-Beschreibung,
                       'files_download' - (DATA) Download-Dateien,
                       'products_contain' - (DATA) Produkte im Bundle,
                       'prd_keywords' - (TEXT) Keywords,
                       'files_img' - (DATA) Bilder,
                       'prd_bundle_price_discount_perc' - (FLOAT) Bundle-Preis %-Discount,
                       'desc_short' - (TEXT) Kurz­beschreibung,
                       'description' - (TEXT) Beschreibung,
                       'prd_snr_xdata_subtype' - (TEXT) Zusatzdaten-Typ,
                       'prd_bundle_resolve_mode' - (TEXT) Bundle-Modus,
                       'desc_tech' - (TEXT) Technische Beschreibung,
                       'manufacturer' - (TEXT) Hersteller,
                       'xc__label' - (TEXT) ,
                       'xc__title' - (TEXT) ,
                       'xc__image' - (DATA) ,
                       'drvd_pagealias_master_url' - (TEXT) Seiten-Alias Master,
                       'drvd_pagealias_alternative_url' - (TEXT) Seiten-Alias Alternativen,
                       'prc_id' - (INT, 11) Preis-ID,
                       'state' - (INT, 3) Shop Status,
                       'state_color' - (TEXT, 15) Shop Status - Farbe,
                       'price' - (FLOAT, 13,2) Preis (Brutto),
                       'vat' - (FLOAT, 6,2) Mehrwertsteuer,
                       'discount' - (FLOAT, 13,2) Discount-Preis (Brutto),
                       'discount_text' - (TEXT) Discount-Text,
                       'discount_start' - (DATETIME) Discount Startdatum,
                       'discount_end' - (DATETIME) Discount Enddatum,
                       'drvd_price_netto' - (FLOAT, 13,2) Netto Preis,
                       'drvd_price_discount_netto' - (FLOAT, 13,2) Discount Netto Preis,
                       'drvd_current_price_brutto' - (FLOAT, 13,2) Aktueller Brutto­preis,
                       'drvd_discount_diff_brutto' - (FLOAT, 13,2) Discount Preisminderung (brutto),
                       'drvd_current_price_netto' - (FLOAT, 13,2) Aktueller Netto­preis,
                       'drvd_discount_diff_netto' - (FLOAT, 13,2) Discount Preisminderung (netto),
                       'drvd_currently_discounted' - (INT, 1) ,
                       'price_dsc_scale' - (DATA) Preis-Staffel,
                       'fk_prc_prcgrp_id' - (INT, 11) Preis-Gruppe,
                       'price_wholesale' - (FLOAT, 13,2) EK (Netto),
                       'drvd_prd_margin_gross' - (FLOAT, 11,2) Handelsspanne,
                       'drvd_prd_profit_perc' - (FLOAT, 11,2) Gewinn Marge,
                       'drvd_prd_profit' - (FLOAT, 13,4) Gewinn,
                       'prd_storage_counter' - (FLOAT, 13,4) Lager­bestand,
                       'prd_storage_counter_update_time' - (DATETIME) Letzte Bestands­aktualisierung,
                       'drvd_storage_wholesale_value' - (FLOAT, 13,2) ,
                       'drvd_storage_brutto_value' - (FLOAT, 13,2) ,
                       'drvd_storage_netto_value' - (FLOAT, 13,2) ,
                       'drvd_storage_profit_value' - (FLOAT, 13,2) ,
                       'prd_storage_limit_notify' - (FLOAT, 13,4) Info geringer Bestand,
                       'prd_storage_limit_reorder' - (FLOAT, 13,4) Info Nachbestellung,
                       'order_quanti_max' - (FLOAT, 13,4) Max. Bestellmenge,
                       'order_quanti_min' - (FLOAT, 13,4) Min. Bestellmenge,
                       'order_quanti_inc' - (FLOAT, 13,4) Schritt Bestellmenge,
                       'offer_level' - (INT, 11) Offer-Level,
                       'prd_delivery' - (TEXT)  Lieferhinweis,
                       'searchable' - (INT, 1) Suchbar,
                       'single_buy' - (INT, 1) Kaufbar,
                       'available_date' - (DATETIME) Verfügbar ab,
                       'hide_price_dsp' - (INT, 1) Preis ausblenden,
                       'bookable' - (INT, 1) Vorbestellung möglich,
                       'free_shipping' - (TEXT) Versand­kosten­frei,
                       'xdata' - (DATA) Zusatzdaten,
                       'price_first_online' - (DATETIME) Erstmalig gelistet am,
                       'prc_insert_time' - (DATETIME) Angelegt am,
                       'prc_insert_user' - (TEXT, 127) Ersteller,
                       'prc_update_time' - (DATETIME) Geändert am,
                       'prc_update_user' - (TEXT, 127) Letzte Änderung durch,
                       'prc_external_id' - (TEXT, 63) Externe Preis-ID,
                       'prc_configurator_adaptor' - (TEXT) Konfiguration-Typ,
                       'prc_configurator_params' - (TEXT) Konfiguration,
                       'drvd_variant_specification' - (TEXT) Ausprägung,
                       'currency' - (TEXT) ,
                       'xc__drvd_category' - (TEXT) Kategorie (depr.),
                       'pos_n2i' - (INT) ,
                       'drvd_fk_prc_prcgrp_id' - (TEXT, 127) Preisgruppe (%col_name%),
                #}
          {% set dataList = hublify.dataset('product')
              .fields([
                  'pcode',
                  '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 "product".

             Other retrievable fields of product are:
                       'xc__active' - (INT, 1) Aktiv,
                       'xc__searchable' - (INT, 1) Suchbar,
                       'xc__version' - (INT, 11) Version,
                       'xc__current' - (INT, 1) Aktuell,
                       'xc__insert_user' - (TEXT, 127) Ersteller,
                       'xc__insert_time' - (DATETIME) Angelegt am,
                       'xc__valid' - (INT, 1) Valide,
                       'xc__update_time' - (DATETIME) Geändert am,
                       'xc__install_time' - (DATETIME) Installiert am,
                       'xc__publish_start' - (DATETIME) Veröffentlichung (Start),
                       'xc__publish_end' - (DATETIME) Veröffentlichung (Ende),
                       'xc__update_user' - (TEXT, 127) Letzte Änderung durch,
                       'xc__ecms_data' - (TEXT) eCMS-Daten,
                       'xc__id' - (INT, 11) ID,
                       'drvd_xc_display' - (TEXT) Titel,
                       'drvd_is_master' - (INT, 1) Ist Masterprodukt,
                       'drvd_categories' - (DATA) Kategorien,
                       'category_code_list' - (TEXT) Kategoriecode-Liste,
                       'category_path_list' - (TEXT) Kategoriepfad-Liste,
                       'node_id' - (INT) ,
                       'node_code' - (TEXT, 63) ,
                       'node_path' - (TEXT) Kategoriepfad,
                       'node_idfather' - (INT, 11) ,
                       'ngr_id' - (INT, 11) ,
                       'lft' - (INT, 11) ,
                       'rgt' - (INT, 11) ,
                       'drvd_category_code' - (TEXT) Kategorie-Code,
                       'drvd_category_id' - (INT) ,
                       'drvd_category_name' - (TEXT) Kategorie-Name,
                       'drvd_category_path' - (TEXT) Kategorie-Pfad,
                       'pcode' - (TEXT) Produktcode,
                       'name' - (TEXT) Name,
                       'master_pcode' - (TEXT) Varianten-Master PCode,
                       'prdv_color' - (TEXT) Varianten-Farbe,
                       'prdv_size' - (TEXT) Varianten-Größe,
                       'prdv_other' - (TEXT) Varianten-Ausführung,
                       'prd_comment' - (TEXT) Kommentar,
                       'files_doc' - (DATA) Produkt-Dateien,
                       'pack_amount' - (FLOAT) Verpackungs­menge,
                       'pack_unit' - (TEXT) Verpackungs­einheit,
                       'prd_ingr_amount' - (FLOAT) Verpackungs­inhalt (Menge),
                       'prd_ingr_unit' - (TEXT) Verpackungs­inhalt (Einheit),
                       'prd_weight' - (FLOAT) Produktgewicht,
                       'prd_virtual' - (TEXT) Virtuelles Produkt,
                       'products_replace' - (DATA) Nachfolge­produkte,
                       'pcode_manufacturer' - (TEXT) Hersteller-PCode,
                       'brand' - (TEXT) Brand,
                       'products_upselling' - (DATA) Upselling-Produkte,
                       'products_related' - (DATA) Zugehörige Produkte,
                       'orderitem_name' - (TEXT) Auftrags­posten-Name,
                       'orderitem_text' - (TEXT) Auftrags­posten-Text,
                       'marketing_name' - (TEXT) Marketing-Name,
                       'marketing_teaser' - (TEXT) Marketing-Teaser,
                       'marketing_image' - (DATA) Marketing-Bild,
                       'new_product' - (TEXT) Neues Produkt?,
                       'special_offer_product' - (TEXT) Special-Offer Produkt?,
                       'plugin' - (TEXT) Plugin,
                       'meta_title' - (TEXT) Produkt-Meta-Titel,
                       'meta_keywords' - (TEXT) Produkt-Meta-Keywords,
                       'meta_description' - (TEXT) Produkt-Meta-Beschreibung,
                       'meta_robots_noindex' - (TEXT) Produkt-Meta-Robots-NoIndex,
                       'meta_robots_nofollow' - (TEXT) Produkt-Meta-Robots-NoFollow,
                       'marketing_image_background' - (DATA) Marketing-Hintergrundbild,
                       'marketing_overlay_html' - (TEXT) Marketing-Overlay-HTML,
                       'description_seo' - (TEXT) SEO-Beschreibung,
                       'prd_width' - (FLOAT) Produktgröße - Breite,
                       'prd_height' - (FLOAT) Produktgröße - Höhe,
                       'prd_depth' - (FLOAT) Produktgröße - Tiefe,
                       'prd_rating_avg' - (FLOAT) ,
                       'prd_rating_cnt' - (TEXT) ,
                       'convertable_pack_unit' - (DATA) ,
                       'prd_accounting_cost_center' - (TEXT) Buchhaltung Kostenstelle,
                       'prd_accounting_revenue_account' - (TEXT) Buchhaltung Erlöskonto,
                       'base_color' - (TEXT) Grundfarbe,
                       'html_canonical' - (TEXT) ,
                       'pack_size_width' - (TEXT) Verpackungs­größe - Breite,
                       'pack_size_height' - (TEXT) Verpackungs­größe - Höhe,
                       'pack_size_depth' - (TEXT) Verpackungs­größe - Tiefe,
                       'pack_weight' - (FLOAT) Verpackungs­gewicht,
                       'features' - (DATA) ,
                       'drvd_features__feature__label' - (text, 255) ,
                       'drvd_features__feature__name' - (text) ,
                       'drvd_features__feature__short_description' - (text) ,
                       'drvd_features__feature__description' - (text) ,
                       'drvd_features__feature__type' - (text, 63) ,
                       'gtin' - (TEXT) GTIN/EAN,
                       'ppn' - (TEXT) PPN,
                       'origin_country' - (TEXT) Ursprungsland,
                       'customs_tariff_number' - (TEXT) HS-Tariff-Code,
                       'customs_value_amount' - (TEXT) ,
                       'customs_description' - (TEXT) Zoll-Beschreibung,
                       'files_download' - (DATA) Download-Dateien,
                       'products_contain' - (DATA) Produkte im Bundle,
                       'prd_keywords' - (TEXT) Keywords,
                       'files_img' - (DATA) Bilder,
                       'prd_bundle_price_discount_perc' - (FLOAT) Bundle-Preis %-Discount,
                       'desc_short' - (TEXT) Kurz­beschreibung,
                       'description' - (TEXT) Beschreibung,
                       'prd_snr_xdata_subtype' - (TEXT) Zusatzdaten-Typ,
                       'prd_bundle_resolve_mode' - (TEXT) Bundle-Modus,
                       'desc_tech' - (TEXT) Technische Beschreibung,
                       'manufacturer' - (TEXT) Hersteller,
                       'xc__label' - (TEXT) ,
                       'xc__title' - (TEXT) ,
                       'xc__image' - (DATA) ,
                       'drvd_pagealias_master_url' - (TEXT) Seiten-Alias Master,
                       'drvd_pagealias_alternative_url' - (TEXT) Seiten-Alias Alternativen,
                       'prc_id' - (INT, 11) Preis-ID,
                       'state' - (INT, 3) Shop Status,
                       'state_color' - (TEXT, 15) Shop Status - Farbe,
                       'price' - (FLOAT, 13,2) Preis (Brutto),
                       'vat' - (FLOAT, 6,2) Mehrwertsteuer,
                       'discount' - (FLOAT, 13,2) Discount-Preis (Brutto),
                       'discount_text' - (TEXT) Discount-Text,
                       'discount_start' - (DATETIME) Discount Startdatum,
                       'discount_end' - (DATETIME) Discount Enddatum,
                       'drvd_price_netto' - (FLOAT, 13,2) Netto Preis,
                       'drvd_price_discount_netto' - (FLOAT, 13,2) Discount Netto Preis,
                       'drvd_current_price_brutto' - (FLOAT, 13,2) Aktueller Brutto­preis,
                       'drvd_discount_diff_brutto' - (FLOAT, 13,2) Discount Preisminderung (brutto),
                       'drvd_current_price_netto' - (FLOAT, 13,2) Aktueller Netto­preis,
                       'drvd_discount_diff_netto' - (FLOAT, 13,2) Discount Preisminderung (netto),
                       'drvd_currently_discounted' - (INT, 1) ,
                       'price_dsc_scale' - (DATA) Preis-Staffel,
                       'fk_prc_prcgrp_id' - (INT, 11) Preis-Gruppe,
                       'price_wholesale' - (FLOAT, 13,2) EK (Netto),
                       'drvd_prd_margin_gross' - (FLOAT, 11,2) Handelsspanne,
                       'drvd_prd_profit_perc' - (FLOAT, 11,2) Gewinn Marge,
                       'drvd_prd_profit' - (FLOAT, 13,4) Gewinn,
                       'prd_storage_counter' - (FLOAT, 13,4) Lager­bestand,
                       'prd_storage_counter_update_time' - (DATETIME) Letzte Bestands­aktualisierung,
                       'drvd_storage_wholesale_value' - (FLOAT, 13,2) ,
                       'drvd_storage_brutto_value' - (FLOAT, 13,2) ,
                       'drvd_storage_netto_value' - (FLOAT, 13,2) ,
                       'drvd_storage_profit_value' - (FLOAT, 13,2) ,
                       'prd_storage_limit_notify' - (FLOAT, 13,4) Info geringer Bestand,
                       'prd_storage_limit_reorder' - (FLOAT, 13,4) Info Nachbestellung,
                       'order_quanti_max' - (FLOAT, 13,4) Max. Bestellmenge,
                       'order_quanti_min' - (FLOAT, 13,4) Min. Bestellmenge,
                       'order_quanti_inc' - (FLOAT, 13,4) Schritt Bestellmenge,
                       'offer_level' - (INT, 11) Offer-Level,
                       'prd_delivery' - (TEXT)  Lieferhinweis,
                       'searchable' - (INT, 1) Suchbar,
                       'single_buy' - (INT, 1) Kaufbar,
                       'available_date' - (DATETIME) Verfügbar ab,
                       'hide_price_dsp' - (INT, 1) Preis ausblenden,
                       'bookable' - (INT, 1) Vorbestellung möglich,
                       'free_shipping' - (TEXT) Versand­kosten­frei,
                       'xdata' - (DATA) Zusatzdaten,
                       'price_first_online' - (DATETIME) Erstmalig gelistet am,
                       'prc_insert_time' - (DATETIME) Angelegt am,
                       'prc_insert_user' - (TEXT, 127) Ersteller,
                       'prc_update_time' - (DATETIME) Geändert am,
                       'prc_update_user' - (TEXT, 127) Letzte Änderung durch,
                       'prc_external_id' - (TEXT, 63) Externe Preis-ID,
                       'prc_configurator_adaptor' - (TEXT) Konfiguration-Typ,
                       'prc_configurator_params' - (TEXT) Konfiguration,
                       'drvd_variant_specification' - (TEXT) Ausprägung,
                       'currency' - (TEXT) ,
                       'xc__drvd_category' - (TEXT) Kategorie (depr.),
                       'pos_n2i' - (INT) ,
                       'drvd_fk_prc_prcgrp_id' - (TEXT, 127) Preisgruppe (%col_name%),
                #}
          {% set dataList = hublify.dataset('product')
              .fields([
                  'pcode',
                  'pcode',
              ])
              .filter('pcode','<something>')
              .one()
          %}
      

api(). ... - create

For how-to insert a record...

api(). ... - update

For how-to update a record...

WHAT ELSE, you'd like ??

...