From enhancing web service flat tables and gaining access to MSSQL databases to fine-tuning filter systems, workflows, and addressing a slew of bugs, the commitment to progress knows no bounds. This blog post explores the relentless pursuit of improvement in this dynamic landscape, shedding light on the latest advancements, code cleanup efforts, and performance optimizations. Join us in this exploration of how automation technologies continue to push the boundaries of efficiency and reliability, making strides in the pursuit of excellence. (chatgpt power)

• Document Management System keeps advancing
  • preview xlsx and docx
  • support mass actions
  • improve UI when there are many columns
  • shortcuts, mass actions and show more functionality
• activate Italian Language on the install
• give more information on failed update validation
• support CI with DRONE. Malik configures Drone to do a standard set of checks and run our unit tests on the evolutivoFW code every time we get a pull request. Note that this configuration can also be used on any project we have in our Gitea repository manager, so if you want to apply this knowledge to one or more of your customer projects raise the request and we will organize it.
  • the set of checks and tests can also be launched on demand
  • this project added a set of unit tests and cleaned up the code base
• filter management enhancements
  • convert sort field and sort order fields to picklists for easier and less error-prone configuration
  • getCreatePermission function for module and user. use new function in filter panel actions
• change actions in the notification panel
• support inline edit for ApplicationFieldTypes
• Workflows
  • adding a third parameter for the format_date expression function to define the format the input date is in
  • evaluate validations before save for update field, create entity, and upstert workflow tasks. this is a very useful enhancement that, optionally, enforces the defined validation rules for records when updating them through the workflow system
  • add support for getGlobalVariable expression in web service map URL and HEADER directives. We now can use, getSetting, getContext and getGlobalVariable and we do that by refactoring the code to reduce duplication
  • support Multireference field in update workflow task and getIDsOf
• Web Service
  • mysql flat table officially arrives thanks to the work of Arlind. I will talk about this shortly in another blog post.
  • connect to foreign Microsoft SQL Server. Arlind also adds an abstraction layer to connect to external MSSQL tables. We'll talk about this shortly too.
  • add helper script for testing MSSQL connection

• EvolutivoFW Standard Formatting
  • the CI project lands and brings some formatting and style changes all over the application
• Documentation: code and wiki.
  • picking up traction in the wiki documentation, very happy.
  • additional HELP_CBAddNotification_MoreAction documentation
• LDS Styling
• Refactor and Optimize code
  • sonarqube recommendations
  • removed deprecated field type check in ActorMeta. Eliminate usage of obsolete database table
  • eliminate reference to old Events module in SQL
  • reduce SQL columns and eliminate whitespace
  • removing duplicate callSearch function in colorizer
  • workflow, message template, and filter management refactor to move common code into one file
• Security fixes and updates
  • enhance bettersafe script and add more .htaccess protections
  • we eliminate all usage of the test directory, it is no longer needed
  • update guzzle to 7.2.0
  • update Web Service libraries to the latest version for PHP and JS
• PHP constant updates
• Unit Tests: keeps getting more and more assertions.
  • This is also picking up traction, very necessary.

• Report_CanCreate: indicate if the current user can create reports or not.

• Business Map
  • correctly apply read-only on uitype 10 and date fields for Field Dependencies
  • notDuplicate validation query to find duplicates must use an admin user to have permission to check all the records
• Custom View
  • fix sort by field labels
  • block creation with direct access
  • correctly support field labels with special characters in edit
  • two order by in query fix
  • error when loading custom default filter in Mobile UI
• Colorizer
  • colorize the whole row in popup window fix
  • save conditions at the same time for table and tuigrid
• Calendar
  • empty reminder dates
  • support custom subject as an array
• Module Builder
  • assign moduleId a value from modulerbuilderid and use it from local storage
  • resetting inStyle.onchange to empty before UIType check
• Home
  • migrate filter widget to View Permissions
  • use query generator to get Aggregation widget query instead of obsolete ListViewQuery
• correctly remove UIType10 fields in Detail View when modules are deactivated or not accessible by current user
• show record count in Document table list view
• close Emails popup if we have selected records
• treat Excel sheet export boolean as true if the value is 1 besides the translated positive word
• correctly set non-mapped fields to none option when selecting a saved map in the import process
• return 405 error code in header when health (ping) finds an error
• Workflow
  • expression popup not working fix
  • incorrect response AUTHENTICATION_REQUIRED fix
• Translations

Thanks for reading.