Join the Thinkwise Community | Thinkwise Community

Recently active
Help others
Categories

JhengSidekick

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

5212

16 hours ago

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?

412

18 hours ago

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.120250709 - 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

18 hours ago

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.

18 hours ago

luukschoutenApprentice

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.

20 hours ago

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, this

130

20 hours ago

NathanCommunity Manager

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

530

21 hours ago

NathanCommunity Manager

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 Platfor

530

21 hours ago

André RomijnCaptain

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

1 day ago

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.

953

1 day ago

JhengSidekick

Questions & Conversations

How can I display a dropdown list for a field that's defined as an expression

5212

16 hours ago

luukschoutenApprentice

Questions & Conversations

IAM role sets

20 hours ago

André RomijnCaptain

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

2 days ago

Andre te RaaCaptain

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

3 days ago

BlommetjePartner

Questions & Conversations

Logging of API usage

Hi, We have several apps calling Indicium, and using the data. This works fine, but sometimes clients complain about performance. We have a feeling that someone is calling the endpoint a bit too often.. or requesting a bit too much data.What options do I have to see how often someone (an app) is calling certain endpoints, and at what moment? Thanks! Blommetje

321

3 days ago

JhengSidekick

Questions & Conversations

Cube Chart

Hallo, I'd like to ask for any suggestions. We're creating a cube chart to represent Company, Volume/Number of Shipments, and Year. Is it possible not to display all values by default when the page loads? We'd like to add filters, such as by Company or Year, instead of showing everything at once. Right now, the chart displays all company values, and it looks cluttered. If there's a way to apply filters, that would really help with clarity. This chart will be one of the key items on our dashboard, so we need it to provide statistical insights into shipment volume.

435

4 days ago

Thinkwise Platform

Questions, discussions, news and updates regarding the Thinkwise Platform.

Questions & Conversations

2964 topics

News & Blogs

163 topics

Events

Customer Leaderboard

Show full leaderboard

Thinkwise leaderboard

Badge winners

Robert Jan de Niehas earned the badge Geek
Nathanhas earned the badge Advertiser
Guido Bijl 2has earned the badge Geek
jkruterhas earned the badge Geek
Leon Kroonhas earned the badge Geek
Stijn Schuurmanhas earned the badge Geek
PeterKeerishas earned the badge Transcriber

Show all badges

Community Statistics

3,417: Topics
11,042: Replies
1,049: Members

Welcome to the Thinkwise Community!

Featured topics

News & Blogs

Questions & Conversations

Ideas

Product updates

Thinkwise Academy

Roadmap

Thinkwise Platform

Questions & Conversations

News & Blogs

Events

Customer Leaderboard

Thinkwise leaderboard

Badge winners

Community Statistics

Welcome to the Thinkwise Community!

Featured topics

Questions & Conversations

News & Blogs

Events

Customer Leaderboard

Thinkwise leaderboard

Badge winners

Community Statistics

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded