niota

• VEGA - blue
• VULCAN - red/pink
• SANDSTORM - yellow/brown
• MOSS - green
• SALVA - gray

• DB_TYPE_OCI805 - Oracle native interface
• DB_TYPE_ODBC_MSSQL - Microsoft SQL Server via ODBC
• DB_TYPE_MSSQL - Microsoft SQL Server native interface
• DB_TYPE_ODBC_TERADATA - Teradata via ODBC
• DB_TYPE_MYSQLI - MySQL server native interface

• CONN_TYPE_DATABASE - database
• CONN_TYPE_WEBSERVICE - webservice

• 10 - display 10 rows per page
• 20 - …
• 30 - …
• 50 - …
• 100 - …
• -1 - display all rows

• en - english
• de – deutsch

• SQLSRV_ENC_CHAR -

Data is returned in 8-bit characters as specified in the code page of the Windows locale that is set on the system. Any multi-byte characters or characters that do not map into this code page are substituted with a single byte question mark (?) character. This is the default encoding.

• *ALL_GROUP - every user in niota is member of this group
• *ALL_ADMIN_GROUP - every user with admin option activated is member of this group
• *ALL_NON_ADMIN_GROUP - every user without admin option is member of this group

• 0 - table level binding
• 1 - line level binding

• 0 - no target page/no prompt page
• 1 - file upload prompt page is displayed

• 0 - stored procedure
• 1 - sql statement
• 2 - batch command
• 3 - web service call

• max_number_validation_err - overwrites system value MAXNUMBER_VALIDATIONERR on catalogobject level
• max_number_validation_msg - overwrites system value MAXNUMBER_VALIDATIONMSG on catalogobject level
• max_number_validation_row - overwrites system value MAXNUMBER_VALIDATIONROW on catalogobject level

See default settings for further details.

• D - date
• T - datetime
• N - numeric
• C - textual

• 0 - database connection
• 1 - web service connection

• 0 - tables are linked in a master-detail relation
• 1 - tables are linke as advanced filter relation

• 0 - no operation - used for advanced filter feature so set defaults from filter instance to filtered instance
• 1 - equals
• 2 - not equals
• 3 - greater than
• 4 - less than
• 5 - greater than or equal to
• 6 - less than or equal to
• 7 - between
• 8 - not between
• 9 - like
• 10 - not like
• 11 - starts with
• 12 - starts not with
• 13 - ends with
• 14 - ends not with

• niota.php - for table loading
• execute_callable.php - to execute callable objects

• popup_filter - define popup filter
• selected_instance - loads a catalog object instance
• callable_object - runs a callable object
• filter instance - popup filter catalog-object-instance

• 1 - self group - has only user as it's implicit member
• 2 - custom group - may have more then on user as member

System values, cannot be overwritten.