7. Changelog
This section details the fixes, changes, and new features included in each version of LUCA.
API 4.0.0 - WEB 4.0.0 (31/03/2026)
New Features
- LUCA-3568: Allows configuring SSO with Google
- LUCA-3566: Incorporation of the LUCA Chatbot
- LUCA-3541: Allows uploading AI models
- LUCA-3542: Chat menu
- LUCA-3565: Predictions in time series
- LUCA-3669: Statistics in time series
Fixes
- LUCA-3687: The email sending error report does not correctly log the failures
Changes
- LUCA-3567: UI restyling
- LUCA-3540: Installer update
API 3.16.4 - WEB 1.16.4 (15/12/2025)
New Features
- LUCA-3531: Allow choosing whether to execute the query by default or not from the configuration menu
Fixes
- LUCA-3527: When executing a query, the configured filter is not taken into account
API 3.16.3 - WEB 1.16.3 (18/11/2025)
Fixes
- LUCA-3528: The environment ID is not sent correctly in the creation of public links
API 3.16.2 - WEB 1.16.2 (22/10/2025)
Changes
- LUCA-3529: Library update
- LUCA-3532: Internal variables now include the current user, the environment, and the current date.
New Features
- LUCA-3530: Base64 type public link with modifiable filters
API 3.16.1 - WEB 1.16.1 (18/07/2025)
New Features
- LUCA-3526: Allow adding filters when creating public links in dashboards
API 3.16.0 - WEB 1.16.0 (29/05/2025)
New Features
- LUCA-3195: On-Premise installer
- LUCA-3220: Shortcut to the SQL console in system configuration
- LUCA-3245: Import and export LUCA elements
- LUCA-3418: Python library
- LUCA-3289: Allow changing the sorting of data in basic graphs
- LUCA-3326: Connector for Neo4j
- LUCA-3258: Connector for Trino
Fixes
- LUCA-3433: When changing the title configuration, the subtitle disappears.
Changes
- LUCA-3434: When querying user permissions, those assigned in the default profile are also listed
API 3.15.0 - WEB 1.15.0 (16/07/2024)
New Features
- LUCA-3135: Beautify and enrich the output text of trees
- LUCA-3143: Add shortcut to edit the main dashboard from application editing
- LUCA-2860: Allow disabling parameters and headers in HTTP queries
- LUCA-3147: New REST type IDbox data source
Fixes
- LUCA-3152: Deleting linked variables in forms causes a general error
API 3.14.0 - WEB 1.14.1 (22/05/2024)
Fixes
- LUCA-3132: Fixed error when updating LUCA configuration parameters
API 3.14.0 - WEB 1.14.0 (08/05/2024)
New Features
- LUCA-2863: If an HTTP query fails, display the error in the query configuration window
- LUCA-3078: Pagination does not appear in GET queries when the no paginate option is checked
- LUCA-3084: Error when returning the last day of March, showing March 30, 2024, instead of March 31, 2024
- LUCA-3094: Add a tooltip so that when hovering over fields in the select query from the form
- LUCA-3095: Modify the Mail process so that the dispatcher sends individual emails using CURRENT type variables
- LUCA-3097: Display the totals in Spanish for the queries
- LUCA-3111: Create query audit and save its modifications
Fixes
- LUCA-3064: The element does not update in the submenu of an application
- LUCA-3067: Adding two or more donut-type charts with totals misaligns the totalizer
- LUCA-3096: When creating a new system, if you change the type, the data sources of the changed type do not appear
- LUCA-3105: Limits in gauge-type charts are not visible in the configuration area
- LUCA-3106: Add tooltip values of series that are 0 when grouped
- LUCA-3109: The color picker in donut-type charts for the series color does not work
- LUCA-3110: Remove the text you have written when selecting an option in mailing
- LUCA-3118: Correct to ensure that max and min work for String fields in HTTP queries
API 3.13.0 - WEB 1.13.0 (08/04/2024)
New Features
- LUCA-3074: Expand the usage screen to add queries used in the Mail
Fixes
- LUCA-3086: Corrections when executing the Mailing process
- LUCA-3072: Issue with Keycloak when disabling and enabling the user from LUCA
Changes
- LUCA-3079: Security and library updates
API 3.12.2 - WEB 1.12.3 (06/03/2024)
New Features
- LUCA-3058: Allow adding additional authentication parameters to the REST type data source
- LUCA-3055: Add PATCH type requests
Fixes
- LUCA-3053: Fixed email update
API 3.12.1 - WEB 1.12.2 (31/01/2024)
Fixes
- LUCA-3022: Fixed PNG export of charts
- LUCA-3037: Fixed styles in tree editing, pagination was not visible
- LUCA-3044: Fixed saving parameters from the Web
- LUCA-3045: Fixed error when opening public links of type query in Firefox
API 3.12.1 - WEB 1.12.1 (11/01/2024)
Fixes
- LUCA-3036: Time range type variables do not work in public links
- LUCA-3037: API documentation is no longer available
API 3.12.0 - WEB 1.12.0 (20/12/2023)
Fixes
- LUCA-3008: Executing a query with formula type variables from editing does not work
- LUCA-3015: The source date format does not update until the query is saved
- LUCA-3026: Axes widths only allow storing integer values instead of decimals
- LUCA-3031: The values of new output variables disappear when adding advanced configuration
New Features
- LUCA-3001: Creation of public links for any LUCA element
- LUCA-3020: New data source 'Microsoft Dataverse'
Changes
- LUCA-2981: Required variables in dashboard filters
- LUCA-3027: Return to page 1 in a query if it returns fewer pages than the page you are on
- LUCA-2993: Improvements in pivot tables. More data expansion options and color changes
- LUCA-3029: In the query list, change the Import icon
API 3.11.0 - WEB 1.11.0 (16/10/2023)
Fixes
- LUCA-2978: Error with stacked charts whose category is numeric
- LUCA-2984: Long variable names in insert/update/delete queries do not align correctly
- LUCA-2979: Show "no data" message when there are no data in charts
- LUCA-2974: Do not allow editing/deleting elements if the user does not have permissions
New Features
- LUCA-874: Boolean type input variables
- LUCA-2941: Profile cloning
- LUCA-2776: HTML chart templates
- LUCA-2508: Configure numeric formats in chart series
Changes
- LUCA-2910: In date groupings in charts, add the month in the format January, February, March...
- LUCA-2462: Show data type (int, varchar...) in database viewer table columns
- LUCA-2969: Add reload button in the element search window
- LUCA-2909: For combo type queries, modify the 'Usage' tab to see in which queries and dashboards it is being used
- LUCA-2986: Ability to import queries to modify existing queries
API 3.10.1 - WEB 1.10.1 (20/09/2023)
Fixes
- LUCA-2966: The update form of an entity in the preview of form editing does not update when a new row is selected.
- LUCA-2971: Range type variables appear smaller when executing queries, trees, charts, and dashboards.
- LUCA-2970: Stacked or grouped charts with a categorical date X-axis do not sort correctly.
- LUCA-2972: Cannot drill down by clicking on a column when there are line type series.
API 3.10.0 - WEB 1.10.0 (04/09/2023)
Fixes
- LUCA-2908: Editing the first parameter and headers HTTP element from the edit button does not work
- LUCA-2911: Categories of a chart are not deleted when the chart is deleted
- LUCA-2928: Query execution in SQL console does not work
- LUCA-2930: When cloning a dashboard with date type filters, the format and default value are cloned incorrectly
- LUCA-2932: The text color of the totalizer in donuts does not update when changed in the color palette
- LUCA-2933: Cannot return to the main query in a tree if a unique output variable with format is empty
- LUCA-2934: Error navigating through trees with unique output and navigating between pages. The correct output is not displayed
- LUCA-2936: Default schema field is missing in the configuration of Oracle type data sources
- LUCA-2938: Cannot delete favorite queries
New Features
- LUCA-2767: New input variable type range
- LUCA-2824: Combos with remote search
- LUCA-2912: Update LUCA license from the website
- LUCA-2902: Include import query button in the query list view
- LUCA-2781: When creating a drilldown, inherit the series configured at the first level
- LUCA-2861: Include declared input variables in the HTTP query editing modal windows
Changes
- LUCA-2859: Allow reordering parameters and headers in HTTP queries
API 3.9.0 - WEB 1.9.0 (19/05/2023)
Fixes
- LUCA-2901: When selecting a REST system in a query and changing to another REST system, an error occurs
- LUCA-2903: When updating the query of a combo in an input variable, the combo values do not update in the preview
- LUCA-2896: In forms, you cannot save twice due to version conflict warning
- LUCA-2753: Remove the 'Optional' option when an input variable of type 'Current User' is selected
- LUCA-2879: In pivot tables, date totalizers do not format the date
- LUCA-2883: Do not make the main json path mandatory when the returned object is not an array
- LUCA-2891: Database schema does not load in query editing or in SQL console
- LUCA-2893: Show error message when trying to save an input variable in a query with a static combo without values
- LUCA-2897: Input variable orders in form queries are not respected in the variable link
- LUCA-2885: Unable to clone charts with annotations in their series
- LUCA-2885: Cannot create a user from LUCA
- LUCA-2880: Cannot save colors for grouped categories
- LUCA-2867: Cannot access the mailing creation view without user admin permissions
- LUCA-2905: When creating an HTML chart, variables do not appear if not saved
- LUCA-2906: Saving an HTML chart deletes the chart title
- LUCA-2907: The key-value table for the body of x-www-form-urlencoded type HTTP requests does not work well
New Features
- LUCA-2445: Ability to import and export queries
- LUCA-2826: Capture HTTP 500 and 400 errors and display a modal with an error description
- LUCA-2838: Improve access denied errors
- LUCA-2875: Allow basic graphs to have linear or logarithmic type X-axes
- LUCA-2786: Ability to create links in dashboards by filling out filters
Changes
- LUCA-2900: Add a shortcut button to the management of a combo from the configuration of a combo in input variables
- LUCA-2785: When it is a required linked combo and there is only one element, it should be selected by default
- LUCA-2898: In HTML charts, allow opening links since the iframe security policy blocked it
- LUCA-2892: Ability to expand the side menu in an application
- LUCA-2895: Enable gzip compression in API and web responses to speed up network traffic
- LUCA-2890: Add ;encrypt=false to the end of the SQL Server datasource URL by default
- LUCA-2887: Add the port to the URL of the preview of an HTTP query
API 3.8.0 - WEB 1.8.0 (12/04/2023)
Fixes
- LUCA-2836: Unable to reorder rows, columns, and values in pivot tables
- LUCA-2848: When returning to the main dashboard of an application, it does not reload
- LUCA-2855: In forms, bulk load buttons from CSV appear slightly misaligned
- LUCA-2849: A user with profile administration permissions cannot edit a profile without role, user, and datasource administration
- LUCA-2851: CSV export does not correctly export special characters
- LUCA-2837: Date type output variables in pivot table values do not format the date correctly
- LUCA-2840: Unify the names 'Mailing' and 'Email Reports' in roles and side menu
- LUCA-2843: When executing queries with variables that have not been provided any value, treat them as NULL
- LUCA-2846: When creating a new query with more than one input variable and testing it without saving, values are not sent correctly to the API
New Features
- LUCA-2825: Update Keycloak to version 21
- LUCA-2857: Ability to use clients of type client_credentials in LUCA
- LUCA-2790: Improvements in the HTTP connector
Changes
- LUCA-2831: Style and template modification for Keycloak 21
- LUCA-2840: Unify the names 'Mailing' and 'Email Reports' in roles and side menu
- LUCA-1906: Ability to configure Redis as the cache for queries and charts
- LUCA-2807: Change the id generation strategy for luca_execution_register table to not use the hibernate sequence
- LUCA-2832: Use layers in Docker to generate smaller images of the API and the Dispatcher
- LUCA-2568: Validate default values in numeric input variables
Connections to SQL Server databases are now encrypted by default due to the SQL Server driver update. To disable encryption by default, add: ;encrypt=false at the end of the connection string URL.
API 3.7.1 - WEB 1.7.3 (23/03/2023)
Fixes
- LUCA-2841: Input and output variable names are not visible in dark mode
- LUCA-2842: Cannot filter in the environments combo
- LUCA-2844: In group assignment panels, datasources, and users, checkboxes do not align well with data
- LUCA-2845: When assigning a width to a combo, it increases the width of the combo but not the dropdown
- LUCA-2852: Multi-select input variable queries do not use the selected value to filter
API 3.7.1 - WEB 1.7.2 (08/03/2023)
Fixes
- LUCA-2819: Fixed font size in the tables of tree execution
- LUCA-2827: Fixed style failures in the execution navigation tree
- LUCA-2833: Fixed encoding of HTML and SVG charts
- LUCA-2835: Fixed input size in query filters
API 3.7.1 - WEB 1.7.1 (06/03/2023)
Fixes
- LUCA-2795: The luca_rownumber column is returned for DB2 type data sources
- LUCA-2817: Style corrections for dark mode
- LUCA-2818: Added compatibility with Keycloak versions 20 and 21
- LUCA-2822: An inactive user in LUCA cannot perform any action
- LUCA-2823: Cannot create or edit email reports if the group is not directly assigned to the user
- LUCA-2828: Fixed error of changes in the database for Oracle
- LUCA-2815: Style corrections for multi-selection type combos
API 3.7.0 - WEB 1.7.0 (14/02/2023)
Fixes
- LUCA-2758: Chart labels exceed the top margin if columns are very tall
- LUCA-2764: In a line chart, selecting 'Time series' in categories and then date aggregation does not change the X axis to date type
- LUCA-2778: Very long usernames are cut off in listings of different LUCA elements
- LUCA-2793: In timeline charts with negative values, the X-axis is not repainted when scrolling with zoom
- LUCA-2754: When deleting marked selections in an input variable that is then linked to another one also with a selected option, the second one does not delete its value from the combo
- LUCA-2704: Link generator fails with names containing whitespace
- LUCA-2734: Default values in input variables of a dashboard are not applied on first execution
- LUCA-2750: In SQL console, ensure that all tabs in editors cannot be deleted
- LUCA-2733: X-axis category texts are cut off when height is small, and texts are not rotated
New Features
- LUCA-2770: Scheduled report delivery via email in Excel format
- LUCA-2775: Configure letter color in ranges when selecting the background coloring mode
- LUCA-2744: Create rows in pivot tables
- LUCA-2766: Configure default date values for input variables
- LUCA-2743: Fix output variables to be fixed columns in tables with query results
- LUCA-2440: Assign colors to grouped or stacked categories in basic charts
- LUCA-2735: Searcher in the application desktop
- LUCA-2736: Annotations configuration to indicate maximum and minimum values in area and line series
- LUCA-2740: Configure colors for categories of basic series that are stacked or grouped
Changes
- LUCA-2747: Change combos to virtual scroll. Now 10,000 elements will be visible in combos without mandatory searching
- LUCA-2783: Do not allow saving a LUCA element if someone has saved it before and a conflict occurs
- LUCA-2739: Names of Excel and CSV downloaded from an application with the same name as the menu
- LUCA-2550: Show a warning message when trying to add a drilldown without having added at least one series
API 3.6.1 - WEB 1.6.2 (10/01/2023)
Fixes
- LUCA-2779: No locale fallback in charts when the browser has an unsupported locale
API 3.6.1 - WEB 1.6.1 (28/12/2022)
Fixes
- LUCA-2755: Numerical output variables are not formatted correctly with abbreviations (1K, 1M...) in HTML charts
- LUCA-2759: Tree creation does not work because the tree group is not being sent
- LUCA-2760: A simple SVG and HTML chart can be saved without filling in the corresponding SVG/HTML. It is now required to fill it in
- LUCA-2761: Map type charts with text type series and variables with 'No operation' function do not apply the function correctly
- LUCA-2763: Cannot save a Map type chart when LUCA's configuration database is PostgreSQL
API 3.6.0 - WEB 1.6.0 (20/10/2022)
Fixes
- LUCA-2705: Filters with saved values in linked combos with many elements do not show the saved value as the combo does not load
- LUCA-2710: Show a message that no environment is available when the environment combo is not visible, and the user has no permissions over any environment
- LUCA-2729: Memory allocation to LUCA API via environment variables does not work
- LUCA-2567: Minimum and maximum values of a decimal input variable do not work with decimal values
- LUCA-2621: Links to elements do not work if the title contains the '%' character
- LUCA-2682: Charts with drilldown and vertical categories do not recalculate the column margins when navigating to a drilldown
- LUCA-2691: In the main administration menu, the link to applications takes you to charts
- LUCA-2694: When searching in large combos, it should not differentiate between uppercase and lowercase entered by the user
- LUCA-2695: Does not allow creating groups if only the main group is created
- LUCA-2706: CSV export of charts does not export with the appropriate locale
- LUCA-2707: When changing an application to private visibility, it no longer appears in the application list
New Features
- LUCA-2535: Marker type series for basic charts
- LUCA-2557: SQL console
- LUCA-2436: Ability to edit elements from their execution with a quick shortcut
- LUCA-2728: Links to administration of queries configured in a tree, form, and dashboard from their respective editing screens
- LUCA-2547: Update LUCA ACCOUNTS to version 19.0.3
Changes
- LUCA-2719: Excel export in stream mode
- LUCA-2701: Add English language to the LUCA web
- LUCA-2696: In static combos, remove the ability to add output variables
API 3.5.0 - WEB 1.5.0 (14/07/2022)
Fixes
- LUCA-2504: Very large combos slow down the web
- LUCA-2589: Combos with very large descriptions are not displayed correctly
- LUCA-2612: When the LUCA web is published with a path different from /, links do not open correctly
- LUCA-2638: Outputs whose description contains a period do not display data in tables
- LUCA-2643: Clicking on a date type column to sort results sorts them alphabetically and not by date
- LUCA-2646: Very long categories cause the chart to cut off and not display properly
- LUCA-2649: In 'Usage' of a chart, add which dashboards it is being used in
- LUCA-2651: A user with no permissions assigned sees the 'LUCA Configuration' button
- LUCA-2652: Very large filters in the query editing window do not show scroll
- LUCA-2654: Timeline charts with legends reset the zoom when zoomed in and a series in the legend is unchecked
- LUCA-2657: When updating a record in a form after a mass load, the selected CSV continues to appear and does not allow updating
New Features
- LUCA-2497: Configure fixed maximum and minimum values for the Y-axis of charts
Changes
- LUCA-2655: Make the sizes of chart filters the same during execution when expanded and when not
- LUCA-2611: Increase the size of the USERNAME column in the SECURITY_USERS table
API 3.4.0 - WEB 1.4.0 (26/04/2022)
Fixes
- LUCA-2582: When adding a new submenu to an existing tree, the API returns a 404 on the method to update the tree
- LUCA-2573: When deleting a series from a basic chart, the relation in the LUCA_CHART_BASIC_SERIES_REL table is deleted, but the series itself is not deleted
- LUCA-2566: The same variable cannot be used in a category and in a series
- LUCA-2565: Issue with very long menu names in applications
- LUCA-2564: Issue when creating elements from scratch, everything gets misconfigured once the detail form is filled out
- LUCA-2563: Multiple grouped column series overlap
- LUCA-2549: Remove the 'New variable' button and lock the editing of the 'Key' field in the outputs of combo and static combo queries
- LUCA-2543: Grouped column series overlap other series
- LUCA-2588: Date type categories with null values throw an error
- LUCA-2592: Timeline chart with multiple grouped series duplicates the series
- LUCA-2598: When there are multiple gauges in a dashboard, the limits' titles do not align correctly
- LUCA-2594: Cannot update grouped series and time series
- LUCA-2605: Error causing charts not to execute when LUCA starts
- LUCA-2606: Error in editing map type charts
- LUCA-2607: Simple charts do not accept non-numeric data
New Features
- LUCA-2426: Ability to fill gaps with another type of line for line/area type series
Changes
- LUCA-2427: Automatically rotate X-axis categories to avoid overlapping
- LUCA-2558: Inclusion of locale es_ES.UTF-8 in LUCA API
- LUCA-2485: Automatically change X-axis to date type when 'Time series' is checked in the category
API 3.3.0 - WEB 1.3.0 (01/04/2022)
Fixes
- LUCA-2512: Charts with one stacked series and another grouped use the same variable for grouping and stacking
- LUCA-2496: Cannot resize a container in dashboards that contains a map
- LUCA-2509: Charts with grouped series do not recalculate maximums and minimums of the axis when hiding a series with the legend
- LUCA-2510: Do not display nulls in the tooltip in grouped or stacked series
- LUCA-2531: The application desktop only brings 25 applications by default
- LUCA-2532: Exporting to Excel converts null fields to "null"
- LUCA-2541: Issue with number formatting in certain browser languages
New Features
- LUCA-2522: Gauge type chart
- LUCA-2511: Ability to sort configuration element tables by creation or editing date
Changes
- LUCA-2463: Reordering input variables is done from their title
- LUCA-2461: Create links (Ctrl + click) in application desktop buttons and 'LUCA Configuration'
- LUCA-2465: Remove 'Combo' and 'Multi-selection' options if a date input variable, current date, or current user is selected
- LUCA-2417: When adding a chart to a dashboard, automatically set the title from the chart's title
- LUCA-2482: Allow reordering rows, columns, and values in pivot tables
- LUCA-2498: Set the opacity of the X-axis grid to 0 by default
- LUCA-2500: Allow reordering the menus and submenus of trees
- LUCA-2441: If editing an element and changes are made before exiting, show a message that changes have not been saved
API 3.2.0 - WEB 1.2.0 (10/03/2022)
Fixes
- LUCA-2516: Dashboard filters adjusted to view do not take a fixed height in Firefox
- LUCA-2507: Do not show application menus if the user does not have permissions and the parameter is activated
- LUCA-2494: Issue with default variables in chart filters
- LUCA-2484: Dynamic table columns do not inherit the range settings established in an output variable correctly
- LUCA-2476: Unchecking the invisible marker option in a series and saving causes it to be marked as visible again
- LUCA-2466: Review numeric formatting when thousand separators are declared
- LUCA-2453: Issue with legends in stacked and grouped charts
- LUCA-2454: Issue with tables in dashboards in Firefox
- LUCA-2515: SQL Server queries do not export to CSV
- LUCA-2514: Check output variable names ignoring case
- LUCA-2475: Cloning a query with linked variables disables the link in the new query
- LUCA-2480: Cannot create a stacked chart with drilldown
New Features
- LUCA-2486: Ability to open query editing from chart editing
- LUCA-2437: Define a numeric format that for a very large number is, for example, 15.6K or 2.2M
- LUCA-2425: Add button to view the usage of an element
Changes
- LUCA-2518: Desktop applications redesign
- LUCA-2451: Unify texts 'No data' and their source in charts and queries
- LUCA-2434: When adding a chart to a dashboard, autocomplete the title with the chart's title
- LUCA-2417: When adding a chart to a dashboard, if it only has one filter, automatically set it in the Filter combo
API 3.1.0 - WEB 1.1.0 (14/02/2022)
Fixes
- LUCA-2470: Input variable validation does not include the indicated minimum value
- LUCA-2469: Menus with very long names in application configuration are cut off
- LUCA-2468: Date pickers start on Sunday instead of Monday
- LUCA-2457: Error obtaining the tables of a schema in SQL Server
- LUCA-2456: Refresh rate does not work correctly in dashboards due to time units
- LUCA-2455: Cannot save a chart created from scratch
- LUCA-2453: Problem with legends in stacked and grouped charts
- LUCA-2452: Error saving when removing a linked variable from an input in dashboard filters and query inputs
- LUCA-2450: Input variables in a dashboard filter are not sorted by position
- LUCA-2449: The combo searcher does not display well in dark mode
- LUCA-2420: Error painting a drilldown of columns coming from a line series as the base series
- LUCA-2402: In tooltips of time series, display the hour
- LUCA-2401: Review very large legends that do not fit
- LUCA-2400: When searching a query on a page other than 1, results are not displayed because the URL does not update to page 1
- LUCA-2398: In dashboards, query containers allow selecting non-select queries
New Features
- LUCA-2424: Ability to configure the width unit of donuts
- LUCA-2422: Ability to choose the width of donuts between a fixed or percentage width
- LUCA-2421: Ability to navigate in the drilldown from the X-axis title
- LUCA-2418: Include the dates being used in the zoom graph of time series
- LUCA-2414: Configuration of labels in series
- LUCA-2413: Configuration of markers in series
- LUCA-2412: Configuration of legends in charts
- LUCA-2409: Ability to create uniform dashboards or display the boxes
- LUCA-553: Export to Excel
Changes
- LUCA-2423: Totalizer text size of the donut should be responsive
- LUCA-2419: When creating series, autocomplete the Name field with the variable name
- LUCA-2415: Scroll up when changing menu options in an application
API 3.0.0 - WEB 1.0.0 (10/01/2022)
- Complete redesign of the LUCA web
- Use of Keycloak for managing LUCA users
- Support for LUCA installation in Docker