Loading ...

Dynamic Data Widget | Communifire Documentation

Home » communifire documentation » Wiki » Documentation » Control Panel » System » Page Builder » Page Builder Widgets » Dynamic Data Widget
Communifire Documentation  Wiki
Public Space
Activity Stream Content
Version 14

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, then link each item of data to another page builder page that display detailed data about the record. For a real world example on how to use the Dynamic Data Widget, check out our Product Data Example .

All data consumed by this widget is also added to the search index and can be searched from within Communifire.

To enable the dynamic data widget, go to Control Panel > System > System Properties and set DynamicDataWidgetEnabledInPageBuilder to true.

Example SQL Data Source

Example Widget

Configuration

Properties

Property Description
Title The widget title appears at the top of the widget
ConnectionString Use Communifire 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 in the Page Builder template should match case.
Query Params To Parse From URL The parameters to parse from the URL
URL Format The URL format specifies the order the paramaters 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 

Comments (1)

   
amoharram
Ahmad Moharram

Hello,

Dynamic data widget is not working even widget header doesn't appear even after enabling DynamicDataWidgetEnabledInPageBuilder from system properties, any suggestions?

 

Ahmad Moharram

8/6/2018 01:50 PM
 · 
Comment
by
   
gskamau
Grace Kamau Axero Solutions

Hey Ahmad,

Did you add all the widget properties and create a template for the widget? See steps 1 and 2 in Product Data Example for all the steps necessary for displaying a dynamic data widget.

Grace

8/6/2018 04:55 PM
 · 
Comment
by
   
amoharram
Ahmad Moharram

Hi Grace,

Yes I have doubled checked but it is not working even if we supposed that there is an error in the database connection, at least the widget header must appear in the page.

Also, I have copied the "Add Product List Template" code and placed it a Dynamic property widget (i know it will not work) but at least the widget and table headers appeared which means that the code is working and proves that Dynamic data is not working.

Ahmad

8/6/2018 06:37 PM
 · 
Comment
by
   
gskamau
Grace Kamau Axero Solutions

Are there any errors in the Exception Log when you try to view the page with the dynamic data widget?

8/6/2018 07:15 PM
 · 
Comment
by
   
amoharram
Ahmad Moharram

Yes, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

I am trying to connect to MYSQL database.

Ahmad

8/6/2018 07:19 PM
 · 
Comment
by
   
amoharram
Ahmad Moharram

Also, If Dynamic data widget connects to SQL server database only can you suggest any other way to connect to my remote MySQL database?

Ahmad 

8/6/2018 07:45 PM
 · 
Comment
by
   
mtrujillo
Matt Trujillo Axero Solutions

Hi Ahmad, this function only works with SQL server. We have never tried it with MySQL. Can you please try with SQL server? The error above indicated your web server has no network connection to the database server.

8/7/2018 02:30 PM
 · 
Comment
by
Add a new comment

Wiki Index

Pages

Intranet Software