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.
Choose the roles that can view this widget.
Product Data Example
Hello,
Dynamic data widget is not working even widget header doesn't appear even after enabling DynamicDataWidgetEnabledInPageBuilder from system properties, any suggestions?
Ahmad Moharram
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
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
Are there any errors in the Exception Log when you try to view the page with the dynamic data widget?
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.
Also, If Dynamic data widget connects to SQL server database only can you suggest any other way to connect to my remote MySQL database?
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.
Please enable JavaScript to use file uploader.
is requesting access to a wiki that you have locked: https://my.axerosolutions.com/spaces/5/communifire-documentation/wiki/view/22720/dynamic-data-widget