Sign in

Business Process Complexity Management

New EXECSQL workflow application, PDF file attachment preview, enhancements & performance improvements, Node.js version updates

WorkflowGen version 7.22.0 introduces the new EXECSQL workflow application, which allows you to execute one or multiple SQL queries in a process. For example, you can use EXECSQL to retrieve information via SELECT queries in order to use the results in process conditions; INSERT, UPDATE, DELETE, SCALAR and PROCEDURE queries are also supported. Usage instructions, lists of required and optional parameters, and examples of queries are available in the section of the .

EXECSQL parameters in the Workflow Designer Edit action panel

Enhancements & performance improvements

As of version 7.22.0, the Form Designer attachment tool supports PDF file preview in Advanced Mode. As well, the completeFormAction function used…

Send approval requests to Microsoft Teams from WorkflowGen forms using webhooks and Microsoft Power Automate

Increase organizational efficiency by performing process actions directly in Teams with a WorkflowGen integration

Cloud-based collaboration, communication and productivity software such as Microsoft 365 has become ubiquitous in today’s digital workplace. And with the recent sudden mass adoption of remote work due to the COVID-19 pandemic, countless organizations have embraced these new technologies and learned new ways of working in a short period of time.

More than ever, business process automation is crucial to operational agility. WorkflowGen’s powerful, best-in-class technologies allow seamless integrations with popular collaboration tools and cloud services to increase organizational efficiency in an uncertain economy and ensure business continuity in a rapidly changing market.

This video shows how to create an…

Remote Approval delegation mode support & new OIDC authentication configuration options

WorkflowGen 7.21.0 introduces support for delegation mode in the module. Remote Approval lets users perform request approvals via email, as an alternative to launching the actual form within the WorkflowGen User Portal. It’s an optional route for a regular form approval action in a WorkflowGen process, and is embedded inside the form approval action that asynchronously triggers a notification to the user using the WorkflowGen notification engine. The new support for delegations introduced in version 7.21.0 now allows delegatees to perform approvals by email as well.

Quickly perform approvals by email using WorkflowGen’s Remote Approval feature

OIDC authentication enhancements

The OIDC authentication module has been updated to version 2.3.0 and now…

User Portal, Form Designer & Admin Module enhancements, plus new webhook operations and assembly method

WorkflowGen 7.20.0 features enhancements and performance improvements across the board. In the User Portal, full name searches (first name with last name or vice-versa) are now supported in action follow-up forms. As well, homepage and menu list response times have been improved when displaying request and action lists with data columns in mono-process mode.

New system macros have been added to the Administration Module. The application config path macro returns the physical path to the WorkflowGen web.config file, and the application data path macro returns the physical path of the application data folder. System macros can be used in transition…

New Form Designer server-side code editing mode & default ASPX page async mode

Following the introduction of the in , WorkflowGen 7.19.0 adds a server-side code editing mode to the Form Designer.

Server-side code editing allows form designers to modify the content of a form’s C# runat server tag and JavaScript script tag directly in the generated default.aspx file on the server, using Visual Studio Professional or Visual Studio Code.

Also in the Form Designer, ASPX page async mode is now enabled by default in the generated default.aspx file upon saving the form, which allows asynchronous ASP.NET web form development.

For more information, see the and…

New Form Designer fullscreen JavaScript editor

WorkflowGen 7.18.0 introduces a fullscreen JavaScript editor, available from the Form Designer toolbar.

Form Designer fullscreen JavaScript editor

The fullscreen editor provides a better experience for developers, who can use JavaScript to define client-side functions, events and global variables to handle any specific custom tasks.

Node.js version update

Note that as of WorkflowGen 7.17.2, all of the Node.js modules (GraphQL, webhooks, Auth and SCIM) require . Also in WorkflowGen 7.17.2, the was updated to version 4.1.2 and to version 5.3.1.

Head over to the for all of the details.

At a glance

  • Windows containers can dramatically improve software development and delivery even if they aren’t as agile as their Linux-based counterparts.
  • Dockerizing a web-based solution running on top of Windows Server requires some new skills and development efforts, but the benefits are tangible after each phase of the project.
  • Containers, while providing modern CI/CD pipelines and tooling, give a second life to Windows Server–based technologies leveraging a mature ecosystem, which for some clients translates to integration cost reductions and reusing existing team skills.

The monolith

WorkflowGen is a web-based solution with server-side services running on Windows Server (IIS) with built-in C# for the .NET…

New GraphQL & webhooks operations, OIDC authentication features, Administration Module enhancements, performance improvements

WorkflowGen 7.17.0 includes many new features, enhancements and version updates across the board, along with directory synchronization and database performance improvements.

and now include mutations, queries and operations to create, update and delete process participants, global participants and global lists.

The webhooks API now supports new endpoints based on the for operation definition and execution. This allows for seamless integrations with other OpenAPI-ready solutions such as Swagger, Microsoft Flow, Azure Logic Apps and Postman. Information on how to use the OpenAPI v2 endpoints is available in the .

Import operation definitions from the new incoming webhooks OpenAPI v2 endpoint

WorkflowGen handles high request volumes and back-office integrations

is a graduate medical school in Singapore. This collaboration between Duke University in the United States and the National University of Singapore was set up in 2005.

In 2018, Duke-NUS embarked on a project to select a suitable workflow tool to automate some of its time-consuming administrative processes; these included physical applications for childcare and parental leave. The tool needed to cope with potentially high volumes of forms together with integrations to back-office systems for authentication and record-keeping. ​ After a period of in-depth testing, the school selected process automation solution from Advantys, based in Canada…

Docker containers, MIP v2.0 authentication, UI enhancements, performance improvements & version updates

WorkflowGen 7.16.0 introduces support for . These enable modern CI-CD pipeline integrations and automated deployments, with industrial-grade production, test and development environments. Since WorkflowGen containers are more portable and efficient in terms of resource consumption, they allow the seamless deployment of more than one WorkflowGen instance on a single server. Comprehensive documentation is available in the guide.

Version 7.16.0 also now features authentication, alongside the other OIDC-compliant methods (Azure, AD FS 2016, Auth0 and Okta) introduced in recent versions of WorkflowGen. MIP v2.0 …


Business Process Complexity Management

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store