...
Because XperienCentral can be connected to other databases, it is, for example, possible to request data from the back office backoffice and show these on the website.
...
By means of queries you can configure views on database content. For example:
Overview Versus Detail View
...
- The overview level shows a list of records from the database.
- The detail view level shows one specific record when it is selectedmore details of a selected record.
In the screenshot above, the upper part shows an overview and the lower part shows a detail view. Note that you You can also place the detail view on a different (special) page.
Sorting by Column
For At the overview level, you can sort by column by clicking on a column heading which toggles the sorting between ascending and descending order. For each column in the overview, you can enable or disable column sorting separately.
...
In XperienCentral, you manage your query definitions at a central point. Each query definition has a name, code, the name of the database, the presentation format of the retrieved data, which fields of the retrieved data are to be shown in which columns and query parameters. To show the retrieved data on a web page, you insert a Query content element on a page. In the content element you select the desired query definition.
Query Parameters
To be make queries more flexible with queries, you can use parameters in the query code. For instance, you may use a parameter to filter the data to be retrieved on certain characteristics. Then, to change the filter characteristics, After that you only have to assign another value to the parameter without changing the query code. The parameter is put between @ characters in the WHERE clause. For example:
...
You can assign values to a parameter at two levels:
- With Using the query content element
- With the query definition
...