Thinkwise Platform

Hello, I’m running into an issue with filtering a table data based on a column that has a lookup from another table. The column is an ID, but a lookup is defined to show a user-friendly string, which can have duplicate values for different ID's. We use this column in a 'change filters' process action in order to display the right data. When screen is open, the data is filtered correctly based on the ID, but after refreshing the screen, filtering uses the lookup value instead of the ID as we could saw in the database event log, which leads to duplicated data.  How can we make sure the filtering is based on the unique ID instead of the lookup? Thank you!

In older versions of Thinkwise it was possible to get the model of the API using the openapi#document parameter on the base url of the application. This no longer seems to function. Is there a change or an alternative way to get this information? I have tried using application.svc but this gives an HTTP 500 (same as using openapi).

I often use the query`select * from role_tabwhere tab_id = 'my_tab'and branch_id = 'my_branch'`when adjusting rights for a certain table (eg. new column added)to check if I have not missed any tables that have rights to the table. It would be convenient if in the Software Factory I could select a table and access type (hidden/read/edit, available) and then get a list of all roles that have the specified access on the active branch.Same could be useful for not just tables but columns, tasks, etc.

In our application, we have a process flow loop to generate reports. when the customer places an order he can select 1 or more order lines. Attached to the order lines are suppliers. The report loop groups the order lines per supplier to generate 1 report per supplier. This all goes well, but the report that is shown as a pop-up at the end is empty (because the loop ran out of suppliers and stopped). this empty report is the only generated report that is shown. how can I prevent this empty report to be shown?  

Hello everyone, We have a unit test where we want to check if the right value (either Dutch or English) is returned from the tsf_translate function. We set this value via a default, upon opening the right (help)text is shown to the user, in the right language. We want to unit test this, but how can I fake the Dutch system language in a unit test?I found a question that provided the following code: EXEC [sys].[sp_set_session_context] @key = 'tsf_appl_lang_id' ,@value = 'nl-NL' ,@read_only = 0;and that gave the following error: Is it possible to fake the system language? I can use it for English, as it always falls back to English, but I also want to unit test if it gives the Dutch values.

Hi , I need to copy several files from an SFTP location and store them in a SharePoint folder. I have already configured the SFTP connection in Integration & AI (File Storage Locations) using the required credentials. Could you guide me on how to transfer these files to my SharePoint location?RegardsZubair  

We have seperate application pools for DEV, TEST, ACC and PROD and another called BSA: BSA is a second PROD on which one specific TW application is running, conveniently called BSA :)We have seperate sites for the OTAP/DTAP but both Indicium_Universal_PRD and Indicium_Universal_BSA are in the same site:Both Indicium_Universal_PRD and Indicium_Universal_BSA have their own url but when I have logged on to for example PRD and then try to login to the BSA url I still get the applications from PRD. I need to actively clear the cache during login because it keeps pointing to the previously used site: In the above screenshot it is shown that after I’ve used the universal GUI for BSA and try to logon to the normal PROD site the Meta server url still points to BSA.Is there a solution for this? Or do we need to create yet another seperate site for BSA?  

Hi!I’m trying to change the font used in Universal.I know that this works when using custom CSS, but I noticed that the SF also has a Fonts section in the Advanced menu.I added the fonts there and verified that the fonts are installed on my operating system. However, the Universal UI does not seem to use these fonts unless I explicitly override them via custom CSS. (I also checked the Thinkwise documentation)Am I missing a step? I expected font configuration to be possible via the Software Factory as well, instead of only via custom CSS.  

Hello, I am probably missing something but when I am trying to grab an image from a table and set that in a task I get an error message. I am trying to grab the image from another table using a default. I set both columns foto_naam and foto_inhoud. Foto_naam uses foto_inhoud as storage location. Yet on the table itself it works perfectly fine.  As you can see, the column sees there is something, you can see the option to delete the picture. What am I missing? 

We are currently tightening user permissions within our IAM applications. Each company has its own IAM application with at least one key user. A key user supports IAM activities and is responsible for maintaining the role/permission structure for other users.We have reviewed the key-user responsibilities and adjusted permissions so they only have what they need. As part of this, we removed access that allowed changes to application-level settings. We no longer want to assign Main Administrator or Application Administrator roles to key users.Since these changes, key users can no longer access the “Effective user rights” table. This table is very useful for them because it provides a clear overview of what permissions users effectively have.Is there a way to grant access to the “Effective user rights” table by adding the required permissions to one of the following groups, without giving admin roles? Our key users currently have these roles:Application owners Group administrators User ad

Hello,We are trying to configure a printer that is located on a different network than our application server, which is hosted on Azure. We attempted to connect using the printer’s IPv4 and IPv6 addresses, but this approach did not work.Could you provide some guidance or examples on how to properly configure a remote printer in this scenario?Our goal is to integrate the printer into a process flow using the “Print File” action to print reports. In this context, could you clarify whether the printer settings defined in the report configuration are relevant or taken into account?We would appreciate your perspective on how these settings influence the printing process.Thank you 

Is it possible that after a deployment to production has been done an email is sent? In this case it is to inform among others release management. the email should contain date time, who carried out the deployment, branch name, application, etc.   

Hello, I'm converting my Crystal Reports to DevExpress. In DevExpress Report Designer my report is working well. I get a fine preview report. But when I put the report into the SF (changing the report type en uploading the .rpex file) and trying it in the windows GUI i get the next message:Error when trying to populate the datasource. The following exception was thrown: Query xxxxxx failed to execute.The query is correct. I have tried it in the SSMS also and no errors.What can be the problem here. Other reports went well and I have to convert more reports.The full message is:Error when trying to populate the datasource. The following exception was thrown: Query xxxxx failed to execute.Stack trace:   bij Thinkwise.Reporting.DX.DevExpressReportExecuter.RunDevExpressReportCommandInChildProcess(DevExpressReportCommand devExpressReportCommand, Stream exportStream)   bij Thinkwise.Reporting.DX.DevExpressReportExecuter.PrintPreview(TSFReportView report, String reportFilePath, Boolean isMandat

We have a bunch of views which are 1 to 1 to a table because of we need more details in a subject. In the Universal GUI more details to the same table results in a “Bad request”The smoke test gives an error: Cannot update identity column {coumn name]This column is read only in the datamodel and is not visible in the subject.The view is updateable and we have a insert of trigger to handle the update request.How can we solve this error, or is this a bug.As far we can see this is not an error.

Is it possible to turn off prefilters that are set to 'on hidden' in the subject using a process flow? Right now, it seems like only visible prefilters are affected. I'm wondering if this is a setting I can change or if it's forced by the authorization choices.

Hi, To support display of certain texts on first or last page in our DevExpress generated reports in case of multiple pages, we use scripts to show/hide those texts. This is working fine in the Windows GUI.We implemented it like mentioned here But now in Universal we are getting an error that script execution is disabled. Is there a setting in IAM that scripting can be enab​led for DevExpress or is there another option to show / hide texts based on the current page number / page count?We are using the 2025.3 release of Indicium and Universal​​​​​​

In windows, when you apply a look-up to a subject column, and choose a variant, first a query is done for the subject, and then the look-up is retrieved with any variant ON prefilters applied.However, in universal, the look-up retrieval is combined with the subject query with a LEFT JOIN on the look-up table without any prefilters applied. (neither with a default subject or variant) I have a case where this leads to row duplication and consequently non-unique PKs. Was this behaviour intended/foreseen? To solve my problem I would have to make a view instead of use a prefilter, but it would have been nice if a prefilter sufficed.

We are looking into a way to add some monitoring to our Thinkwise environment, currently we check the public Health endpoint but this lacks some information we would like to have alerting on. Is there a way to authenticate via headers for the endpoint?

Dear community,With a recent addition of a cube view in our application, this is not our first cube.However, some items are expandable, and others are not. See point 1: this one is expandable.However, point 2: This is open, see the arrow on the most left, but it is not showing records. Although these records are present on a database level.

I’m installing an upgrade ‘street’ next to my development street to be able to run a complete upgrade of the software factory / iam / iam_dev / Indicium / Indicium_sf and universal to the 2025.03 platform.Everything is running except for Universal which gives the next message:The current identity (USERNAME) does not have write access to 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files'.I have never seen thes message before. I just copied the Universal GUI in the upgrade folder next to indicium and I changed the config.json to "https://URL/indicium_upgr/iam/iam"I also changed URL to localhost, with the same result. I also tried the iam/sf endpoint.If I paste the https://URL/indicium_upgr/iam/iam" URL in the browser the result is: SQLSERVER_IAM 2025.03 (Which is corect as far I know)If I paste the https://URL/indicium_upgr/iam/sf" in the brower the result is: Er is geen webpagina gevonden voor het webadres: https://serpupgr.saan.nl/indicium_upgr/iam/sfHTTP ERROR 4

As the question states: when I try to register a session variable, it removes the dot needed. For instance for the session variable Session.base_url (for a custom component to use to decide whether you are in the live or dev environment), it removes the dot between Session and base_url: Is anything else but underscores illegal in this field nowadays? If so, how would I simulate session variables for the SF? I can make session variables for the test environment, as that's done via the IAM. But development is done via the SF, is this supposed to happen?

By default our application shows 4 decimals in Numeric fields, but we don't want to show any trailing zero's for standard nummeric fields and 2 decimals for currency fields.Our Windows gui does this, but Universal is always showing 4 decimals.How do we get Universal the same as our Windows Gui?

Hello all,I have a small question, is there a possibility to trigger a small and simple process flow per record switch? When I switch record, I need it to do a request to retrieve some data to use in a custom component. To further simplify said custom component, and to further simplify our code, I would like to ask if it is possible to trigger this per record, so only the necessary data is retrieved.