Page Comparison

...

In the example below, the upper part shows the overview. The lower part is the detail view, which appears after clicking the last name "Groot".:

Image Added

Using a Special Page for the Detail View

...

SELECT whPerson.lastname, whPerson.prefix, whPerson.firstname, whDepartment.name AS depname, whJob.name AS jobname, whLocation.name AS locname, whPerson.id AS personid FROM whPersonwhPerson, whPersonDepartment, whDepartment, whPersonJob, whJob, whPersonLocation, whLocation WHERE whPerson.id=whPersonDepartment.person AND whPersonDepartment.department=whDepartment.id AND whPerson.id=whPersonJob.person AND whPersonJob.job=whJob.id AND whPerson.id=whPersonLocation.person AND whPersonLocation.location=whLocation.id AND whLocation.id IN (@place@) ORDER BY whPerson.lastname

...

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 more or fewer types. By default, ‘Normal’ is selected here. Only ‘Normal’ belongs to the standard functionality of GX XperienCentral.
Modify query manually	The query can be manually entered here. Attention: Do not use SELECT , but name the individual column headings in the SELECT clause. Note*: Enter a variable by entering a word that begins and ends with @, such as ‘@keyword@’ `@keyword@`. These variables become the parameters of the query.
[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 - Sort
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 GX XperienCentral.
Column settings - Delete	The column can be deleted here.
New link/ Modify link	To create a hyperlink to a database page. Example of 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 by Configure > External databases
[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.

...

The following fields are only visible if the query has @ parameters:

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, GX 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: Next to ’Connected table’ is the name of the table from which the selection list has to be generated. The ‘Connected table ID field’ is the column that contains the unique codes of this table. This should be an integer field. The ‘Connected table name field’ is the column that contains the list elements. Using ‘Additional restriction’ a query can be entered without the SELECT and FROM clauses. Usually, there will only be a WHERE clause here. If a pop-up is chosen, for example, the following is displayed when setting the locations on the query element:
Parameters - [Delete] button	Only present if a headline exists. Deletes the headline.

...

Field		Description
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 GX XperienCentral. Other values (such as ‘WM Agenda’, ‘WM Person’, and ‘WM Product’) are added to the list if certain functionalities are imported in GX 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. Example: `SELECT employee_name, salary, commission` FROM `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 in the SELECT clause.
Search query	The search query is used in two places: While indexing the database pages. It sees to that every entry can be shown on a page. 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 and can use the ‘search’ parameter to find the proper records in the database. An example: `SELECT whPerson.id AS id,` `whperson.lastname AS name` FROM `FROM whPerson` WHERE `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’ Link query is only used for the product catalog and for meetings that have been created in the ‘Meetings Meetings and Papers’ Papers component.
Index for search		Indicates whether this type of page should be indexed and, therefore, be shown in the search element.

...

Versions Compared

Old Version 59

New Version 60

Key

Using a Special Page for the Detail View