Thinkwise Platform

I've noticed that while creating UNIT tests with mock data that data columns which have the domain with Data type decimal do not show up in the mock tests. In this example on the table “voorraad” i have a column named “voorraad_aantal”When changing the datatype of the domain from decimal to numeric the column does show up.  when looking into the table “data_set_col_selection” which is what you see then script shows during creation that it has the following when statement it checks the table dttp if the .calulated is 0 when checking the dttp table with the following queryselect dt.prog_lang_id ,dt.dttp_id ,dt.calculatedfrom dttp dt where dt.dttp_id in ('NUMERIC', 'DECIMAL') and dt. prog_lang_id = 'SQL'the result shows that for decimal the value is null and for numeric is 0 Is there a reason for this? it the use of numeric preferable? In the current model that I'm working in the datatypes are all set to DECIMAL. Changing this to NUMERIC fixes the problem with being unable to create unit

Hello, I created a process flow to send user notification  However, when I run the process, the push notification doesn't send to users. When I login as the user the push notification didn't popup from the website.  Is there anything I missed out?   The input parameters are successfully captured I only put a show message to verify if the parameters are captured. Please help to advice. I'm using universal GUI 2025 Thank you in advance

Hi,After I created a client application in IAM and restarted IIS I get the error below, what is the cause of this? 

Hi all,I want to anonymize data on a database. However, I cannot set my database to ‘Single User Mode’.I get the following error: I saw on that I have to set HADR to off, however I get this message: ‘Msg 40517, Level 16, State 1, Line 2Keyword or statement option 'hadr' is not supported in this version of SQL Server.’ The database is hosted on Azure. Is there a setting in Azure I need to alter? Kind regards,Rick

Hi, I am running into an issue with downloading zipped data, since it returns unreadable data.The flow I have created looks as follows: The table task sets some parameters, like the folder which needs to be zipped, for the ZIP file process action. The ZIP file returns the binary data of the zipped files in the folder. The download file action is feeded the binary data from the ZIP file. This return something like the following in my downloads:  PK V´Z«H[Ï!z A¨ 2_ROOS NV_346514_14-05-2025.pdfÔ»y<›k¿.žÎƒªª©¥h«hKX­©5®VMUMÑš‚´UCDdµ„Ô”NæbaaáEÍm 5Dˆ¥¦ªª¤‚¨YH$qž®wÿöÙ¿wŸ?öÞ篓|îOâÉýÜÏ=|ÇëúR¾sÃ|IC[ô°rAaRªèa­Ó¿œF=ô=lh¨y÷éož§5 }==OkÚ£þ}ÅThe download file returns a 0 as successfull as well as the zip file action. As you can see, the data from the download file process action does have some resemblance of the zip_file_content which makes me assume that the zipped file data is actually downloaded. However, this is not usefull for the application user. The downloaded data should be a zipped

Some time ago (few years now) I replaced all PNG icons by SVG icons because of the future Universal Dark mode that apperently flips the BW colors? At least that is what I was told. During testing of the Universal GUI I notice that when I switch to dark mode some icons are shown white on the dark background, some are partially white and partially black and most of them are just shown black on the almost black dark mode background.I ran the “Decolorize all SVG icons that contain a black fill color” enrichment but that didn't correct the behaviour.The first icon I dug into (The globe with KIN in it) was one altered (originally downloaded from icons8.com) in inkscape resulting in quite a lot of metadata.I used https://jakearchibald.github.io/svgomg/ to clean my svg but the end result is still the same: I couldn’t find a task that showed the icon all white but there is one in the menu: I have attached a selection of icons used in the screenshots.

I've just recently upgraded to the 2025.1 version and I'm preparing the switch from the Windows GUI to the Universal GUI.I've noticed that the mandatory fields in the Universal GUi are a lot less visible than they used to be in the Windows GUI.Is there a simple way to make them a different colour like in this screenshot where I used a conditional layout (condition similar to 5 != 6) to force that this field is shown in Gold?Technically I could think of a query that automagically adds the desired conditional layout for every task field where “mandatory” is set to true to easily force this but that fielss like a very dirty hack 🙄Mainly because that is not what the conditional layout is for and it might even conflict with existing ones….

We are wondering if this should already work.I found out not, for that reason we have now added a form to the detail screen, while we want a detail that exists out of just a editable grid that also allows inserts.   

My users don't like the “the saved data cannot be shown” message.And in the context of this application I understand that.The search for a Person on a screen with a cardlist and a form.If they don't find the Person they must add it.After adding the Person they get this message.But they want to see the Person they just added.I tried making a task with a process flow that replaces the normal Add button.Very simple, a task without template, then process actions for Clear Filter, Add Row (capture Person ID), Change Filter (to Person ID).Work fine, but I cannot disable the standard Add button without als disabling the Add Row process action.So this is not the solution.Then I tried without a task, starting the process flow with Add Row. But then I cannot do a Clear Filter first.So it is Add Row, Clear Filter, Change Filter.But that gives met the dreaded message “the saved data cannot be shown” again. While it IS SHOWN ON THE SCREEN.How do I accomplish this?(On Universal 2024.3)

Hi,When viewing a PDF in Universal it is possible to create annotations like marking, drawing and adding text. As far as I can see the only way to obtain the annotated version of the document is to download it (manually) and then to upload it again to store it in a Thinkwise defined storage location.Is it somehow possible to the download the annotated document and then upload it again from within Thinkwise?

Hallo,, Can we easily applied / use Expression on the column table that will filter the result?Example:       Status has Yes/No value, but you want to display only Yeson status column table can we use expression calculated field  t1.status = Yes?or create a virtual column to add expression? The result will only display all status that has Yes value.I'm using table not view table. any other way to filter the result without using view table.  Thank you in advance

Is it possible to configure a unit test for a control procedure instead_of_trigger?I have a CP which inputs values when a user changes them in a view. The CP does some calculation and then updates values of multiple rows in the database. I'm trying to build a unit test for this without succes.Which unit test type should i use for this case? i've tried with update statement and update handler, but without succes.

I just read the following note in the documentation for the print file connector:PDF files can only be printed on a Windows platformIs this still the case? Because it would be a huge deal braker for platform independence and greatly hamper our efforts to switch to a full Linux platform for running Indicium and Universal services.Of course we could create a tiny application just for print jobs but that would still require a Windows machine.

Experimenting with our options to use AI tooling in the Software Factory, I struggled to even get a basic example working.We already have for other applications (none SF) some models in use on Azure. So for our experiment it would be handy to to use an existing resource and went with o3-mini.It always gave a “Unsuccessful (invalid request)” when looking in the Process Flow monitor. So perhaps the Resource Name need to include the whole url including the api-version, but that does not fit the field.Eventually we just tried another model, namely: gpt-4o-mini.Eureka! It seems this works straight away.So the question. Are the Models to choose for use with the Software Factory limited by certain types?

Could you please make a new account for a new colleague from our IT department? Her name is Robin Liu. Her e-mail address is [replaced by moderator]Thank you for your effort!

Hi,We have customers that (still) scan documents to a TIFF-format. As far as I can see the default Universal viewer doesn't preview files of this type. Is there an option to view these types of documents?

hi,We have a Universal application that has a grid which needs specific column widths, for entering both descriptive fields (wide) and hours (small). In the model we set some widths in the subjects, but when the users change this in the application, I cannot find these settings in IAM, Authorization, Users, User preferences.Only when I change the sort order of a column it shows in IAM.I can manually add a user preference in IAM, and after clearing the cache this change is visible in the grid. But it seems that changes in the grid are not saved in IAM.Is there something we have to set for this to work?Thanks!

We are looking for a way to make a pdf report, based on real time data, available on the customer's website. The intention is not to show the report in an iframe, but as a download.Something like how the file API works would be great, but then a real time generated file as response.Is there a way to realize this with a GET request?example: https://.../indicium/iam/api/public_vessel_schedule_pdf?route_name=north_europe&duration_weeks=4Or will this always have to be done via a POST request?We have started setting up a system flow, but we are stuck.What is the recommended approach?

Hi all,In our application, we have a form that is set to ‘Auto-edit’. Whenever the search bar is used and the filtered results are shown in the grid, the cursor is automatically moved to the form.Depending on the type speed, this can result in unintended changes of the values in the form. I have attached a gif of the problem. After I typed ‘Royal’ in the search bar, the result is shown. The cursor moved from the search bar to the form, where I started typing something. Can I adjust a setting somewhere to prevent this from happening? Kind regards,Rick PS: The GIF shows anonymized data.

Currently it is not possible to show an excel file with multiple tabs in the preview screen type.Only one of the tabs is shown and it is for the user not possible to switch between the tabs.  Is there are a way to work around this? Will the preview be improved?  This is an example of an excel file with multiple tabs:      

We try to make one single web service that can output json, xml as well as pdf and xlsx.The system flow works now for a text output (json, xml) or binary (pdf, xlsx) but not for both, because we assigning the 'Response Body’ property can be assigned to only one process flow variable.So what we need is a possibility to respond with a string or a binary body.Would that be possible? Or is there a work around?  

Hi!We have discovered that from a base model (SQLSERVER_MSG_TRANSL_NL) the translations are untranslated even that before they were. We managed to fix that by running a script that filled the translations from the base model GUI_TRANSL_NL.This is strange because as you can see below they were translated.Do you have any suggestion how this can happen to know how we can prevent this in future?Thanks! 

Hello, We were referencing this post for a dynamic language implementation: https://community.thinkwisesoftware.com/questions-conversations-78/translating-model-objects-in-business-logic-1991, but the session context variable SESSION_CONTEXT(N'tsf_appl_lang_id') only returns “eng” as the language, regardless of the language set by the user. It worked until recently and we were wondering if the new SF updates made some changes that might alter this functionality.Thank you!