==== 6.1.x ====
Password expiry feature
logout timer / session expiry feature
extended format options (layout, gridmode, gridformtype)
new system flags to turn of deprecated format options via PHP scripts
fit to browser window size
introducing images/icon translation table image_conf.txt
relocation of custom script folder - now relative to /conf folder - this allows shared scripts over multiple clients
relocation of custom image folder - now relative to /conf folder - this allows shared images over multiple clients
==== 6.0.1 ====
SAML authentication feature
Contains v5.0.2_HF01 bug fix
==== 6.0.0 ====
Release for PHP v8.2 compatibility
New Excel API and fixing following Excel-related bugs:
* download crashes with table with a name longer then 31 character
* upload seems to consider only the first 26 columns
* upload - strange message
==== 5.0.2 HF01 ====
Bug fix: use ~ as null value in the case of numeric columns even in lookup sets.
Bug fix: number formatting issue when row contains empty values.
Advanced filter feature change: filter is reset when catalog object instance id is clicked on Subject Area Submenu Bar.
Lookup feature change: Error raises when lookup setting is applied on a column with decimal type.
==== 5.0.2 ====
apps page feature
new style sheets and theme customization options
new layout for subject-area menu
pop-up grid feature
edit/add form customization
edit/add form positioning
new setting: display search bar by default on grid
autorefresh on detail grid edit act
button for generate style sheets
new system variable: $currentCatalogId (and other related ones)
redesigned meta views and meta sql queries
autoload feature - application's default grid
login page does not reload when login is not successful
hide grid when subject area changes
login button coloring on hover
RLS token feature
conditional constraints
new number format handling feaure
define default value in the case of grid edit
personal modal change - only password fields are available
new system setting: first day of week
Bug fix: hanging validation fix
Bug fix: session error during login
Bug fix: handle wrong column names in lookup and constraint definitions
==== 5.0.1.23221_HF ====
View info message display changes - "... set to read only ..." message appears only when it is must
UCA connection handling change: UCA uses message connection
In system default application drop down list is opened by default
Bug fix: retrieve transactions for default system application
Bug fix: load login help content from client folder
Bug fix: negative catalog id does not work inside custom subject area
==== 5.0.0 ====
MySQL v8.0 meta db server
Cascading lookup feature
Multi client feature
Debug/log setting on user level
Language definition on user level
Distributed communication area
==== 4.0.0 ====
Deployment feature
New administrative menu items
File upload and callable object call
Custom icons for callable objects
Validation feature
Excel - partial upload
New details of catalog object instances: 'group by' and 'order by'
Switch on/off advanced filter when configured in transaction menu
Switch on/off automatic 'order by primary key(s)' clause
Bug fix - LDAP connection handling
Bug fix - input type validation with constraints
=== 3.2.3_PF ===
New feature: configurable link
=== 3.2.2 ===
Bugfix - Teradata connection: retrieve column types for views
Bugfix - date- and datetimepicker: put focus on input field after value is selected
Bugfix - lookup pulldown: put focus on input field after value is selected
Send info message when grid is forced to read only mode
Error handling - redirect to logout page if fatal error occures
Logging error and debug info into file (new files: 'niota/log/error.log', 'niota/log/error_sql.log', 'niota/log/debug.log')
New administrative feature: administrator can set his/her own settings as default layout of a grid for all users
=== 3.2.1 ===
Niota v3.2.1 is a standalone installation with v3.2.0 functionallity and Php 7.3.8 compatibility!
Requires: Apache 2.4.41 64bit, Php 7.3.8 64bit!
Adodb5 library is updated to version 5.20.14. You can check changes from version 5.20.7 here: https://github.com/ADOdb/ADOdb/blob/v5.20.14/docs/changelog.md
=== 3.2.0 ===
New feature: callable object sequence
New feature: web service call
Bugfix, Chrome only: excel export jumps to blank page
Bugfix, MSSQL: excel export problems when column type is nvarchar and value contains accented letters
=== 3.1.3 ===
Portable MySQL database server included
Provide a preconfigured Niota sample system
Encryption tool for database connection passwords
New login page layout
Handling of missing grant of database user on database tables
Bugfix: accept formatting files on master-detail settings
Bugfix: selection went wrong in some cases of line level callables call
Bugfix: warning PHP message at the top of the page in the case of some specific datatypes
Bugfix: excel import failes when zero value is found in integer column and there wasn't a default value set
=== 3.1.2 ===
Relative file path handling bug fix
Excel import fix. Handling of decimal values.
Admin script corrections
Update language files
Update Salva theme
==== 3.0.0 ====
- admin page 'Constraints saving method changed' -> tiped in values are saved, checkbox to use constraint in grid
- change the way of filter out 'et_...' meta tables -> filter out only form mate data connection
- the same lookup definition can be used many times without using aliases
- call stored procedure for logging, $installation variable can be used
- internationalization and language file code revision
- naming convention: ALL USERS, ALL ADMIN USERS, ALL NON-ADMIN USERS naming checged -> ALL_USERS, ALL_ADMIN_USERS, ALL_NON_ADMIN_USERS (see metadata update sql)
- internationalization of grid edit feedback messages
- bugfix: Deutsch language - excel upload feedback message appears in wrong place + warning msg on screen
- bugfix: SQL Server and MySQL master - detail crash
- bugfix: stored procedure selection does not work without multiselect
- bugfix: constraints menu counter shows wrong when a setting is deleted
- bugfix: operation column settings for superuser
- bugfix: inline edit decimal value saving
- bugfix: inline edit - datetime value changing
- bugfix: excel import handles whitespace characters in not-caharcter fields (date, int, etc.)
=== 2.0.1 ===
- Oracle related settings stored without database name in metadata tables
- $installation variable value can be set at conf/my_formatting.php -> INSTALLATION_NAME constant for stored procedure calls
- Master - detail tables: detail tables also use the defined decimal point (',' or '.') format
- bugfix: inline edit - insert lookup values correctly if more than one values are shown in the droppdown list
- bugfix: action column position disordered column values
- bugfix: Internet Explorer page reload made blank page
- bugfix: between constraint - value 0 cannot be saved
- bugfix: Oracle table export error
- formatanytable.php -> line altered: old: 'formatoptions'=>array('keys'=>true, 'editbutton'=>$editButtonStatus, 'delbutton'=>$deleteButtonStatus, 'reviewbutton' => true)
new: 'formatoptions'=>array('keys'=>true, 'editbutton'=>$editButtonStatus, 'delbutton'=>$deleteButtonStatus)
-> new constants for positioning operation column (ACTIONS_FIRST, ACTIONS_LAST)
- test button for stored procedures working changed: returns unsuccesfull in the case of php warninrgs. Eg.: tipeo or less / more apostrohe(s) written.
- new upgrade log in conf/ folder
==== 2.0.0 ====
- editable detail tables which use all of the restrinctions
- new grid color themes
- new choosable niota color theme - Salva
- grid menu display - not allowed menu points does not show up
- stored procedures - new system variable for sp declarations: $installation
- new file structure
- choosable Deutsch (or English) language for grid area
- new setup files -> conf/formatting.php is split to my_formatting.php and branding.php
- new formatting features under 'conf/my_custom_formatting/' folder (changeable column names, switch to inline edit, mark mandatory fields)
- prevent niota directory listing
- allow again to run stored procedures for logging into database
- use both 'SEL' and 'SELECT' in lookup definitions - ONLY IN TERADATA
- test button for master - detail definition
- lookup test button - multiple changes and tests with one save
- stored procedure table can be hided and shown
- Teradata overwrite ODBC connection in niota -> FULLY QUALFIED TABLENAMES REQUIRED IN THE SAVED SQL QERIES AND DEFINITIONS(lookup, master-detail, etc. Eg.: sample_database.sample_table)!!!
======== ==========================================================================
- bugfix: navigation menu droppdowns - MySQL related counting info display