Pages can automatically retrieve information from a range of Database Connections, using the Promo Server to carry out the queries.

When working with databases, it is important to always make sure the database columns match the data type of a page’s field. If a database column is of type Integer, and your field is of type String, you will not be able to make any updates.

Note that changes to a page in the Page Pool view will affect all referenced occurrences of that page in a playlist. Changes to a page in the Playlists view will only have an effect on page.

To populate a Template from a Database

1. Select your channel.

2. Open the Page Pool or the Playlists view.

3. Double-click a page. This opens the Page Editor.

4. Select a field from the page fields list, and you will see Get content dynamically on the right side of the Page Editor, if this field type supports Page Content Filling.

5. Click the second expander. 

6. Make your configurations.

7. Click Save or Save as.

To configure a database query

1. After selecting a connection, there is an attempt to connect that will fetch all the available data in the database.
   If it failed to connect to the database, you can either try to reconnect, or check Database Connection in External Data Sources.

2. When it is successfully connected, you can choose to generate query string automatically by selecting table, column and conditions, or use custom query by check Custom SQL.

3. Click Set query when query is configured, Promo Server will send back the result if the page is opened from playlist.

4. Press Save or Save as to save the query.