Table of Contents
The Database View module represents the database of your xentral in the interface display.
Use in xentral
This way you can always check which tables exist in the database of xentral and which entries can be found there. This is useful, for example, when you have your own reports under Controlling > Reports, or if you want to program or modify.
On the left, all tables of the database can be clicked. Thereupon entries are displayed in a live table, which can be sorted by all columns.
Assignment address <-> groups
In the Database View module you can see which fields can be read by SQL reports and what they are called.
There are "groups" which can be associated with the address. With the Reports module and a SQL query you can view the groups. The first column is the ID, which is the parameter.Now change to the view tab. The parameter column is the Reference(ID).