Valentina Release 17.5.3 adds advanced reporting for MongoDB, new reports projects for Xojo

Valentina Release 17.5.3 Adds Reporting for MongoDB, New Reports Projects for Xojo

Also improved JavaScript support for ValentinaDB, a new reports property, and improvements to Studio SQL Editor and Data Editor

Valentina Studio

Valentina Studio is the free, all purpose database management tool suite. Valentina Studio PRO adds more powerful diagramming features, more powerful visual builder tools for databases, forms creation, reports designer and more. Improvements include:

  • [New][Data Editor] Added Sort Ascending, Sort Descending, and Clear Sorting actions to the column context menu. The context menu indicates the active sorting direction.
  • [New][Report Editor] Added the evaluation_time property to Bar Code, Chart, Ellipse, HTML, Label, Line, Picture, Rectangle, and Shape controls. Use this property when a control must be evaluated after its normal placement time. For example, to display the number of items in a group within the group header, set evaluation_time to Group. If a control depends on a summary that is calculated after the control would normally be placed, set evaluation_time to Region or Report, depending on the required scope.
  • [Imp][Data Editor] Renamed Find Column to Go to Column in menus, tooltips, and the shortcut reference.
  • [Imp][SQL Editor] Improved static analysis and identifier resolution for UNION, UNION DISTINCT, and EXCEPT queries.
  • [Fix][Query Editor] Fixed the scene background refresh when the diagram becomes empty or non-empty, so the hint about placing controls on the diagram is shown correctly.
  • [Fix][Report Editor][MongoDB] New MongoDB report queries now show MongoDB Command instead of SQL as the query type.
  • [Fix][Data Editor][Parquet] Fixed viewing BLOB field data.

Valentina Reports

Valentina Reports ADKs allow developers to embed reporting into their applications. ADKs are available for many native development systems including C/C++, Java, .NET, Swift, Xojo and many more on Windows, macOS & Linux. Valentina Reports Server is a part of Valentina Server. Improvements include:

  • [New][MongoDB] Added support for complex MongoDB reports with grouping, sorting, and SQL expressions.
  • [Imp] Count summaries now use the configured value formatting.
  • [Imp][ODBC] Added support for reading BLOB fields.
  • [Fix][MongoDB] Fixed the preservation of binary values during report processing and sorting.
  • [Fix][MongoDB] Fixed integer query parameter substitution in JSON queries.
  • [Fix][ODBC] Fixed identifier quoting.
  • [Fix][DuckDB] Fixed displaying pictures stored in BLOB fields.

Valentina for Xojo

The Xojo development environment supports multiple compile targets, including macOS, Windows, Linux, iOS and more. Valentina Database and Reports ADKs are available for Xojo as standalone solutions for developers, and include a free CLIENT component for native integration with Valentina Server. Improvements include:

  • [New][Examples] Added a set of self-contained VReport examples that use the same report layout with different datasources. Each example includes a Xojo project, a report project, the required sample data or setup files, and a README explaining how to run the example and, when required, how to set up its datasource.
    • SQL Example(s). ValentinaDB, SQLite, MySQL, PostgreSQL, MSSQL, DuckDB, ODBC, and Parquet examples demonstrate parameterized reports with different SQL datasources. The ODBC example shows how to use MySQL through a configured DSN. The Parquet example exposes files in a folder as tables and joins them using SQL.
    • NoSQL Example. The MongoDB example uses an aggregation pipeline with $lookup stages to join collections, passes a typed query parameter, and reads BSON Binary icons.
    • JSON Example. Demonstrates passing flattened JSON records directly to MakeNewReportFromData, without a database or datasource string.
    • Scripting Example(s). JavaScript and Python examples request nested data from HTTP APIs, transform it into flat report records, and generate a report without a database datasource.

ValentinaDB

ValentinaDB is Paradigma Software advanced, object relational database and available in ValentinaDB Server (a part of Valentina Server) and ValentinaDB ADKs (developer components for adding runtime database support to applications). Improvements include:

  • [Imp][JavaScript][macOS] Enabled the fetch function in the JavaScript extension.
    • This allows JavaScript used in Forms, Reports, and scripts to retrieve data from HTTP/REST services.
  • [Fix][JavaScript] Fixed fetch HTTP response handling.
    • Response.status, Response.statusText, and Response.ok now reflect the HTTP response correctly, while transport failures are reported as errors.

This release is now available on the Paradigma Software download site. See the original announcement in the Paradigma Software forum.