69 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.
-
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.
-
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.
-
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.
-
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.
-
Header and static controls - add text formating options
Header and static controls - add text formating options
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.
-
Scheduler Portlet in Connect
Support for the Scheduler Portlet in Novacura Flow Connect
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.
-
Offline Data in Flow Connect
Similar to Flow Classic, Customers will need the ability to download data locally to their devices in Connect and execute on that data. Once connected back to the internet, the information should be sent back to Novacura without user interaction.
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.
-
Allow Alias for datasources
I noticed that the Prefix are not working on the SQL query on the flow
script when I use the module.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.
-
Global / Multiple Phrasebook(s)
Be able to reuse phrasebooks across apps and portlets. Perhaps have them assets similar to Component and Modules today.
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.
-
Using flow properties in the initialization & cleanup commands in Oracle database connector
This will enable the following scenarios that is possible in Flow classic.
- User impersonation via initialization command in Oracle database connector
- Set default language of a user
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?