Page Comparison

Anchor
top top

It is possible to connect XperienCentral to one or more external databases . The word ‘external’ is used to indicate that it is different from the internal database: The which lie outside the internal database that maintains XperienCentral’s internal content & administrationandadministration. It is possible that , however, to place the tables with external data are located in the same database as XperienCentral’s internal tables. Because XperienCentral can be connected to other databases, it is, for example, possible to request data from the backoffice and show these on the website.

In This Topic

Table of Contents
maxLevel 2 minLevel 2

...

• The overview level shows a list of records from the database.
• The detail view level shows more details of a selected record.

In the screenshot above, the The upper part shows an overview and the lower part shows a detail view. You can also place the detail view on a different (special) page.

...

Queries are defined using SQL (Structured Query Language). The information returned from the database can then be shown on the website. The following is an example of an SQL query:

...

1. Make sure a filled external database is available and that you know the connection-related attributes.
2. Navigate to Configuration -> Database Maintenance.
3. Select the Database connections tab.
4. Select New database connection from the drop-down menu (top left). A blank dialogue pane with connection related attributes is shown.
5. Enter the connection related attributes.
6. Click Apply. If XperienCentral can make the connection, the product and driver information is shown as well as a table content list.
   
   

...

If you selected "Use search pop-up", a panel pops up when setting the locations on the query element.

Showing the Overview with Parameters

The result only shows records in which the location is Amsterdam or Nijmegen.

Back to Top

...

Overview with Link to Detail View

...