From DAYDA Wiki
Jump to: navigation, search

All data, irrespective of how they are used in the database can be browsed, searched, modified, and deleted in the table screen. The table screen has a uniform appearance. It is possible to include per-table customized javascript and PHP scripts that allow e.g. to add additional (e.g. calculated) columns and to add additional functionality to the displayed data. Only those datasets are displayed for which there is at least one object mode rule that allows the current user to view them. Likewise, only those columns are displayed for which there is at least one field mode rule that allows the current user to view them. The permissions page explains in detail how permissions work.

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
Table screen
Table screen

Module tabs

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.

Current location

The location string displays links to modules further up in the module hierarchy and allows to quickly access data.

Favorite tables

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.

Table specification

Table icon

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.

Table title

The table title is a short name describing the table.

Documentation link

The documentation link leads to a documentation text of this table and further properties properties including links to column documentation.

Header text

The header text describes in more detail what this table contains and what it is used for.

Selection panel


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.

Search form

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.

Column chooser

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.

Data table


Row selectors

The row selectors are used to perform some action including modification on all selected data sets.

Data area

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.

Table selector

The table selector is used to select all data sets.

Batch modifiers

The batch modifiers are active fields. Changing a batch modifier sets the values in the corresponding column of all selected data sets.