release 3.2

NEW FEATURES

#47 - New instruction to create a reference data entity : add reference entity ENTITYNAME

Entity model is completed with two new fields :

• order field ( type number )
• enabled field ( type boolean, default true )

#46 - Do not erase the file toSyncProd.lock.json to ensure the ability to update properly any version of a generated application

In a nodea application, there are three files used to manage the database synchronization :

• toSync.json
• toSyncProd.json
• toSyncProd.lock.json

Any instruction is loggued onto the toSync.json file.

toSync.json file is used when starting the app and then the content of this file is moved onto the toSyncProd.json file.

When using the deploy instruction, the file toSyncProd.lock.json is completed with the content of toSyncProd.json file which is executed on the deployed application : this is done automatically by the nodea platform. This feature is not available when using the nodea software on your own from desktop.

Each deployment will create a new entry in the file organized in this way :

{ "deployments":
    [
       { 
         "versions": VERSIONNUMBER,
         "queries": [ QUERIES ]
       }
    ]
}

#48
Status component comes today with the possibility to check "Comment" option.
If checked, then a popin is reased when changing the status and the use can add a free comment.

This is usually not sufficient for any report purpose. So we have added a new tab Reasons to Status entity in order to allow the selection of a predefined reason when changing a status.

Adding of a new tab called Reasons on a status in order to have some predefined elements to select when using the status.
Adding of an option reason ( motif in French ) ( boolean type )

If the option is checked, then the popin displays a select input. If both options ( reason and comment ) are checked, select input and textarea are displayed.

Moreover, history status table is automatically completed with a foreign key to the c_status_reason table.

# 41 - Create a datalist with column aggregating fields for "has many" relationship ( related to fields )
We added the ability to concat values in a single column when using "has many" relationship.

FIX

#41 - Create a datalist with column aggregating fields for "has many" relationship ( related to fields )

#45 - Security enhancements for local authentication

#44 - By default on a select2 input, cursor is not properly focused on the select area

#42 - Postgres enhancements - using of iLike expression

3.1 Hotfix 1

Improvements

• Give the ability to change the page format for PDF generation in document template component
• Add post process date, datetime, picture and qrcode for document template
• Immprove help message to manage date attributes in document template

Bug Fix

• Fix an issue blocking generation with file script ( special characters )
• Fix address handling in UI editor
• Fix fail in Dockerfile
• Fix MariaDB import/export
• Fix an error on field type file that prevent update form submit
• Fix application assignment error on nodea studio
• Handle special/hidden space in instruction
• #40 - Fix display inline help on sub-entity ajax form
• Fix demo mode expiration in order to remove applications and users correctly
• Fix default values on field type enum and radio
• #39 - Fix images of subdatalist not displayed
• Fix subdatalist pagination handling
• Fix "related to" instruction and management of default value
• Fix pagination in subdatalist
• Some fixes on tracking component

3.1

Features

• JEST & Cypress test autogeneration with application (https://docs.nodea-software.com/en/3-1/developer/tests)
• Add default Gitlab CI integration
• New Tracking component
• RGAA - WCAG 2.1 validation of generated application
• New application generation queue system to avoid conflict
• Nodea demo mode (https://demo.nodea-software.studio/)
• New administration menu in Nodea, manage users and queue system
• New preview instruction autocompletion, now suggest entities and modules !
• New application bundle system for CSS and JS (https://docs.nodea-software.com/en/3-1/developer/client_side_js#bundle)
• Add Helmet.js by default for secure application by setting default HTTP headers
• Now application diagram status let you create new status

Improvements

• Component address rework
• Now force first connection when generator admin is not set
• Remove 24h Gitlab deploy token expiration date
• Improve instruction select application, you can use this instruction in preview mode
• Reinforce password security requierment
• Add current theme key in metadata.json
• Some changes CSS on Nodea theme
• Add trash button on datetimepicker
• Now media mail 'from' input will use default mail.js configuration file
• Now user ID are written in logs
• Update and clean generator and application node modules
• Add dustjs helper in generator
• Upgrade plugins AdminLTE => JQuery UI 1.13.2 + moment.js 2.29.4
• Variabilize size file limit on dropzone
• Improve access settings UI
• Now you can login in Nodea generator with your email
• Add new env variables for Nodea generator
• Add missing hook beforeUpdate in param entity
• Replace html-pdf with puppeteer for pdf generation
• Improve and fix status diagram
• Improve error handling on translate helper
• Add default @core/utils function in application
• Improve Nodea emails content
• Improve nodeaTable speWhere handling
• Add getFromContext dust helpers
• Improve generated app native database pwd to handle STRONG policy if needed
• Remove useless SQL GRANT on app generation, now use generator host for app user
• Add new beforeInitialStatus hook in create route
• Improve SMS media and add smsProvider in global.js
• API security update
• Desync node modules installation for faster generator initialisation

Bug Fix

• Fix users create/update form
• Fix issue #37
• Fix issue #29
• Fix html tag in list + CSS on badge
• Fix on route /program/generate_and_replace
• Fix lang user switch on restart server
• Fix views of Page entity
• Somes fix on locals traduction
• Fix config require cache error
• Fix error on add component status with name too long
• Fix models & setInitialStatus on E_task
• Fix set theme instruction
• Fix instruction called/with name on component address
• Fix css and display about component status
• Fix select entity redirect
• Change class on last records widget
• Fix app DB cache on recreating same application
• Fix deleting SQL user when deleting application
• Fix add member to gitlab project if already in project
• Fix first connection code platform session missing
• Fix set title css
• Add env variable priority for DEMO_MODE
• Fix setup SQL for MySQL and MariaDB
• Fix req.logout that need a callback
• Fix set logo
• Fix deleting auto_generated related to where source and target is the same entity
• Linter correction
• Fix instruction param entity
• Fix /set_status and notification redirection, headers.referer can be undefined
• Handle MySQL error on GRANT PRIVILEGES while generating new app
• Fix Nodea tutorial, stopping the tutorial is now store in browser instead of session
• Minor UI fixes

3.0.2 Hotfix 3

Bug Fix

• Fix deploy on existing container, now generate new access token each time deploying
• Fix branch detection when using 'deploy [branch]' instruction, now use Gitlab API instead of git to check branch availability

3.0.2 Hotfix 2

Bug Fix

• Fix app database env variable conflict with Nodea

3.0.2 Hotfix 1

Improvements

• Improve deploy network IP handling
• Improve datatable helper logic

Bug Fix

• Fix datatable related to field not showing

3.0.2

Feature

• Deploy [branch] instruction now available

Improvements

• New 'beforeQuery' route hook in search() route
• New 'start' and 'beforeSend' hooks in app/widgets() POST route
• Optimize size of public folder by removing useless ressouces
• Improve file handling middleware
• Improve and change the way of init NodeaTables
• Add app.js delete_file route
• Move models/index.js customAfterSync() hook code in _core
• Login system return more vague error message for security reasons, addind error logs instead
• Add transaction in api routes
• JSDoc improvements
• Move customAfterSync ORM hooks in _core
• Improve Nodea picture management, move keys from to global.js to application.json
• Remove customWhere from dust file for security reason
• NPM module bcrypt-nodejs changed for bcrypt
• Salt included in every password hash
• XSS protection improved

Bug Fix

• Fix breadcrumb in module UI.
• Move /status_comment in app/root.js file
• TABLE_NAME instead of media_sms in database
• Fix syntax error in NodeaForms
• Fix mouse dynamism on datatables
• Fix redirect after login
• Fix document template f_format_pair on update
• Fix entity filter in document template display on entity
• Fix document template required field
• Add missing commented hooks in some routes files
• Fix app/root.js additionnal route not possible before

3.0.1

Feature

• JSDoc implemented for CoreEntity

Improvements

• Improve code editor, files wont close anymore when executing instruction
• Add warning before instruction if modified file not saved in code editor
• Various improvements on the way of killing application child process
• Improvements on UI Designer
• Rework bot field type handling, now it will parse any given type in one and simple understabled nodeaType
• Add new powertips and improve CSS
• Various NodeaTable improvements
• Add Home module in group access configuration
• Improve component address on address_label field management
• Improve Nodea 'with type' suggestions
• Upgrade agenda component to Fullcalendar v5.7

Bug Fix

• Fix has many existing generated code
• Fix Nodea Dust helper contextUpperDump
• Fix delete module instruction
• Fix setting field unique on related to field
• Fix code editor refresh file content after instruction
• Disabled deploy instruction, WIP for 3.1
• Fix child process kill, now it only kill the concerned application
• Fix error overlay CSS on preview
• Fix UI Designer and code editor commit m
• Fix package.json name and version
• Fix access.json import
• Fix agenda component
• Fix status piechart colors
• Fix filename with uuid in page
• Minor CSS & JS fix

3.0 Hotfix 1

Bug Fix

• Adding forgotten essential file (oops my bad)

3.0

First master release of Nodea Software !
More features and improvements coming soon !

Know more on: Nodea Software

---