Technical Documentation

IDCategoryReq.Element Action
478string: HTMLno$zz['fields'][n]['title_tab'] title in table display (optional, default = 'title'), e. g. for abbreviations to save placeShow
407string: HTMLno$zz['fields'][n]['unit'] displays a unit behind a number, won't display if value = NULL

Relations: number

Show
924string: SQLno$zz['fields'][n]['geocode_sql'] SQL query to replace ID value for geocoding with real content

Relations: $zz['fields'][n]['geocode']

Show
421string: SQLno$zz['fields'][n]['path_sql'] only if this sql query is needed for constructing the extension of a file path; sql-query which will be used if this field's display_value is set as fieldxx in path to get a correct extension for file conversions

Relations: select

Show
802string: SQLno$zz['fields'][n]['search_between'] Show
619string: SQLno$zz['fields'][n]['search'] if a field does not appear without an alias or appears ambiguous in the SQL query for 'list' view, here you can define the exact field name or field combination that will be used for searchShow
640string: SQLno$zz['fields'][n]['set_sql'] similar to set, lets you get comma separated values from an SQL query that will be treated similar as a mysql SET field

Relations: select

Show
787string: SQLno$zz['fields'][n]['sql_not_unique'] Detail records migh be shown with an n:m relation as well (read only). The SQL query for n:1 goes into the 'sql'-variable, the 1:m LEFT JOIN (or similar) has to go into the 'sql_not_unique' variable. Will be shown in record as well as in list view. Show
404string: SQLno$zz['fields'][n]['sql_password_check'] SQL query that is used to check if the given password equals the existing password

Relations: password_change

Show
181string: SQLno$zz['fields'][n]['sql'] SQL-Query for select, first field is key field which will not be displayed but entered into database field

Relations: select

Show
946string: SQLno$zz['fields'][n]['sqlcount'] query which has to have something like `COUNT(record_id) AS record_id` in it to provide a faster alternative to querying several records up to max_select for counting all records available for a select field

Relations: $zz['fields'][n]['sql']; $zz_conf['max_select']

Show
201string: SQLno$zz['fields'][n]['sqlorder'] Show
571string: SQLno$zz['fields'][n]['upload_sql'] SQL query to use with upload value, e. g. if you get a string but need an ID value.

Relations: hidden; $zz['fields'][n]['upload_field']

Show
432variableno$zz['fields'][n]['default'] default value for field, normally string; for subrecords displayed as 'set' it may be an array as wellShow
331arrayno$zz['filter'] Filter for records to be shownShow
332arrayno$zz['filter'][n] Show
337arrayno$zz['filter'][n]['selection'] Possible filters, always pairs of record_id and filter title; values starting with »!« will be compared against with !=, »\« escapes possible !-signsShow
988arrayno$zz['filter'][n]['where_if'] 'where_if' allows to set a WHERE query individually for each selectionShow
804booleanno$zz['filter'][n]['hide_all_link'] true: hide -all- link at the end of this filter to show all records unfilteredShow
893booleanno$zz['filter'][n]['ignore_invalid_filters'] if true: invalid filter values will not trigger a 404 error and they will not show a message that the filter is invalidShow

348 records total

in