Page Comparison

Select

List of database page models (detail views).

[Delete] button

Delete this database connection.

Description

Name of the database page that should be displayed in the selection lists.

Database

List of database connections.

Presentation

Select ‘WM Details’. This is the default value in XperienCentral.

Other values (such as ‘WM Agenda’, ‘WM Person’, and ‘WM Product’) are added to the list if certain functionalities are imported in XperienCentral.

Value

A unique value used by the search engine for indexing.

Get information query

This is the query to be run if the detail view has to be displayed. This query is connected with @dbid@ to the record that was clicked through.

The variable @dbid@ contains the primary key in the table and can be used to retrieve the correct record.

ExampleFor example:

SELECT employee_name, salary, commission FROM employees WHERE  employee_id = @dbid@

Show settings -

A number that determines the sequence of the columns to be shown.

Show settings – Query field

Name of the column in the SELECT clause. This can be a column name or alias (behind the keyword ‘AS’).

Show settings – Column name

Text that should be shown above the column on the page (only if the ‘Show column heading’ is set to ‘Yes’). If this field is left blank, the content of the ‘Query field’ will be used.

Show settings – Don’t show

Indicates whether this column should be shown or not. 

This can be handy to still have the primary key columns available when several tables are joined.

Show settings – Always index

A column that is not shown is not indexed by default. To index this column, a check mark can be placed here. This setting is, however, ignored if ‘Index for search’ is set to ‘No’.

Show settings - Delete

The column to be shown can be deleted here.

Show settings - [New column] button + number

Add a number of columns.

Get query

Query to retrieve the title of the database object. This title is shown on the page in a larger font. The query has to contain an ID and a NAME name in the SELECT clause.

Search query

The search query is used in two places:

1. While indexing the database pages. It sees to that every entry can be shown on a page.
2. While connecting terms to entries that are on a database page. For further explanation see the document belonging to the license component ‘Media Repository’.

The query has to return an ID and a NAME name and can use the ‘search’ search parameter to find the proper records in the database. An For example:

SELECT whPerson.id AS id, whperson.lastname AS name FROM whPerson WHERE lastname LIKE '%@search@%'

Link query

Using this query, the links related to this table can be retrieved from a specially created link table.

The Link query is only used for the product catalog and for meetings that have been created in the Meetings and Papers component.

Index for search

Indicates whether this type of page should be indexed and, therefore, be shown in the search element.