Loading ...

Dynamic Data Widget | Axero Documentation

Home » axero documentation » Wiki » Documentation » Control Panel » System » Page Builder » Page Builder Widgets » Dynamic Data Widget
Axero Documentation  Wiki
Public Space
Activity Stream Content
Version 18

Dynamic Data Widget

0 
 /5
0 (0votes)

The dynamic data widget connects to a SQL database, executes a query, and displays the data in a template you select. The widget can also parse data from the URL to use in the query. With this functionality, you can create a page with a list of data and then link each data item to another page builder page that displays detailed data about the record. For a real-world example of how to use the Dynamic Data Widget, check out our Product Data Example.

All data this widget consumes is added to the search index and can be searched from within Axero.

Enable the Dynamic Data Widget

To enable the dynamic data widget in Page Builder:

  1. Go to Control Panel > System > System Properties.
  2. Search for DynamicDataWidgetEnabledInPageBuilder.
  3. Set the value to true > Save.

Set Dynamic Data Sync Interval

You can configure how frequently the dynamic data is synchronized with the search index by setting the interval for the sync service:

  1. Go to Control Panel > System > System Properties.
  2. Search for DynamicDataIndexSyncManagerInterval.
  3. Enter the desired interval in minutes (default is 5 minutes) to set how often the dynamic data sync service will run. Click Save.

This setup ensures that dynamic data remains up-to-date in the search index, providing users with accurate and current data.

Example SQL Data Source

Example Widget

Configuration

Properties

Property Description
Title The widget title appears at the top of the widget
ConnectionString Use Axero Database. If you select this option, you do not need to enter a connection string.

Use Custom Database
The connection string format is:
Initial Catalog=CATALOG;Server=SERVER;User ID=USERID;Password=PASSWORD;
Query The query made to the database. Note: The columns in the query and the Page Builder template should match the case.
Query Params To Parse From URL The parameters to parse from the URL
URL Format The URL format specifies the order the parameters are in
URL Segment The parameters to parse from the URL

Advanced

Field Description
Icon Select an icon to display with the widget (Requires a template that uses {{IconCSSClass}})
Custom CSS class A CSS class to append to the widget
Show Header Check to show the widget's header, which includes the title
Show Footer Check to show the widget's footer
Hide Container Border Check to hide the widget's border
Index Unique ID Deprecated - Do not use.
Index Query Deprecated - Do not use.
ID Column Deprecated - Do not use.
Title Column Deprecated - Do not use.
Summary Column Deprecated - Do not use.

Roles

Choose the roles that can view this widget.

Dynamic Data Widget Example

Product Data Example 

Wiki Index

Pages