Technical Documentation

Selection Teilbaum:
$ops
$page
$zz
$zz_conf
$zz_conf INTERNAL
$zz_conf UPLOAD
$zz_error
$zz_page
$zz_setting
$zz_sql
$zz_tab
$zz_var
WEBSERVER_DIRECTORY
zz_constants
zz_fieldtypes
zz_states
zzbrick
zzform
zzwrap
– all –
ID Category Req. Element Action
266 array no $zz['list']['hierarchy'] display table in a hierarchical view. Caution: - these variables might need a lot of memory when handling bigger amounts of records because all record ids have to be saved to memory - in combination with a WHERE-Condition (`&where[field]=32`), some records might be missing in a branch of a tree because the WHERE-Condition might exclude these records. For the top level, the missing records will be shown read-only

Relations: GLOBAL
268 string: field no $zz['list']['hierarchy']['display_in'] field_name where hierarchy shall be displayed (level0...10), or table_name in case field is of type subtable

Relations: LIST
945 boolean no $zz['list']['hierarchy']['hide_top_value'] Shows hierarchy without top value, moving all records one level up
912 integer no $zz['list']['hierarchy']['id'] ID of top record in hierarchy if just a subtree shall be displayed

Relations: LIST
267 string: field no $zz['list']['hierarchy']['mother_id_field_name'] field_name: mother ID, to get hierarchical view

Relations: LIST
539 boolean no $zz['list']['tfoot'] shows table foot, e. g. for sums of individual values

Relations: LIST
920 array no $zz['set_redirect'] List of redirects that will be added to the database redirects table if an identifier is updated or a record with an identifier is deleted. Might be list of strings (old and new pattern is equal), list of arrays (old and new patterns differ); field_name may be set optionally if more than one identifier is in the field list.

Relations: $zz['extra_action']; identifier
8 string: SQL yes $zz['sql'] SQL statement for list display and to get field values for form display
9 string: SQL no $zz['sqlorder'] SQL statement, part must begin with ' ORDER BY', to sort database table
947 string: SQL no $zz['sqlcount'] separate SQL query for counting records if main query is too heavy

Relations: $zz['sql']
985 string: SQL no $zz['sqlextra'] if SQL query is too complex, additional values can be read via 'sqlextra' queries
941 string: SQL no $zz['sqlrecord'] SQL query which will be used only for record view, not for list view

Relations: $zz['sql']
7 string: field yes $zz['table'] Name of database table (might include database name as well, e. g. Database.Table)
216 string: HTML no $zz['title'] optional: h1-heading to be used for form instead of $zz['table']

Relations: OUTPUT
238 string: HTML no $zz['explanation'] Textblock after heading

Relations: $zz_conf['footer_text']; OUTPUT
917 variable no $zz['subtitle'][field]['concat'] Array or string; if more than one field is used for subtitle, this string or these strings will be used instead of the default space for concatenating the fields. If an array is used and the number of elements is smaller than the number of spaces to fill, the last value will be repeated.

Relations: OUTPUT
240 array no $zz['subtitle'][field]['enum'] field = $where_id, without tablename; = $zz['fields'][n]['enum'] where n is the index of the field corresponding to the key

Relations: $zz['fields'][n]['enum']; OUTPUT
987 variable no $zz['subtitle'][field]['format'] Array or string; format all (string) or one (array) value with a formatting function

Relations: OUTPUT
327 string no $zz['subtitle'][field]['link'] heading link provides a link back from the filter text directly below the heading ('var', 'sql') to the main page which triggers the filter (displaying the corresponding record)

Relations: $zz['subtitle'][field]['sql']; $zz['subtitle'][field]['var']; OUTPUT
789 boolean no $zz['subtitle'][field]['link_no_append'] does not append mode=show&id=.. to URL

Export (CSV Excel)

348 records total

in

Help: Advanced Search for Forms