Skip to main content

Recently active topics

93 Topics
J
Sidekick
JhengSidekick
asked in Questions & Conversations
How can I display a dropdown list for a field that's defined as an expression

Hallo, I have a module in my web portal under that allows adding, editing, and deleting data. In this model, I'm working with two fields: Company and Liners. Both values are derived from the same table called Company. To differentiate them, I created expressions where: company_name includes companies starting with "NL" liners includes companies starting with "L" My goal is to display these as two separate dropdown lists—one for Company and one for Liners—even though the data comes from the same table. I initially tried using a company_id lookup from the Company table, but that displays all records, which isn't what I need. So my question is: Is using expressions the correct approach for filtering the dropdown values? If not, what is the best practice for achieving separate dropdowns for Company and Liners from the same table based on different filter conditions? Below is the webportal page and the current data model table. web portal data model

5312
J
Sidekick
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
Merge indexesOpen

The Software Factory has a validation which informs you of indexes that are equal to one another and should be merged into a single index. Personally, I think having this validation is nice, but if you can inform me about this issue, why not resolve it for me. It would be great to have a way to automatically merge these indexes. I need a way to merge index together to help me save a chunk of time. Perhaps create an enrichment for this?

3
412
Robert Jan de Nie
Thinkwise blogger
Mark Jongeling
Administrator
Mark JongelingAdministrator
🚀 Platform improvements for week 28hotfix

Hi everyone! We’ve released the following platform improvements this week: IAM & SF 2025.1, 2024.3, 2024.2, 2024.1 20250709 - Always grant rights to public role for datatypes Since 2024.1, Public rights for database objects can be revoked for the entire branch. This was also done for IAM to distribute it without Public rights. Due to an oversight, domains (user-defined datatypes) also did not receive Public rights, which meant no role had rights to these created domains. This led to issues in the 2-tier architecture, where the Windows GUI performs the database operations using your account rights, such as writing back user preferences or even logging into the application. This has been fixed for IAM, as well as new user-defined datatypes (domains) defined in the Software Factory, always granting rights to the Public role from now on.

110
Mark Jongeling
Administrator
P
Captain
PeterKeerisCaptain
Double click grid to editNew

I would like the option in the SF to set a subject to grid edit mode if a users double clicks on a row (optional: clicking on a specific column like with tasks). I know this can be done already with creating a double click task that uses a proces flow to go to grid edit mode. But it gets quite cumbersome when you want to implement this at almost all subjects that use edit in grid in an application, specially in combination with roles.

2
30
P
Captain
L
Apprentice
luukschoutenApprentice
asked in Questions & Conversations
IAM role sets

IAM includes a task to clean up unused role sets.I've noticed in several projects that this feature is not well known, and the documentation is also quite limited. However, in some cases, cleaning up unused role sets significantly improves end-user login performance. Is there a specific reason why unused role sets are retained?If not, my suggestion would be to automatically remove a role set once it is no longer applicable.

60
L
Apprentice
L
Apprentice
luukschoutenApprentice
Handler output parametersNew

Handler procedures are not only called from the GUI but can also be invoked through other SQL code.For example, creating a sales order can be initiated by a user via the GUI or triggered by a received EDI message. Currently, handlers include output parameters for identity values. This allows the identity—when it serves as the primary key—to be reused, for instance, to create the corresponding sales order lines. However, there are also models where the primary key is not set as an identity. This can occur, for example, in data models with a company structure, where the primary key is a sequential number within the context of the company. In such cases, it would also be desirable to make the primary key generated in the handler, and potentially other columns as well, available as output parameters. A possible solution is to allow, per column in the model, the specification that it is an output parameter—similar to how defaults, layout, and context procedures are configured. By default, t

7
130
L
Apprentice
N
Community Manager
NathanCommunity Manager
published in News & Blogs
Tutorial 101: Hello TestwiseTutorial

Disclaimers: While a Record & Playback approach is a great way to start from having no automated tests, it does have a couple of disadvantages, some of which can be mitigated by replacing recorded steps with Testwise-provided reusable logic and helpers. Some of below steps are going to change when we automate steps that are currently being performed manually Depending on the versions you install; steps might differ Prerequisites: Install Visual Studio Code on Windows Install Node.js — Run JavaScript Everywhere In your File explorer, create a folder on your local device → this will be your test project name ​ Go into the folder, select the navigation, replace with cmd and hit Enter ​ This will open up your terminal in the right folder. Type code . and hit Enter. This will open up Visual Studio Code. In there press Ctrl + ~ which will open up the Terminal within Visual Studio Code, already pointing to your Test project folder: ​ Setup project dependencies: Run the following command to cr

570
N
Community Manager
N
Community Manager
NathanCommunity Manager
published in News & Blogs
Introducing Testwise: A Playwright support library for the Thinkwise PlatformBlog

As a QA team within our Product Innovation department, we understand the need for efficient, reliable ways to test applications that are built to last forever. Quality is an essential pillar of our brand promise; we want you to trust our technology and enable you to develop your functionality 10X faster. See this old blog for some background reading on our role: We place a strong emphasis on end-to-end, user-focused testing—a shift-right approach—because it provides the level of confidence that we need to say we're delivering a quality product. For a system as complex as ours, investing in test automation is essential. It allows us to rely on consistent, repeatable checks, so that any manual testing efforts can be focused on where they’re most valuable: ensuring that new features and ongoing development meet our quality standards. Since we are shipping a low-code Platform -with which all of you build amazing Applications-quality is a shared responsibility. Both the quality of the Platf

570
N
Community Manager
A
Captain
André RomijnCaptain
asked in Questions & Conversations
Styling of custom components in Light and Dark mode

Hi everyone, In our application (using Universal GUI), we have some custom components. We experience some problems when we want to style the custom components depending on choosen mode (dark / light) in the user preferences by the user. The custom component is presented in an <iframe> in the browser, however, within the <iframe> the css class ‘dark’ is not applied, causing the custom components not to be adjusted to the selected mode (dark/light). This makes UI/UX of application not as good as we want to. Any ideas how to solve this?

1165
Jeroen van den Belt
Administrator
C. Lousberg
Captain
C. LousbergCaptain
Handle translations Case SensitiveOn the backlog

The SF/IAM databases are Case insensitve (Latin1_General_CI_AS) by default. As we sometimes make some mistakes (who doesn't), we'd like to correct the cases in translations. E.g. cange “Purchase order” to “Purchase Order”. Currently there are 2 workarounds: update the records in transl table or, change to “Purchase Order1”, sync to all IAM's and change to correct “Purchase Order” The idea we'd like to see implemented is that a collate Latin1_General_CS_AS compare takes place and also the update will take place in this collation so the correct cases will be stored.

21
963
B
Warrior
P
Captain
PeterKeerisCaptain
Drag & Drop handle on right side (Universal)Open

When drag & drop is enabled on the Universal GUI, a handle icon is added on the left side of the grid for every row. Please make it possible for a developer to determine on which side of the grid this handle is displayed. When the dropping is done on a detail on the right side, it is more convenient for the user only having to drag the row over a small part of the screen. Of course when the handle is displayed on the right side, it should still be a locked column so it doesn’t disappear when not scrolled to the right.

2
393
P
Captain
L
Rookie
Ling WuRookie
asked in Questions & Conversations
Users cannot save cube views in Windows GUI

We are using the Windows GUI (2 tier). Recently users reported a problem that they cannot save their own created or changed cube views. Users can make the changes and save their cube views with no errors or messages showing, but afterwards the change has not been applied or saved to the IAM database (MS SQL server). As a admin user myself i can save the cube views with no problems as i have more rights on the database itself. We also recently upgraded our environment from 2023.1 to 2025.1. I suspect this has to do with the change in cube view preferences where cube views are split into cube views and cube view classic preferences. Also a change has been done in the upgrade where public rights have been revoked and assigned to specific roles. Our users have the end_user role. I have checked execute rights have been granted on below procedures and the task_delete_usr_pref_classic_cube_view. This is the case. Also the rights on the underlying tabels i have set to inserted, update, delete

455
Mark Jongeling
Administrator
Mark Leunissen
Captain
Mark LeunissenCaptain
asked in Questions & Conversations
Uploading multiple files via drag and drop - Universal

Hi, I have been using the topic: Upload multiple files using the Universal GUI for drag and dropping files in my test environment. The test environment is hosted on Azure and uploaded the files to an azure storage. However, the Production environment is hosted on premise, therefore I wanted to test the drag and drop functionality on the acceptance environment (also hosted on premise). However, I can't get the drag and drop to work. I have changed the URL in the html to the right url. The HTML file is saved on the universal folder, same as the test environment. However, I just keep seeing the 'no preview available’. The file name column has a file upload control type to a file system storage location. Uploading and opening the files from the local storage works. Kind regards, Mark

483
Mark Leunissen
Captain
Arie V
Community Manager
Arie VCommunity Manager
Determine if next Process Action should be executed immediatelyPlanned

Process Actions in the Universal GUI related to navigating through screens don't perform too well. A user can navigate faster through the GUI manually. One of the reasons for this are the many HTTP calls that are triggered after a Process Action is executed. A bit similar to the concept of Refresh after Execute for Tasks, it would help if there is a setting available for each Process Action in which it can be determined whether or not to immediately perform the next Process Action. An example: A Process Flow that performs Open Document > Change Filter > Go to Row should only retrieve the Data after the required (set of) Row(s) is determined with the Go to Row Process Action. ​​​​​​​Can something like this be added to the Platform soon?

54
36510
R
Vanguard
B
Warrior
BramGWarrior
Enable snapshot (materialized/indexed views) for MssqlOpen

We wanted to create a snapshot (materialized/indexed view) in the SF to make it easier to display information such as stock aggregations, but we can't get it to work. We can see multiple users having problems with this: Snapshot creation SQL SERVER | Thinkwise Community It seems this is not yet enabled for Mssql. Can this be realized? What are 'Snapshot' views and how to use them? | Thinkwise Community

6
281
Jeroen van den Belt
Administrator
H
Vanguard
Henk-Jan van LaarVanguard
Control detail tiles openingOpen

I would like to have more control over the way details open, specifically from a detail tile. I would like it to open as a floating screen for instance. Having the screen been modal (thus preventing the user from navigating away) would also be a great feature to have. In my case the users have a touchscreen interface so using the ‘alt’+click shortcut is not an option and is also not something I want to make the responsibility of the user. So far I’ve got two workarounds but neither are very elegant: Using ‘empty’ tasks instead of detail tiles and having them open the detail in a process flow, but this leads to clutter in the tasks and makes adding tiles a hassle, also it defeats the purpose of the tiles and leads to a disconnect in the styling of the icons for instance using a process flow to close the initial window and reopen it as a floating window, this is sluggish and also unnecessarily complex I would prefer to be able to do this in a simpler and faster manner, so far the followi

14
1033
Freddy
G
Rookie
Guido Bijl 2Rookie
asked in Questions & Conversations
Process flow task loop universal 5 sucessfull executes means 5 times to cancel

Hi, We have a very basic, simple flow. In Windows GUI there is no problem, but in Universal GUI 2025.1.15.0.0, if i run the task succesfull 4 times i need to hit cancel 4 times, if i run it succesfull 6 times i need to hit cancel 6 times, and so on. Am I missing something obvious? is it a bug? You are meant to enter a palletnumber and click execute, and continue entering palletnumbers until you cancel the task.

274
Anne Buit
Community Manager
S
Rookie
Stijn SchuurmanRookie
asked in Questions & Conversations
Universal GUI Editable Grid Performance

Universal GUI Editable Grid Performance Issues Installed software: Software Version Universal GUI 2025.1.14.0 Indicium 2025.1.14.0 Problem Statement The Universal GUI seems to be less performant in various cases, when compared to the same functionality in (older) WebGUI / WindowsGUI. Specifically, the editable grid has significant performance implications, which makes the user interface unreliable. Upon pressing the downward arrow-key 3 times in succession in the editable grid. The UGUI registers only 2 button presses. The problem is not necessarily the delay, it is the discarding user-inputs that makes the UGUI unreliable in use. Possible Causes Universal GUI version: we are on the latest version. Indicium version: we are on the latest version. Resource capacity: we host UGUI & Indicium on a server dedicated to this environment. Data quantity: this test was performed on an editable grid with 6 columns and 7 rows, without expression fields, nor triggers. This list does not spark a poss

1035
Arie V
Community Manager
A
Captain
André RomijnCaptain
asked in Questions & Conversations
Update Azure file storage secret using IAM Indicium API

Hi community, We are running multiple tenants (application per tenant) in Azure with a file storage in an Azure Blob container. We have enabled the ‘Encryption used’ option. We are facing a problem that the client secret expires every 6 months and has to be reset using the ‘Set file storage key values (encrypted)’ (see the attached image) Any idea how we can update the encrypted client secret using the Indicium API of IAM? We are trying to automate the maintenance ;-)

120
A
Captain
J
Sidekick
JhengSidekick
asked in Questions & Conversations
How to avoid duplicate entry or make column unique

Hello I have below Supplier data model How can i prevent entering a duplicate value? In the portal, it is designed to add, edit delete but it allows to enter duplicate data I'm not sure how unique constraint works here but I added an Indexes unique constraint but it doesn't work. Please advice Below is the values on index column, unique is also ticked Thanks in advance

242
J
Sidekick
R
Hero
RolandHero
asked in Questions & Conversations
Docker bad gateway

What could be causing a bad gateway message with an Indicium docker container? I've already verified that all containers (including traefik) are on the same Docker network (the default network made by docker compose). This is the line from the traefik log: 502 Bad Gateway error="dial tcp 172.18.0.6:8080: connect: connection refused" According to “docker network inspect” 172.18.0.6 is the correct internal IP address for the Indicium container. This weirdly doesn't happen with the Universal container as it serves the login page just fine. Each container uses its own subdomain as the external host. This is my docker-compose.yaml: ---services: proxy: image: traefik restart: unless-stopped ports: - 80:80 command: - "--providers.docker=true" - "--providers.docker.exposedbydefault=false" - "--entrypoints.web.address=:80" - "--accesslog=true" - "--log.level=DEBUG" - "--log.filePath=/logs/traefik.log" volumes: - "/var/run/docker.sock:/var/run/docker.sock" - ./logs/:/logs/ universal_prod: image:

297
L
Moderator
SanderAdam
Warrior
SanderAdamWarrior
asked in Questions & Conversations
Dark mode for custom components in cooperation with the final TW application

Hello everyone, In our application we have a few custom components. Those custom components are integrated well. But there is one point where the integration of these components doesn't work as well: on the topic of the themes (dark mode and light mode). We now have to manually toggle the components to match the theme of the software, which is weird, why would the user need to toggle a component from light to dark mode or from dark to light mode when the software should do that automatically? Is there a way to know in what mode the software is? It would help to automatically switch the theme to the theme the application is already on, otherwise the overly bright component is highly distracting. So in short: is there a way to know whether the software is in dark or light mode, so we can change the components accordingly?

141
Anne Buit
Community Manager
A
Captain
Andre te RaaCaptain
asked in Questions & Conversations
What replaces TSFReportMailer in Universal?

Users are used to open an email in Outlook, so they can check it or add another attachment, before they send it. In Windows we use the TSFReportMailer for this. Will the same functionality also be available in Universal?

361
Arie V
Community Manager
M
Superhero
Mark_PlaggenborgSuperhero
Bring the Filter Expression to the Universal GUINext release

Idea as follow up from the question: An advanced feature that was available in the older GUI’s, that could help filter situation that “Filter Form”, “Combined filter” or “Grid Column Filter” could not achieve. Pressing the little arrow down made it available Possible to filter several conditions like a Boolean function Able to also input it as a text (which you could use to recreate the filter as it never got a feature to save these).

6
736
Arie V
Community Manager
P
Captain
PeterKeerisCaptain
UGUI: Open menu item/open document in new browser window/tabOpen

As a user of a Thinkwise application I want to be able to open a menu item or an open documents item in a new browser tab or window so that I can use the application on multiple monitors and compare objects in the application side by side. It is already possible to open a new browser tab, open the application and open a menu item. But I want it to be more convenient by using my open application as a starting point. For example by pressing the right mouse button on the menu item or open document and using the context menu as a normal website:

2
161
Jeroen van den Belt
Administrator

Badges

Show all badges
Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings