Technical Documentation
Show a record
Submit data …
|
|
ID | 988 |
Category | array |
Required | no |
Element | $zz['filter'][n]['where_if'] |
Description | 'where_if' allows to set a WHERE query individually for each selection |
Description de | |
Example |
|
Default value | |
Mother ID | $zz['filter'][n] | [332] |
Relation | |
Updated | 22 Jun 2017 11:47:28 |
- 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 |
---|---|---|---|---|
988 | array | no | $zz['filter'][n]['where_if'] 'where_if' allows to set a WHERE query individually for each selection | Show |
336 | string: SQL | no | $zz['filter'][n]['where'] If type == 'list', this is the required part for the WHERE condition without the equal sign. Might be, even without 'selection', an array for multiple WHERE-conditions connected with OR filter=NULL and filter=!NULL will be translated to the correct SQL query form | Show |
265 | array: path | no | $zz['folder'][] array with root, string, field, mode for a folder that must be renamed/deleted after changing the record Relations: ACTION | Show |
933 | string: HTML | no | $zz['geo_map_html'] if set, zzbrick/forms module will include a javascript map (e. g. OpenLayers) to display the records via a KML export on this map; a map template and a JavaScript-library is required Relations: $zz_conf['export']; brick_forms() | Show |
934 | string | no | $zz['geo_map_template'] template for $zz['geo_map_html'] Relations: $zz_conf['export']; brick_forms(); $zz['geo_map_html'] | Show |
974 | boolean | no | $zz['list']['hide_columns_if_emp Relations: LIST; $zz['fields'][n]['hide_in_list_if_empty'] | Show |
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 | Show |
268 | string: field | no | $zz['list']['hierarchy']['displa Relations: LIST | Show |
945 | boolean | no | $zz['list']['hierarchy']['hide_t | Show |
912 | integer | no | $zz['list']['hierarchy']['id'] ID of top record in hierarchy if just a subtree shall be displayed Relations: LIST | Show |
267 | string: field | no | $zz['list']['hierarchy']['mother Relations: LIST | Show |
539 | boolean | no | $zz['list']['tfoot'] shows table foot, e. g. for sums of individual values Relations: LIST | Show |
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 | Show |
8 | string: SQL | yes | $zz['sql'] SQL statement for list display and to get field values for form display | Show |
9 | string: SQL | no | $zz['sqlorder'] SQL statement, part must begin with ' ORDER BY', to sort database table | Show |
947 | string: SQL | no | $zz['sqlcount'] separate SQL query for counting records if main query is too heavy Relations: $zz['sql'] | Show |
985 | string: SQL | no | $zz['sqlextra'] if SQL query is too complex, additional values can be read via 'sqlextra' queries | Show |
941 | string: SQL | no | $zz['sqlrecord'] SQL query which will be used only for record view, not for list view Relations: $zz['sql'] | Show |
7 | string: field | yes | $zz['table'] Name of database table (might include database name as well, e. g. Database.Table) | Show |
216 | string: HTML | no | $zz['title'] optional: h1-heading to be used for form instead of $zz['table'] Relations: OUTPUT | Show |
916 records total