2023.3

Changed the record import subsystem by upgrading it with the new data transformation framework. The change was made to optimize the process of importing records by making it more stable, efficient, and capable of handling large amounts of record imports (399f9a7).

Fixed record import not importing anything with no reported errors. The fix was made by fixing the file management to correctly report rows and counts The issue was caused because the state wasn’t reset correctly after performing a preflight to analyze and count records (532e1ac).

Fixed undefined property error in the developer console when removing a page block (1476).

Fixed duplicate identification keys error in the developer console when configuring automation buttons (28d4d0d).

Fixed metric element not respecting its format configuration and displaying as default integer in Reporter (1421).

Fixed page layout expressions not being evaluated when switching from editing to viewing a record This fix also addressed the issue of record object not being present on initial load (1475).

Added the option to delete a preset filter from filter preset dropdown in a record list for administrator roles. The change was added to provide all administrator role users with the option to permanently delete a preset filter (1449).

Added the option to sort the system fields (ownedBy, createdBy, updatedBy, and deletedBy) as well as user and record fields and in record lists. The change was added to make sorting/viewing data easier for the user (1449).

Changed option to clone a page layout by adding two sub options - for cloning a page with page block reference and for cloning a page without page block reference. When cloning by reference, configuration changes that are made to the original page’s blocks are also reflected to the copied page’s page blocks. And when cloning without reference, the changes made to the original page’s blocks are not reflected to the copied page’s page blocks. The change was made to provide the user with the option to choose whether the copied page’s block configuration should be shared among pages (1444).

Changed the UI for uploading a namespace by showing a spinner while data is being processed and hiding the name and handle field of the namespace instead of showing the spinner and fields at the same time. The change was made to be consistent with the UI in Corteza (c997655).

Changed the handle field for a user to not be required when updating the resource in Admin (ed377a7).

Changed general ui/ux improvements:

Fixed non-record page blocks not being refreshed in a modal after a record has been added or edited (1444).

Fixed the refresh all record values prompt in workflows not updating record values when workflow is executed (1445).

Fixed page content not being shown when creating record in magnified modal (55dfcb8).

Fixed page blocks not being refreshed with the correct data after a record has been updated (8c6c3b8).

Fixed record fetching not returning all available pages in case RBAC rules would filter out a larger chunk. The fix was made by tracking both included and excluded records and adjusting termination logic accordingly (8e03ea5).

Added splice function in workflows that can change the contents of an array by removing or replacing existing elements of different types like strings, numbers, booleans, objects, arrays and/or adding new elements in place. The change was added to provide the option to easily add or remove elements from an array (7bc36eb).

Added the option to fetch data for a geometry page block when clicking on the refresh button in the page block or after a set by the user amount of time. The change was added to provide the option to easily fetch data for the page block (f189c43).

Added a dropdown to look up the permissions of a concrete module, page or page layout. The change was added to provide the option of viewing permissions of a resource without having to visit it (7fdc854).

Changed general ui/ux improvements:

Fixed invalid username and password combination error on sign up caused when trying to create a user with a handle that already exists (1413).

Fixed prefilter in progress bar page block not returning any data if records are filtered by recordID (1414).

Fixed being redirected to list of namespace/pages/modules instead of the previous page after clicking on the Save and close button when creating or editing a namespace/page/module (1387, abe1eb6).

Fixed side menu with reports not opening in Reporter when hovering over its 'opening' bars icon (1425).

Fixed incorrect number of pages shown when the full page navigation and show total number of records options are enabled in a record list (1417).

Fixed triggering of unsaved changes message when trying to leave the Low Code settings page in Admin after saving the changes to the user interface settings (1429).

Fixed missing page layout permissions for authenticated and administrator roles. The fix was made by adding the permissions to the roles (2c7e972).

Added the option to configure whether module field value is on the same row as its label in the page block. The change was added to provide the user with the option to set the position of a field value (1339).

Added case insensitive search in a record list if MySQL database is used. The change was added to make searching of records easier by returning similar results to the searching criteria (1355).

Changed page navigation to stop loading previous resources in case we’ve navigated to a new page. The change was made to reduce the amount of needless processing since the old resources would be discarded right away (638ba17).

Changed general ui/ux improvements:

Fixed long texts to no longer overflow in Low Code (895796a).

Fixed compose sub-pages not being shown when configuring a navigation page block (1359).

Fixed module field labels shown underneath delete button when bulk editing a value (6f6df66).

Fixed drill-down option in the metric page block not working if the metric label wasn’t provided (95ae09e).

Fixed memory leak issue for Low Code when switching between different pages (95cf245).

Fixed not being able to save a page after removing a page block from a tabs page block (5addb87).

Fixed conditional fields being displayed when viewing records even though their condition evaluates to false (e081faa).

Fixed not being able to create a record in a modal because the view opens behind the modal Now, the view opens in the modal and a record can be created in it (ac9bc74).

Fixed namespace sidebar not being hidden/show correctly when creating a new namespace because it was pinned (ac9bc74).

Fixed error for stale data showing if a report data source is misconfigured in Reporter (773beaf).

Fixed not being able to search for a record by record id in a record list using 'Like', 'Not like', and 'Not equal' conditions (1354).

Fixed not being able to edit a workflow expression after clicking on a browser tab/window (56264e1).

Fixed the visibility of the inline record editor option in a record list to hidden if a module isn’t provided (b96ea0e).

Added a button that allows the user to edit record values in a record block without having to open the record in edit mode. The change was added to give the user the ability to easily edit a single field when viewing a record (1282).

Added options to zoom in and download a file from a record. The change was added to give the user the flexibility to preview and download files when viewing a record (1310).

Added new ways of displaying Select module fields allowing you to show configured options as check boxes or radio buttons. The change was added to provide the user with an additional ways to view for the Select field value/values (1301).

Added the ability to use a record value in a record page title. The change was added to give the user the freedom to customize a record page title using record values (1332).

Added the option to display a checkbox as a toggle switch. The change was added to give the user another way of interacting with the checkbox field (1286).

Changed role un-delete operation to dispatch role update events on the event bus. The change was made to keep it consistent with other resource operations (6558efc).

Changed the Corteza authentication flow to skip unneeded screens and get the user directly to the requested web application as soon as possible. The change was made to improve the authentication user interface and experience (1284).

Fixed input parameter handling for the integration gateway proxy filter Now, the entire integration gateway pipeline scope can be used in the proxy filter (1e82fc0).

Fixed wrong condition priority when filtering the record list with the Not equal operator (1300).

Fixed the Low Code namespace changed alert prompt only when we’re leaving the page and unsaved changes are present Before, it the alert would prompt after saving changes when creating or updating a namespace (1298).

Fixed role members not showing when viewing or editing a role (1296).

Fixed an error preventing users from navigating back to the role list after viewing/editing a contextual role (1307).

Fixed record list export not including all of the active filters which resulted in inconsistent output (1318).

Fixed not being able to magnify unsaved page blocks (1289, 1291).

Fixed module field select translations not being saved when configuring the field (311c879).

Fixed module field validations for unique values not being saved when configuring the field (295defc).

Fixed date and time value not being saved when creating an auth client (1337, 3ed432e, bd0a941).

Fixed the position of the actions menu (three dots) in compose chart, module, and namespace list to be always visible on hover even if the list column isn’t visible (1331).

Added a warning message that notifies the user if they try to leave a page with unsaved changes on it. The change was added to prevent losing changes that haven’t been saved yet (1051).

Added the option to add custom styles to all of the web applications. The styles can be added via the user settings in Admin. The change was added to provide the user with more freedom to style the applications as they see fit (1262).

Changed general UI/UX improvements:

Fixed not being able to view a map if the value for latitude or longitude isn’t provided in the map configuration (1032).

Fixed error in console when trying to add a module constraint without providing a value (1281).

Fixed unsaved changes warning triggered after a namespace has been saved and you want to visit it (aa7cdf2).

Fixed the labels updated at and deleted at not showing after an Admin application was updated or deleted The labels provide additional information as to what types of changes have happened to a resource (ce541cd).

Added option for transparent color in the color picker used in Admin, and Reporter. The change was added to give users more configuration options when selecting color or background color for an element (1211).

Added the option to set a record list filter as a preset filter for a user. The filter can be applied using the 'Filters' dropdown menu. The change was added to give the user the ability to pick a pre-configured filter (1227).

Added menu with 'more' options (delete, un-delete, and permissions) to resource lists in Low Code, Admin, Reporter, and Workflow. The change was added so the user doesn’t have to scroll horizontally to access all resource options (46f5455).

Added a stale data error in case resources like workflows are updated whilst a different user is editing the same resource. The change was added to help reduce configuration errors due to multiple people editing the same resource at the same time (2529cf3).

Added button to select all records in a record list and preform the actions edit, delete, un-delete as well as executing workflows. The change was added to provide the user with an easier way to edit, delete, un-delete, and execute workflows on records across multiple pages (89f621c).

Changed the way reminders in Low Code look and behave which provides an easier way for the user to work with. The change was made to be consistent with the rest of the Corteza UI and improve the UX (1239).

Changed the feedback email domain in the page header of every Corteza web application from crusttech to cortezaprojectorg (0072a4b).

Changed reminders to clear out the snooze count after editing and modifying when the reminder should prompt (256dd59).

Changed the format of displaying the total number of record list items - if N is number of records, then the new format would be N items to N records (0fcbec0).

Changed the block magnify query param that keeps track of which block is magnified (zoomed in). The change was made to ensure that any future code implementations don’t collide with the block magnify query param (5fde4c9).

Changed the value of the SMTP_FROM variable in the server .env variables. Previously if a value was set in the .env file, it wasn’t respected. The change was made to give developers the option to configure SMTP setting not only from the UI but also though the env file (d2b389b).

Changed default workflow and trigger action severity to notice to keep it consistent with other resources in Admin. The change was made to make create, update, delete, and undelete actions visible in the default production ruleset of the actionlog (31f7e14).

Fixed multiline privacy request comments displaying as inline comments. The fix was made by adding support for multiline comments in privacy requests (1214).

Fixed Low Code broken public icon url for page, namespace, and custom app icons after changing the Auth JWT secret. The fix was made by adding an exception for the namespace icons, page, and icon attachments (1219).

Fixed available and selected fields not scrollable in safari due to set max height in the item picker component This issue was present in Low Code and {APP_NAME_PRIVACY} (1221).

Fixed funnel chart labels being hidden after hovering over them (1222).

Fixed the functionality to expand text in the description field used in Workflow’s error step (84215c0).

Fixed automation sessions list sorting parameter in Admin The parameter was excepting the incorrect type of value (1141).

Fixed copy of page layout in Low Code A page with layout couldn’t be copied because of duplicate page handle value (1230).

Fixed page blocks disappearing from the page builder after being removed from tabs configuration (c939015).

Fixed connection map not showing in {APP_NAME_PRIVACY} on mobile devices (ca12cc9).

Fixed overflowing text in the Record Organizer component (f09f1fa).

Fixed known concurrent map read/write issues for Integration Gateway profiler and workflow pre-processing (3703598).

Fixed missing sessionID parameter in automation session search The sessionID value wasn’t taken into consideration when filtering an automation session list (3703598).

Fixed compose page not being accessible unless the sub pages option is enabled (ed0ac43).

Fixed error for not included page layout resources when exporting namespace configuration. The fix was made by including page layouts to the namespace export logic (4ad1217).

Fixed error preventing user from being able to add a non numeric value to gauge chart dimension labels in Low Code (f9b9661).

Fixed the setting of workflow and trigger IDs after creating action log events (03806a2).

Added ability to drill down metrics, by clicking on a data entry inside the metrics block. Based on the configuration it can either filter an existing record list on the page, that is showing the records from the same module as the metric, or open a new record list in a modal. The change was added to make it easier for users to filter record lists based on metrics data, in order to view the details of said data (1184).

Added support for opening geometry and record organizer page block records in a modal. The change was added to give users the ability to open records in a modal without leaving the page that they are on (1177).

Added support for error handling message inside workflows by letting configurators access the context of the error message. The change was added to give user more freedom in defining error handling and to know where and on which step the error occurred (1088).

Added http prefixes to all URL input values across Corteza if it is not provided by the user. The change was added to make it easier for users to define URLs with leaving out the http:// part (1188).

Changed record selector value resolution fetching per page block instead of per field so no redundant fetches are done. The change was made to improve performance on slower connections/systems. The change was made by moving it to per page block instead of per field as it was previously (1176).

Changed the sidebar of Low Code and Reporter to be scrollable just on items and the search bar and public/admin page button to be always on top. The change was made to improve the accessibility of the the search bar and the buttons for public and admin page. The change was made by making the sidebar components stick to top (1189).

Fixed charts and reporter elements utilizing aggregation erroring out. The issue was caused because the sqlserver driver does not yet support offloading of aggregation steps. The fix was made by keeping aggregation on the application level until a few blockers are resolved (f931275).

Fixed failing provision step reporting a malformed SQL statement. The issue was caused by the provision function which utilized raw SQL with is not compatible with the sqlserver. The fix was made by skipping that provision on sqlserver because it does not need to exist for that driver The driver was introduced with the structure change so it is unneeded (1d4ab0b).

Fixed failing a fresh provision on an sqlserver database driver with an SQL typecasting error. The fix was made by correctly handling and defaulting setting timestamp values (7675e5d).

Fixed tabs block titles getting erased once you add a new block to the list. The fix was made by not updating the title when creating a block (1170).

Fixed data and time input boxes not being responsive and resulting in being cut off on smaller screens. The fix was made by updating the date and time module field responsiveness (1156).

Fixed hash and query URL trim on URL input record field trimming the part before the hash and query instead of after it. The fix was made by changing the order of trimming methods to match their corresponding labels (1173).

Fixed hovering on record event on calendar agenda not showing the cursor as pointer. The fix was made by changing the cursor from text selector to pointer (1179).

Fixed workflow dry run process not stopping on server timeout/error. The fix was made by resetting the state and refreshing the trigger label so the spinner disappears (1195).

Fixed webapp page titles not shown on small screens (1175).

Fixed not being able to cancel more than one privacy request consecutively in {APP_NAME_PRIVACY} (a559569).

Fixed record organizer not showing any data for a multi value fields. The fix was made by removing sort on label and description field (1176).

Fixed record selector of a record selector showing the record field as an ID instead of text. The fix was made by properly resolving multiple record values (1176).

Fixed metrics block data not being consistent in page builder mode when configurator is updated. The fix was made by updating the metric base component with a listener that refreshes the metric base when the configurator is updated (1207).

Added support for page duplication in edit mode and page builder view. The change was added because this speeds up the development process of the project and allows users to copy/share content from one page to another (450, 47e06eb).

Added support for personalized auth screen. The change was added to simplify styles of the auth pages without the need to alter the source templates Uploading the image will update the Auth background image, and the styles will supplement Auth screen’s styles (446).

Added support for opening a record in a new tab or in a modal. The change was added to make editing of the records a bit more intuitive, since the user will remain on the record list page while doing the changes (524, 524).

Added support for cloning and coping page blocks in page builders. The change was added to allow users to duplicate and re-use page blocks more easily (582).

Added support for viewing and undeleting a deleted single or multiple records in a record list. The change was added to allow users to view and restore deleted records (740).

Added support for a fully customizable navigation page block with multiple navigation item type and customizable options for the navigation list items. The change was added to have the ability to show one or two level of dynamic and static navigation (41f1283).

Added support for conditional fields. The change was added to give users more control on how records are displayed (770).

Added support for navigating to the next or previous record when inside a record page for easier and faster toggling between the records. The change was added to allow users go over all their leads one by one without leaving the record page (836).

Added support for bulk record updates. The change was added to allow the users to update multiple records in a record list (906, 906, 906, 906, 906).

Added support for a new page block in Low Code called tabs block where each tab is a different block. The change was added to make page block organizing much easier for users (670, 670).

Added support for administrators to pre-define record list filters which can be applied to their record list if they are part of a specific role. The filters are grouped by roles, allowing more flexibility as to who sees what. The change was added to allow users to quickly apply filter to the record list (921, 921, 921).

Added support for geo location capture and ability to set or prefill current location while on a map. The change was added to improve the user experience and the location accuracy of the users Now instead of manually entering their coordinates, they can just use the find me button and the coordinates will be updated (955, 955, 955, 955).

Added support for uploading an icon for specific page for the sidebar. The change was added to allow the user to further customize a page (72d4471).

Added support for geo address search functionality on the geometry module field editor/viewer. The change was added to give users access to address search functionality when on the geometry module field editor/viewer (968, 968, 968, 968).

Added support to open record selector fields in a modal. The change was added to make viewing of records a bit more intuitive, since the user will remain on the record list page while opening a record selector pointing to another module (997).

Added support to reference a record from a record selector field pointing out to another module. The change was added to give the user an ability to view the referenced record selector on the initial record page (d5cb466).

Added support for opening a calendar event source in a modal, new tab or in the same tab according to the user configuration. The change was added to allow the user to open the event source records without going away from the calendar block (1104).

Added support for radar and scatter type charts. The change was added to give users more options when displaying data with charts (1148, 1148, 1148).

Added support for uploading ico files in record lists and file page blocks (1072).

Added the ability for users to disable the navigation sidebar within Low Code namespace public pages. The option is available under the hide sidebar on namespace public pages checkbox in the namespace edit screen. The change was added because we wanted to provide the option of disabling built-in navigation in favour of re-defining it with the new navigation page block (41ed9ed).

Added auto-refreshing and manual refreshing feature to page blocks excluding, Content, Record and File Blocks. An icon now appears on blocks when you enable the refresh feature. That icon is clickable even though refresh will happen automatically based on the duration you have set. The change was added because users do not have to refresh the entire page to see new content on blocks and to give users more control over refreshing when auto-refreshing is not needed (73, 760).

Added geometry page block to render a map with data points collected from record sources. The geometry page block can show either points, lines or polygons based on the configured record feed sources. The change was added to enable the users with better visual representation of their data (538).

Added new style configuration for the file page block and file record field. Users can now change the height, width, borders, margins and the background color of their file attachment. The change was added to provide users with more customization and styling option on viewing images (533).

Added an option to magnify certain page blocks when viewing a public Low Code page. A select dropdown has been added in the general tab of page block configuration modal for calendar, chart, content, comments, file, iframe, record list, report, and record revisions page blocks. The user can select between Fullwidth or Modal select option, and when enabled, the user will see a magnify icon at the top of the block. The change was added to help users finding the info they are looking for much faster and easier with the option to magnify certain page blocks (576).

Added a spinner to indicate when an action in template editor is submitted. The change was added to have an UI consistency, because it was difficult to tell when your changes were being submitted (708).

Added a module field description when configuring a record list page block to inform the users that if no fields are selected, the default values will be shown (751).

Added ability to serve data as response in an integration gateway route by adding a route description field. The change was added to give an endpoint response greater extensibility to integration gateway as different data can be returned (775, 775, 775, 775, 775).

Added Route description field, Filters sorting, Profiler hits purging and Integration gateway settings (775, 775).

Added BETWEEN and NOT BETWEEN operator support for single value fields (number and date-time module fields). The change was added to extend record filtering support for range filtering of numeric and date-time for single value field (813).

Added ability to drill down charts, by clicking on a data entry inside the chart. Based on the configuration it can either filter an existing record list on the page that is showing the records from the same module as the chart or open a new record list in a modal. The change was added to make it easier for users to filter record lists based on chart data, in order to view the details of said data (877).

Added functionality to generate user avatars and enable users to upload and manage their profile photos. The change was added to provide users with greater flexibility and customization options for their profile avatars, while also allowing admins to manage avatars on behalf of users (887).

Added drag-and-drop expression sorting in workflows expression step. The change was added to allow the user the ability to sort the existing expressions for a more intuitive and faster workflow implementation (1081).

Added Auto grouping and timeline to radar and scatter type charts. The change was added to give users more options when displaying data with charts (1148).

Added extended record duplicate detection configuration to support multi value matching criteria and value checking algorithms. The change was added to extend support for record duplicate detection with multiple fields in single rule with various detection algorithm and muli-value matching criteria (617, 617).

Added new file configurator option to preview image in modal and option to download. Images on the file base are centered now by default. The change was added to center the images on the filebase for better user experience (937, 937).

Changed the requirement to provide a handle when creating a resource is now optional. The change is applied in Low Code, Admin, Reporter, and Workflow The change was made because providing a handle shouldn’t be a necessity. The resource can be created without it. The change was made by removing the requirement for the handle to be provided (cd86e85, cf21c47, 456c896, 9b88af0, 24b0dda, 34f261a, 3a90a10).

Changed the record revision table text to be saying No record revisions found when no revisions are present. The change was made to have a better user experience when there are no record revisions present. The change was made by adding an empty table with No record revisions found message in the record page builder (758).

Changed the Record ID field in module connection settings being able to be disabled. The change was made to prevent users from disabling Record ID field on system field mapping and to not show system fields that are not available. Also to allow users to easily enable or disable system fields based on their configuration. The change was made by updating system view configurator and system field mapping logic to prevent Record ID from being disabled (523).

Changed the name of a page when was copied multiply times was changed to show the copy and after that the name of the page and a counter in brackets. The change was made to improve user experience. If we copy a page 3-4 or more times, the naming gets confusing and too long. The change was made by filtering how many times a certain page with same name already exists and including 'copy of' prefix and number suffix Depending on the number of pages that match the same name, a counter is adjusted (644).

Changed workflow iterators to treat limit 0 parameter as no limit set. The change was made to make workflow iterators consistent with other searching/filtering interactions. The change was made by changing the limit in the code (cc24e62).

Changed the geometry multivalue map opening the default map location regardless which record location you press. Now the opened map changes according to the record’s geo location. The change was made to prevent a confusion when different markers in multivalue fields were being opened on the map. This change aims to improve ux and usability of the geometry field. The change was made Leaflet map instance and zoom level was updated (940).

Changed the rotate and metric label field configuration for pie and doughnut charts by hiding the configuration since it was not needed. The change was made to have consistency since they were shown but not needed. Now they are hidden since we don’t need them. The change was made updating the chart configurations to adjust existing rotate logic for the above-mentioned charts (992).

Changed the output format to become hidden if output relative value is selected in date field. The change was made to prevent confusion since when you have relative value, the output format is not taken into account. The change was made by updating the date and time configuration (1019).

Changed the record toolbar back button to always bring you back to the page where you came from. The change was made to prevent users getting stuck in a loop and to allow them to go back to the previous page that they were onto (1155).

Changed general ui/ux improvements:

Fixed discovery not displaying any search result when namespace with module filters was selected. The fix was made by adding minimum string match criteria to match exact string match for search results (e2c374c).

Fixed Low Code Gauge chart not displaying the correct results when post processing function was used because the post processing function was not taken into consideration. The fix was made by adding a post processing method to Gauge Chart Low Code type (865).

Fixed the integration gateway route search filtering in administration area not returning any result if the whole name was not entered. The fix was made by fixing the way filtering works on integration routes search (e551b73).

Fixed the deleted status on application programming interface gateway route update getting preserved. Previously if you edited a deleted route, the route got restored, now this is improved. The fix was made by changing the part of application programming interface gateway service that handles route updates (16257e9).