...
- Make sure a filled external database is available and that you know the connection related attributes.
- Navigate to Configuration -> Database Maintenance.
- Select the [ Database connections ] tab.
- Select [ New database connection ] from the pulldrop-down menu (top left). A blank dialogue pane with connection related attributes is shown.
- Enter the connection related attributes.
- Press [Click Apply]. If XperienCentral can make the connection, the product and driver information is shown as well as a table content list.
...
Using Queries
In this section, we setup set up a basic view on the whPerson table by showing the following fields: lastname, prefix, firstname and email. We start with the following query:
...
- To create a query, select ‘New query’ "New query" from the drop-down menu list (see A).
- To copy a query, select that query it and click [ Copy ] (see B).
- To delete a query, select that query it and click [ Delete ] (see C).
- To add a column to the overview for any field in the SELECT clause, click [ All fields ] (see D). Then enter the column names (headings).
- To enable sorting by column, check the ‘Sort’ box] (see E).
...
Showing the Basic Overview
The result may look looks like this. Sorting by column has been enabled for ‘Last name’ and ‘First name’"Last name" and "First name". By clicking on it, you can toggle sorting between ascending and descending order. For this type of content element with this presentation format, the title in the content element is not shown.
...
- Select the desired overview query (Configuration > Queries).
- Enter the query with a parameter.
- Press [Click Apply]. A "Parameters" section is automatically added at the bottom of the screen.
- Define the parameter options:
...
The goal is to let the editor choose from a list of options for the "place" parameter at in the Query content element. The options in the list can be obtained from another table from the database.
- Click "Connect to table" (or "Edit table" if a table already exists).
- Enter the name of the table and the names of the ID and name fields. Click [ Apply].
- Press [Click Close]. You can now select a default value for the parameter. This list is also available with the query content element now.
...
- Navigate to the desired page.
- Add a Query content element.
- Select an overview query that includes a parameter. A parameter pulldrop-down box is added to the content element.
- Select one or more parameter values on which you want to filter your view.
...