Table screens of all existing tables can be accessed via the core tab. At each module level, links to all child modules and the module tables are shown. Only those tables and modules are shown which contain data that the current user may view (see also permissions).
Single data sets can be displayed and modified via the data set display button (the first action of the set of actions).
| Core module screen|
| Table screen|
Each module may have (but doesn't have to have) its own display area, which can be accessed via a tab in the module tabs header. Data within each module are usually displayed on the module area, but can be redirected to any display area. The page, which is shown on first visit of a module area, is associated with a PHP function of this module.
The location string displays links to modules further up in the module hierarchy and allows to quickly access data.
The favorite tables are automatically sorted in the order of last access. The font size increases with the numbers of times a table has been accessed. The number of displayed table links and font sizes can be configured in the preferences table.
The table icon is characteristic for the table and is used whenever data of this table are displayed. It can be specified in the table properties.
The table title is a short name describing the table.
The documentation link leads to a documentation text of this table and further properties properties including links to column documentation.
The header text describes in more detail what this table contains and what it is used for.
The filter section lets the user select datasets that match certain values. Only those columns are shown that are marked as index columns in the respective field properties.
The search form allows to search data sets for strings. The search is case-insensitive. Only those columns are searched, which are marked as searchable in the column properties. Multiple strings must all be present in at least one of the searchable fields of the data set. The search can be refined by using arithmetic operators like 'at least' and 'at most' or logical operators like 'and', 'or' and 'not'. The word 'or' starts a series of conditions of which one must be fulfilled. The word 'and' switches back to 'anded' conditions. The word 'not' negates everything until the next 'or', 'and' or the next search term.
You may search a specific field by first specifiying the field name with a trailing slash (for instance "/formula") followed by the search item. The field name can be shortened as long as it is not ambiguous.
To include only records of which the value of a specified field is equal or larger than a certain limit, prepend the limit with a '>' like in '/LowPH >5'. If the entry of a field shall be equal or smaller than a certain limit prepend the value by a '<' like in '/HighPH <6'.
If a search item shall contain white spaces it must be surrounded by single quotes " ' ". The search term '\' allows for searching for empty fields.
The column chooser allows selecting columns for display.
List size chooser
Sets the number of displayed data sets. If the total number of matches exceeds the list size, an additional link 'show all matches' allows to show all matching data sets. If the number of matches exceeds 100, an additional link 'show 100 matches' allows to view matches in batches of 100. The preference MaxListSize sets the maximum number of data sets which can be displayed on one page.
The row selectors are used to perform some action including modification on all selected data sets.
The data area contains the actual data. All values are displayed as active fields. After click on active fields the field can be edited.
This section contains buttons to perform certain actions on the data sets. Only those actions are displayed, which the current user is allowed to perform.
The table selector is used to select all data sets.
The batch modifiers are active fields. Changing a batch modifier sets the values in the corresponding column of all selected data sets.