86 results found
-
Parameterized IN Syntax for SQL Statements
Change Improvement Request: Support Parameterized IN Syntax for SQL Statements
Title
Support parameterized IN clause syntax to avoid dynamic SQL executionBackground / Current Behavior
Currently, when building SQL queries that require filtering using an IN clause with multiple values, the only practical solution is to dynamically construct the SQL string and execute it using EXEC(@query).
Example:
DECLARE @query NVARCHAR(MAX)
SET @query = '
SELECT *
FROM Orders
WHERE OrderId IN (' + @OrderIds + ')
'EXEC(@query)
This approach requires stringifying the entire query, which introduces several issues:
Reduced readability and maintainability
Increased risk of SQL injection if not…
9 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
NiceLabel Connector for Connect
Utilize the old connector for integration with Nicelabel. Currently the workaround is to use the REST connector or FileSystem connector to communicate but it could require an automation server or additional set up to consume messages in the file system directory.
14 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Import portal 2 translations
Ability to import translations from portal 2 into portal connect.
16 votesWe are pleased to announce that the requested feature has been achieved via a workaround available to all users. The workaround is described at the end of the Flow Script training (https://appcademy.novacura.com/ - free sign up) under the "Migrate Portal 2 translations" chapter.
-
Registration landing page - option for Portal access button
To enhance user experience after registration and acceptance of the invitation to Connect, it's essential to streamline access to all necessary features. Currently, users can see buttons for accessing the Client and links to the apps, but adding a dedicated Portal button would significantly improve navigation.
This addition would provide a clear and straightforward option for customers to access the Portal page directly, reducing confusion and enhancing usability. By implementing this change, we can ensure that users have a seamless experience, making it easier for them to find and utilize all available resources.
Let's prioritize this feedback and work towards…
3 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Infor M3 Connector (Socket)
In Flow Classic, we have two connectors associated with M3. One is the REST based connector, the other is connector to older versions of Infor M3. In Flow Connect, we would like the same capabilities from Classic. Currently, only REST based connectors for Infor M3 are available.
16 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Possibility to have action buttoms in more than one row
Today all action bottoms are shown in row like a bar. It should be possible to configure to have it as multiple lines. This will make a much better UX.
10 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Hide/remove Assertion Step label from display in application runtime.
We want to change how Assertion Steps are displayed to the user who runs the app. It is annoying and impractical that the label of the Assertion Step is shown to the user. Better to only show the phrase, as it worked in Classic. It is confusing and language-mixing for the user to see the label of the Assertion step. (See enclosed files).
For me, this should be permanently changed or at least make it an option to hide the Designer label of the Assertion Step from the user who runs the app in the client. Our clients use assertion…
4 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. It has been verified in these versions:
Web version: 1.0.495.0
Windows version: 1.0.507
iOS app version: 1.0.503
Android app version: 1.0.461
-
Generic Database connector with ODBC
A generic database connector that can connect to any database for which an ODBC driver is available
Databases that we can Connect to via ODBC
IBM Db2 (all variants)
MySQL / MariaDB (MySQL Connector/ODBC, MariaDB Connector/ODBC)
PostgreSQL (psqlODBC driver)
SQLite (SQLite ODBC driver)
SAP HANA (SAP HANA ODBC driver)13 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Magic wand in the query configurator for the IFS/SQL server
Can we have the magic wand back that we had in Flow Classic, that autogenerates element names?
3 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
FTP Connector in Connect
To be able to communicate with FTP servers in Flow Connect. The FTP Connector can be used to upload and download files from an FTP server. It can also perform other operations such as creating remote directories and list files and directories on the FTP server
9 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Direct Client-to-External System calls via OpenID Connect
Enable connect Apps built on Novacura Flow Connect to communicate directly to external systems (e.g., IFS Cloud or other REST-based services) when the external system supports OpenID Connect (OIDC) for client authentication.
This will allow secure, client-only communication, reducing dependency on the Flow Connect Cloud for certain REST API calls and improving performance by eliminating unnecessary round trips through the cloud.Business Value
Performance: Reduce latency by avoiding cloud roundtrip.Scalability: Offload traffic from the Flow Connect cloud.
Security: Leverage OpenID Connect’s standardized authentication and token handling.
Scope
Applicable only for Mobile & windows clients (assuming it will not work…6 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it. Please see product documentation for this feature here.
-
Portal Page Navigator
As a developer, I want to be able to edit my portal page navigation and deploy that navigation across environments in Flow Connect (Dev, Test, Prod). This should take into account access restrictions from End User Groups.
5 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Diagnostic Mode in TEST and PROD Environments
As a customer there are small changes between TEST and PROD environments. It would be nice to be able to run diagnostic mode against a TEST environment and see the errors that one might get there with variables.
14 votesWe are pleased to announce that the requested feature has been fully developed and will be available to all users very soon. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Support multiple lines in inbox view
As a user/technician, I want the inbox to support multiple lines so I can quickly check task details like priority, address, and phone number without opening each task, allowing me to select the right one efficiently.
5 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
AD Sync (SCIM) for Flow Connect
System for Cross-domain Identity Management (SCIM) is a set of application-level protocols that use JSON, REST, and several different authentication methods to automate the task of user provisioning. This will allow Admins to configure Azure to create, update, and delete users seamlessly from Azure AD to Novacura Flow Connect without the need of manually doing this within the Hub.
15 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Remove paginator - option
The table portlet is sometimes used when you know there will always be X or fewer rows (e.g., 5 rows, one for each workday). Then the paginator is abundant and occupies dead space.
To have an option to always hide it, or hide it if there are less rows than the amout of rows I have set the table protlet to show on each page.4 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
OPC UA connector in Connect
he OPC UA connector allows Flow Connect apps to communicate with OPC UA servers
3 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
FlowScript Copilot for IFS OData Queries with Modules
In Flow Connect, a user should be able to prompt in a Script step using natural langauge to automatically generate FlowScript. For example, a user should be able to type into a Copilot - "Get me a list of customers from IFS Cloud where customer region is equal to North America" and the copilot should write script to open CustomerOrderHandling select CustomerId, Name from CustomerInfoSet where Country = NA.
4 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
-
Time limit increase in scheduled Automations
I've notised while I was running a scheduled automation, it always stops after 10 minutes of running.
This specific app would run for hours (and I would use other scheduled automations for those workflows that take long time to run (e.g.: refresh basic data in a DB)), and since it takes more than a few minutes, I would run it outside of working hours - usually nights -, similarly to IFS background jobs, but it stops after 10 minutes.Is it possible to increase this 10 minutes limit or add an option (per organisation) to be able to change it…
2 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
Time limit for Scheduled Automations has been increased to 30 minutes. Change log | Flow Connect Help
-
SFTP Connector in Connect
To be able to communicate with SFTP servers in Flow Connect. The FTP Connector can be used to upload and download files from an SFTP server. It can also perform other operations such as creating remote directories and list files and directories on the SFTP server
11 votesWe are pleased to announce that the requested feature has been fully developed and is now available to all users. Our product team has tested the feature and ensured that it meets the requirements and specifications. We hope you enjoy using it.
- Don't see your idea?