| Anchor | ||||
|---|---|---|---|---|
|
In This Topic
| Table of Contents | ||||
|---|---|---|---|---|
|
...
- 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:
...
- 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 drop-down menu (top left). A blank dialogue pane with connection related attributes is shown.
- Enter the connection related attributes.
- 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.
...
Overview with Link to Detail View
...
- Select the desired overview query (Configuration > Queries Queries tab).
- Under "Column settings" add a column for the record ID field and check "NT" for "Do not show".
- In order for the field to be linked, select "New link" under "Column settings" or "Modify link" if a link already exists.
- From the "Field" drop-down list, select the ID field(in this example "personid").
- From the "To" drop-down list, select the desired detail view. Click [Save].
- Click [Close]. The overview query looks like this:
Defining a Query Content Element with Detail Link
...
- Navigate to the desired page.
- Add a Query content element.
- Select an overview query that includes a link to a detail view from the upper drop-down list:
Showing the Overview with Link to Detail View
...
- .
...
Using a Special Page for the Detail View
...
Field | Description |
Copy button | Copies the current query. The name of the copy is "Copy of <name>". |
Delete button | Deletes the current query. |
Name | The name of the query that should be displayed in the selection lists. |
Title | Title that should appear above the result when the query is submitted on a page. |
Presentation | Select "WM query" for the presentation to use for the results of the query. |
Database | The database the query is submitted to. |
Maximum number of pages | ‘Page size’ x ‘Maximum number of pages’ = maximum number of records retrieved from the database. |
Page size | The number of records allowed to be shown on a page. |
Show column heading | Indicates whether column headings should be shown above the query result. |
Show row number | Indicates whether row numbers should be shown in front of records. |
Type | Type of query: ‘Normal’, ‘Who-is-Who’, ‘Target audience’, ‘Events’, ‘Subjects’, ‘Product overview’, ‘Themes’, ‘Questions’, or ‘Documents’. Depending on the functionality present, this list can include other types as well |
Modify query manually | The query can be manually entered here. Do not use SELECT *, but name the individual column headings in the SELECT clause. Enter a variable by entering a word that begins and ends with @, such as |
[Compose advanced query] link | If the Microsoft SQL Server is used, a table with columns can be assigned using a wizard. The SELECT statement will then be generated. |
[Preview] link | If the Microsoft SQL Server is used, the result of the query can be viewed. If parameters are used in the query, a pop-up window appears where these parameters can be entered. |
Column settings - Order | A number that determines the sequence of the columns. |
Column settings - Width | Width of the column in pixels. If no width value is entered, the browser will determine the width. |
Column settings – Query field | Database field where the column gets its information. |
Column settings – Column name | Text that should be shown above the column on the page (if the ‘Show column heading’ is set to ‘Yes’). If this field is left blank, the content of the ‘Query field’ will be used. |
Column settings - NT | Indicates whether this column should be shown. This can be handy to still have the primary key columns available when several tables are joined. |
Column settings - Null | Indicates whether a 0 should be shown if a cell in this column is empty or if the value is 0. |
Column settings – 2DB | If ‘Sort’ is checked, indicate here whether the data should be sorted in the database. Otherwise, the data will be sorted in XperienCentral. |
Column settings - Delete | The column can be deleted here. |
New link/ Modify link | To create a hyperlink to a database page. Example of a pop-up: Field: Select the property from the pulldown which contains the ID to the detailed view of the object. This property always has to be of the integer type. To: A selection can be made from the database pages that are defined in Database Maintenance. |
New column button + number | Add a number of columns. |
All fields button | Add as many columns as there are fields in the SELECT clause of the query. |
...
Field | Meaning |
Parameters | A number that determines the sequence of the parameters and the headings. |
Parameters - Parameter | The name of the parameter, as it occurs in the query, but then without the enclosing ‘at’ symbols (@). |
Parameters - Description | In the case of a parameter, the name of the parameter appears here. In the case of a headline, the text of the headline appears here. |
Parameters - Type | The data type of the parameter (‘Date’, ‘Integer’, or ‘Text’.) |
Parameters - List | Indicates whether it is allowed to enter more values for this parameter. If this option is checked, several values can be selected on the query content element: |
Parameters - Optional | Indicates whether this parameter is optional or required. If a parameter has no value, XperienCentral removes the row where this parameter is used from the query. Therefore, set this type of WHERE parts in separate rows. |
Parameters – Edit in element | Indicates whether the value of the parameter may be entered on the content element or whether the parameter is filled, based on the value in the query string. |
Parameters – Default value | The default value of the parameter if a value is not entered. |
Parameters –Add headline | Enter a new headline here. Headlines are texts that can be set on the query element between groups of parameters. This is done to enhance usability. |
Connect to table/ Edit connected table | This allows connecting a parameter to a column from a table to show a list of selections on the query element. Example:
|
Parameters - [Delete] button | Only present if a headline exists. Deletes the headline. |
...