Thinkwise Platform

Hello,I'm trying to use the web connection to send a json body, but i'm not able to get it going. BEfore losing more time with it, i went back to using the http connector, where it works as expected. I saw this topic: Web Connection Parameter | Thinkwise Community Is this still an issue, or is there something else going on? 

Hi!We have started in a few places in app to separate the grid and details of the lines because the screen was to crowded.We do that by using a task triggered by double-click on record which starts a process flow:Depending on the place task was triggered, the process flow takes the primary key and navigates to a variant passing as filter the primary key On the variant, we have only the details of the record clickedThe main problem is that if the user refreshes the page, the primary key is lost and the form will display the information for the first record in the initial grid.Is there a solution for this? If not, maybe we can find a solution, me and my colleagues where thinking that besides the subject and variant used will help also to include in URL the record in focus.this is the current URLour proposalIn this way, not only will help keeping individual pages for records relevant but also in grid to not lose the focus on a row and maybe other usages that I don't have currently in mind

Please make it possible to filter on blank values in columns, like it is possible in windows GUI   

Hello,I was wondering if it is possible to automatically adjust the grid row height to the content of a column which has HTML control. For example, our grid cell looks liks this now:Cell of a grid with data type = NVARCHAR and control=HTMLWe achieved this by manually setting the row height to X pixel, but are wondering if there is some other way? If there is an alternative to HTML control in order to achieve this, we are also interested. 

Hello,For a specific usecase, I want users to be able to import a custom CSV file. The import of this file triggers inserts in more than one table. Therefore, the standard import function Thinkwise offers is not sufficient at the moment.In order to tackle the problem. I have a start task which has 2 relevant task parameters:file_name (data_type=NVARCHAR(512) and control=File upload). Here, the users selects a file from file explorer file_data (data_type=VARBINARY_MAX). Here, the varbinary file data is storedThe file which is being uploaded is UTF-8 Encoded. After using CAST(@csv_varbinary as varchar(max))I can see the VARCHAR information. However, special characters like “ö” do not seem to work with this method: “ö” becomes: “ö”. Any advice on how to proceed from here? After doing some research on the internet I tried the following statements already:select @test_varb, CAST(@test_varb as varchar(max)), CAST(@test_varb as varchar(max)) COLLATE Latin1_General_100_BIN2_UTF8, CAST(@test_v

When I filter in Universal GUI, it works. When I save this as a pre-filter and filter again on it, it results in bad requests Because it is not possible to create a simple ticket in TCP, I put it here!!   I cannot share the whole URL in this ticket!FYI: the 2 fields are expression fields  

In the windows GUI, after changing your password, you get errors during default procedures. The debug only says: “Default”.This is solved by restarting or reinstalling the Windows GUI. Reproduction steps:Open the windows GUI Change your password to something else Trigger actions with default procedures and lookupsCurrent behavior: An error with the text: “Default”Debug console: default***QUERY**addition: The software factory has the same behavior

Thinkwise end application is created and deployed, but can’t be accessible even for the IAM admins. We need immediate support! 

In the release notes of Universal GUI 2024.3.12 you mentioned Task Grouping in your introduction, but after upgrade we do not see any changes.   

We have a workflow to set default filters when someone opens a screen;Step 1) Open document … triggers …Step 2) Decision; Filter valuesStep 3) Set the filters.This did not work for a while, but works again.I now tried to create the same at the moment that the user opens a subject which is a detail, but the workflow doesn’t start.Does anyone know how I can start the workflow at this point and set the filters?Thank you,Daan​​​​​​​

When using the windows GUI (TSF_dotNET.exe version 2022.2.16.1) to connect to a SQL Server 2022 database backend it shows when using USE [master];GOSELECT *FROM sys.dm_exec_connections;GOthat no connection to our application is using an encrypted connection.The encryption of the connection can be forced from the server (by using a (if needed self signed) certificate), but of course the clients (windows GUI, Indicium and whatsoever) should support this.Regarding this situation the following questions come into mind:Is using an encrypted connection between de windows GUI 2022.2.16.1 and the backend database server supported ? If so, please point to the appropriate documentation Am I correct in assuming that username and password are at this moment (in a situation of no encrypted connection) exchanged in plain sight ? How is the exchanging of username and password between GUI in general and application, by whatever means, ensured that it is encrypted should we be using the latest releases

Hello everyone,In our software sollution, on some screens, the columns tend to be out of proportion. Here is such an example:The status column is out of proportion, because it is way too big for the small word in there. It gets even more creative with the responsiveness when we hit the task with the padlock icon:now suddenly the projects get out of proportion, we don't know what causes this. It might be one of our settings, but we simply cannot find it.Does anyone else have this and had a solution?

One of our customers, who is using the Windows GUI (2019.2.17), is using up to 9 GB (!) of internal memory on the RDS with TSF_dotNET.exe. Most of the time TSF_dotNET.exe is using around 2 GB, but that is also too much. How is this possible and how can we limit this?

I am looking for a way to simulate the Export functionality that is an option in the GUI, but turn it into a process flow so I can run it as a background task. Also prevent a user having to make certain choices on what to columns to export and to what file format it will be.Certain customers desire large data exports and the .xlsx option will cause OutOfMemoryExceptionOut, but .csv seems to succeed. This process takes quite a while to complete, even though the view itself has the data selected in less than 10 seconds. All this is reason we want to take away the options for customers and put the wait as a background process.What are my options in this case?

Hi, Is it save to assume that icons that cannot be updated with this feature are not used in the model? And can be removed without issue.If so, would it be an option to create a prefilter/(or task) ‘Unused icons’ - similar to whats available on the Domains-tab. Blommetje

I have some big files to upload to Drive/Sharepoint via Graph. How do I model this scenario in Thinkwise?Steps to Upload a Large File Using Resumable Upload Session Create an Upload Session Use the /drive/items/{parent-id}:/{filename}:/createUploadSession endpoint to initiate the upload process. Request: POST https://graph.microsoft.com/v1.0/me/drive/items/{parent-id}:/{filename}:/createUploadSession Authorization: Bearer <access_token> Content-Type: application/json Body (Optional): { "item": { "@microsoft.graph.conflictBehavior": "rename", "name": "your-backup-file.bak" } } Response: The response contains an uploadUrl that you use to upload the file in chunks. Example Response: { "uploadUrl": "https://upload.url.for.your.session", "expirationDateTime": "2024-11-16T23:59:00Z" } Upload the File in Chunks Divide your file into chunks and upload each chunk using a PUT request to the uploadUrl. Chunk Size: Recommended size: 10 MB (10,485,760 bytes). Maximum size: 60 MB (62,914,

Is it possible to automatically refresh visible detail tabs when a field is changed and auto-commit is enabled? 

We have a process flow which will be started by a task. It wil open a document in popup, and after selecting a record in that document, we need to continue the process flow with this selected record. We want to prevent building two process flows, as it will be difficult to save the selected row in one process flow and pass it to the next one. Now i know there is a process step called Manual. First question is: What does this process step do? The documentation is not very elaborate on this. Second question, can we use this manual process step after opening a document, to wait for user input, and continue after a new task was clicked in this same window?

 How can I add extra separate attachments in the process flow from the project folder ?

Hi!We have for now some places in app where we do want some precision for our fields, usually we use type numeric with different specifications depending on the needs.The problem that we have is that we don't always want to show all the decimals, we need them for some calculations still.It is already something to do that and we just didn't find out what? Is weird to display that many decimals if the user doesn't need them but for background calculations are needed. (This example maybe is a bit to much, but for 6,8,10 decimals can be some situations and still are a lot to display)If not, we don't want to fake with with a field of another type with some format and so, maybe we can have another setting on the domain for this situations where we can specify display decimals. (other cases can be for description fields for example if you want just a preview of description and maybe more uses).

 Hi!We have quite a few dropdowns which are pointing to variants and seems like for all of them once a few weeks we get them stuck on this "Loading...”.The strange part is that if you let it open and wait to dissappear, click again on the dropdown, the results are there.Do you have any idea what is going wrong? Is not for a specific table and some variants don't have anything fancy, just some prefilters. If we try directly with the table/view, the problem does not persist. 

Hi, im trying to retrieve the parent_row_id from a newly added row. However @ and T1 both dont work. Anyone knows how I should fix this?select top 1 step_nr + 1from calculation_step--where calculation_method_id = t1.calculation_method_id «order by step_nr desc  

I am trying to do something like this; According to the documentation change filters should not start an Universal flow, but it should start a system flow, and how else then a user changing the filters could a flow be started? So, what I try to do is not to use the step to change the filters but to get the result of the user doing so, but nothing happens.Am I missing something or is this just not possible?What I want is to know the selection so that I can apply the same selection to a report on the page, while the page is based on another Query.I’m also wondering if the report would be filtered when based on the same subject / table as the user is viewing?Being able to run a task on all the rows within the current selection ( not those selected by the user could also help ), as I manage to only output the report based on the users selection in the grid, but I would also like to create and option comparable to the export option; Daan  

Hi,I am trying to enable 2FA bij selecting the login verification option “Password and TOTP token” in IAM. When I try to login with that account for the first time a dialog is shown with a QR-code to register. After scanning the QR-code from the authenticator, the App is registered and a TOTP token is provided. However no validation token is provided, which has to be entered next. I have tried this with Google Authenticator and Microsoft Authenticator with the same result. I have entered an existing e-mailaddress at the user level, but to no avail.Did I miss something that needs to be configured or has someone encountered the same issue and can provide me with a solution?I am using 2024.1