Documentation>>Sitemap>>About Version 2.0.J
Configuration view
After the installation some views are available the picture shows this.
With the Content view we show the possibilities.
A view must have a name and can have a description. The field view can be empty but then nothing would be displayed. A must have the fields:
- title
- section
- category
- link
Section and Category can be empty, the fields muss be available in the result. Otherwiese it is a normal SQL-Statement. A special feature are the variables that are replaced atrun time:
- NOW: will be replaced with the actuell time
- USER_ID: will be replaced with the ID from the actuell user
- USER_GID: will be replaced with the Group ID from the actuell user
This values has to be in curly brackets.
An other special feature are conditions in double curly brackets, as this:
{ AND c.sectionid IN ({sectionid}) }
This condition will be replaced, if the parameter sectionid has a value, with
AND c.sectionid IN (17)
and if the parameter is empty, the complete condition is not applicable. You have to look at the SQL-Statement it must also be valid without the condition.
Here you can see the possible parameters for the view. More is possible, the parameter description are saved in the database. The description can only saved in the database by importing a view.
