1. Lynn Fredricks
  2. Announcements & News
  3. Понедельник, Ноябрь 27 2023, 07:34 PM
  4.  Подписаться через email
Studio improved SQL & Schema Editors, SQLite support and more.

Valentina Reports ADK & Valentina Reports Server
Valentina Reports cross platform reports system is available in Valentina Reports Server, Valentina Reports ADK for embedding a reporting system into applications and Valentina Studio as a reports authoring, testing and deployment platform.

  • [New] – PYTHON added (!) Valentina Reports, additionally to JavaScript and SQL. Use to write source queries and expressions for reports.
  • [New] – Allow to use Python list of dictionaries as source cursor.

Valentina Studio FREE | Single | PRO
Valentina Studio is the free, all purpose database management and forms client tool. Valentina Studio Pro combines database management with diagramming, forms creation, reporting and database continuous integration. Available on Windows, Linux and macOS.

  • [Imp][SQL Editor] – Enable ‘Execute Current’ even for single statement.
  • [Imp][SQL Editor] – Restore selection after ‘Execute Current’.
  • [Imp][SQL Editor] – Disable auto repeat for ‘Execute’ actions.
  • [Imp][Schema Editor] – Add ‘Refresh’ action to ‘schema lists’ menu.
  • [Imp][Schema Editor] – Update current list (in the tree mode) on refresh of TAB-panel
  • [Imp][Schema Editor] – Added ‘Generate Docs’ action in the contextual menu of Database object to all supported databases (MSSQL, MYSQL, PostgreSQL, SQLite). [Note] – for ValentinaDB it was added in the 13.5.3 build.
  • [Imp][Project] – Don’t run start script on restoring state at app start.
  • [Imp][MONGODB PLUGIN] – Restore tabs with collection/view editors
  • [Fix] Database view keyboard cell focus using scroll wheel on mouseover other view
  • [Fix]Document display if added to empty MongoDB collection in Column mode
  • [Fix] Server Admin, popup error message

Valentina Kernel
Valentina Kernel is the underlying architecture of Valentina products meaning, all products that utilize the kernel inherit any changes and improvements.

  • [Imp][SQLite] Allow to use URI on create/open SQLite databases, for SQLite engine inside of VKERNEL.DLL

Linux
ValentinaDB ADK, Valentina Reports ADKs, Valentina Studio (all versions) and Valentina Server are all available for Linux.

  • Libssh2 updated on Linux to 1.11

This release is immediately available for download from the Paradigma Software website.
Ссылки
  1. https://www.valentina-db.net/2023/11/28/valentina-release-13-6-adds-python-queries-expressions-to-reports-improves-mongodb-support/
  2. https://valentina-db.com/docs/dokuwiki/v13/doku.php?id=valentina:releases:13.0:13.6
  3. https://valentina-db.com/docs/dokuwiki/v13/doku.php?id=valentina:products:vstudio:help:dialogs:create_query#python
  4. https://www.indiehackers.com/product/valentina-studio-pro/valentina-release-13-6-adds-python-queries-expressions-to-reports-improves-mongodb-support--NlESSRopTKQhEkpOQsZ
Комментарий
There are no comments made yet.
Steve Wilson Ответ принят
Are all modules from the Python standard library available for writing source expressions?

Can the Python lists be hierarchical for grouping data on the report?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Steve,

Are all modules from the Python standard library available for writing source expressions?

Not all modules are included. Which modules do you think would be useful?
Additionally, there will be an ability to add custom modules.

Can the Python lists be hierarchical for grouping data on the report?

For example, lists with nested dictionaries, right?
While in Python, this is not possible yet, in JavaScript, we can output hierarchical data using subreports.
Комментарий
There are no comments made yet.
Steve Wilson Ответ принят
For example, lists with nested dictionaries, right?

Correct.

in JavaScript, we can output hierarchical data using subreports.

Is it possible to use a JSON file as a report datasource? As I recall Valentina Studio Free already has a command line interface for generating reports so the ability to pass in a *.JSON file as the datasource and a *.pdf file as the output would be very handy :)
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Is it possible to use a JSON file as a report datasource?

Not right now but we thought about this functionality.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Steve,

In version 13.7, it is possible to load JSON files (local or from an HTTP server) using JavaScript-based queries.

1. Start creating a new query. It is necessary to select any datasource for now
2. Select JavaScript as a language
3. Use fetchSynced, e.g.:

fetchSynced('file:///path/to/products.json').jsonSynced().products


Also, you can transform data from file to format suitable for reports

[ { "f1":"row1 value1", "f2":"row1 value2" }, { "f1":"row2 value1", "f2":"row2 value2" } ]
Вложения
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories