May 6, 2024
We are excited to announce the release of B2Win Suite Version 5.4
Here’s a detailed overview of what’s new:
Bug fixes, usability and performance improvements
More Scripting Does Not Mean Less Visual!
More SQL-Scripting (low-code) capabilities were added to our point-and-click (no-code) VisualQuery
We’ve integrated more scripting capabilities into VisualQuery’s intuitive point-and-click interface, benefiting business users and SQL programmers. This enhancement empowers them to collaborate effortlessly within a unified environment to address the company’s business needs:
New “Views” feature, based on SQL scripting
Users can now construct more robust SQL models through “Views” and create tables that represent a subset of the database derived from queries that operate on one or more database tables. In otherworlds or custom tables. This new feature empowers users to create “Views” or custom tables that represent a subset of the database derived from queries that operate on one or more are derived for using custom SQL scripting and incorporate them as custom tables. These custom tables can then be effectively joined with other tables, allowing users to develop advanced SQL models tailored to their needs.
Views represent a subset of the database derived from queries that operate on one or more database tables.
More SQL Scripting in “Conditions”
Users can now use free SQL scripts in Conditions alongside the existing point-and-click user interface.
More SQL Scripting in “Virtual Fields”
We have added the capability to use free SQL Script with Virtual Fields for greater flexibility and robustness. The user can now choose the type of formula that better fits their project.
Support for Plugins
Services and nodes are now independently managed, simplifying integration and administration. Admins can now easily add or remove services/nodes without server restarts, ensuring continuous availability and system uptime for all users.
Full support for “B2Win Suite Client” has been added to B2Data
This powerful capability that already exists in B2Output is now available in B2Data.
This feature adds new and creative capabilities to the workflow process.
For example, users can configure workflow to connect to their local machine and use their personal MS Outlook to send emails for even more personal ways to interact with customers, schedule a print job for a weekly report right next to them on a printer connected to their local machine… possibilities are endless.
Joiner Node - New Update
Support for joining multiple tables has been added
NEW NODES:
File Copy (B2WS Client)
Empower users to transfer files to their local machines effortlessly. Admins gain the capability to distribute files to other users’ local systems with ease.
Print (B2WS Client)
Streamline the printing process for users by enabling direct printing of reports and files, including MS Excel and PDF documents, to printers connected to their local machines.
Send Email (B2WS Client)
Enhance email communication efficiency with the ability to send emails using the locally installed email client. Users can bypass the server’s SMTP and leverage their local machine’s email capabilities.
QueryTrigger
Activate queries triggered by data changes, empowering users with real-time responsiveness to dynamic data environments.
ScriptTrigger
Trigger workflow based on the value evaluated from your script.
Columns Renamer
This node provides a quick way to rename field codes and descriptions for nodes with Data Frame output. It is handy for tasks like matching and synchronizing tables with target databases.
PowerBI Uploader
Easily upload datasets to PowerBI.
Qlik Uploader
Easily upload datasets to Qlik Sense.
Custom Script (File)
This node allows you to write custom scripts with “file” output.
Custom Script (Object)
Enhance your workflow with the capability to write custom scripts with “Object” output, including formats like XML or JSON, using this node.
File Read (Windows Share)
Access and read files from a Windows Share or Samba network.
File Copy (Windows Share)
Copy files to a Windows Share or Samba network.
File Listener (Windows Share)
Listen to files on a Windows Share or Samba network.
MORE CHANGES:
- Delete synced data for db connection
- Support properties in excel templates for excel merger
- Ability for zoom to for input form fields with multiple selection
- Having list of fixed values for input form fields
- Disk usage for workflows
- Bug fixes, usability and performance improvements
