Questions & Conversations

Hi all,I made some cubes for quick access to aggregate data. The client wants to export the results of the cube.The build-in export function exports the table/view associated to the cube.Is it possible to export the results of the cube (e.g. the aggregates)? As context, the build-in export function exports this view:  But I want to export this aggregate cube: Hope you can help with this. Kind regards,Rick

I have a process flow where I use a web connector and I want to use a parameter in the end point query string. So I have set this up in the web connector but from the manuals I can't figure out how to fill this parameter from a functionality or something like that.Can you help me? 

Hello everyone,We are currently trying to send emails via the MS Graph API. This has worked very well so far. Now it is specifically about adding file attachments. Some of the attachments are stored in Azure and therefore have to be written to the database as a byte array before sending. The reason for this is the fact that we have to keep emails and attachments together and of course the byte array has to be converted into a Base64 for sending.So how do we get the files individually from Azure into our database as varbinary(max)? Does anyone have any ideas or experience?Translated with DeepL.com (free version)

3 rows selected in this gridGUI versie2025.1.12.1.0When selecting multiple rows in dark mode, it’s almost invisible which rows are selected. We also tried changing the colors in “Themes”, but without any good results. Is there any other possibility to change the color palette for more visibility of the selected rows in a grid?   

After the last Universal GUI updates (we switched from 2024 version 3 to 2025 1.14), reports (like PDFs) are opened embedded within the application. We would prefer these documents to open directly in the browser (e.g., Microsoft Edge), like they did previously.Does anyone know how to configure this behavior — for example via path_spec, task action, or another setting — so that the report opens in a new browser tab instead of inside the GUI?

I would expect imports work within the same versions of 2025.1. Is there a reason why a different sub-version blocks this task? And is there an easy tool to upgrade a model without upgrading the whole environment where the model is exported from? ************************************* Thinkwise Software Error Message *************************************Datum: 19-6-2025 10:54:22GUI: 2025.1.13.0.NET Runtime: 4.0.30319.42000Database: IAM_SFLanguage: NLSoftware Factory version of the imported model does not match the Software Factory version. The import cannot be continued.Imported model SF Version: 2025.1Current SF version: 2025.1.14SQL:task_import_model

In Windows it is possible to do a sum on a “checkbox”, where the domain is INT   In the Universal GUI, this doesn't work Would be very nice if this option will also work in Universal GUI….ef_evnt_event_staff_planning?$apply=aggregate(count_using_dinner%20with%20sum%20as%20count_using_dinner_sum)Results in 500 error :-(.Is there a way to make that work?

 When POSTing, the following works:"profile_picture": { "FileName": "name", "File": "file_data" }So setting a profile picture works. Now I’d like to remove/clear the profile picture of a user. I have tried the following JSON bodies in a PATCH, but none seem to work:{"profile_picture": { "FileName": "", "File": "" }}{"profile_picture": { "FileName": null, "File": null }}{"profile_picture": null}{"profile_picture": ""}{"profile_picture": { "FileName": null }}{"profile_picture": { "FileName": "" }}{"profile_picture": { "File": "" }}{"profile_picture": { "File": null }}{"profile_picture_data": null}How can I clear the columns ‘profile_picture’ & ‘profile_picture_data’ in the usr table in the IAM using a PATCH API call?

Since some time we don’t see the application icon anymore in the Windows taskbar for the Windows GUI.This is for both the SF as our end-user applications.What we see is: This is already since a longer time, and we didn’t notice it straight away, so don’t know if it's related to some Thinkwise update or Windows update.Also changing the icon in the IAM Global Settings doesn't solve the issue….Any solution for this ?(we are working on the latest WIndows GUI and latest 2024.2 patch)

I am working with a grid where auto-edit is applied. In the documentation (https://docs.thinkwisesoftware.com/docs/sf/process_flows_actions#add-row) it says the ‘add row’ process flow action should not be triggered, but it does when the row is added by pressing enter when the cursor is at the last column of the grid. Is this a bug? I would like the process action to be triggered when the row is added regardless, but I believe that should not happen as is explained in the documentation. What is the intended behavior here? And is there another way to trigger a process flow action when a row is added on an auto-edit grid?

I'm looking at public API calls..   can I require a select or set it so that API call with select criteria returns no data?

In our application designing process one person describes the model and of course, a crucial part of the description is the database model drawingWe discuss this and com to a version that can can be creted in the thinkwise SFI would like to know if there is an easy way to jump start this step (looking at the theme developing 10x faster) Two questions: about the ai generation, can please someone tell me what I'm missing? Is there a way to import some kind of database scheme? For example, I experimented with designing with dbdiagram.io/ that can export a creation script fror sql. If we could import that, that would save a considerable amount of time. I did see the option to create an AI generated model (which did not work for me for some reason  

We are looking at DBML a DB markup language that grows with you. Is that something that Thinkwise could support? Especially in scenario's you don't start with the Upcycler and you start building data structures together with a client. https://dbml.dbdiagram.io/docs

I have an api that inserts/updates data on a regular basis (every few seconds it adds a record or updates one.This table is visible in the GUI so I've activated auto refresh with an interval of about 5 seconds.This works fine until the user tries to select multiple rows at the same time…Every 5 seconds the multirow select is deselected and only one remains selected…. I want the user to be able to select multiple rows to be able to fire of a task that does something with each of the selected records…I've tried to get the Refresh behavior to work but after setting the  GridEditUpdateUsingRefreshOption extended property in the SF >  I still cannot see the refresh behavior for the actions After insert, After copy, After update, and After deleteCan someone point me in the correct direction? 

Hello,  I'd like to understand what value should be set if I would like to have a sequence to execute the process action?From what I know, if the value of the process action is set to 0, it means the action will not be executed.-- Follow-up process actions. The number assigned to them will determine the order in which they are (depth first) executed. A value of null, 0 or a negative value means the process action will not be executed. Here’s an example of my process: in my decision workflow, I want the "Send User" action to execute first, followed by the "Email Connector" or vice versa, what is the depth first order number? where to view this? should I put 1 being the first one to be executed and 2 is the second? and so on...code snippet on decision process to check: if @notification_type = 'both'   begin   set @execute_user_notification_stop = 0 set @Send User = 1 set @Email Connector = 2 end    Thank you in advance

 I have set in DevExpress that the amounts use a Dutch format, I also see this when I do a preview in DevExpress, but when I upload the report in the SF and generate a preview via the application, it uses the American format by default. DevExpress preview:  Universal preview: 

Hello!I have a process flow with a 'Refresh table’ process action.The table that should be refreshed is a detail of a table opened in a modal document. The process flow is triggered by an iFrame which is a detail of the table that should be refreshed.Everything is executed successfully but the refresh process action(it outputs -1 and the table is not refreshed). Do you know why this may be occurring?

Hi, The applications in IAM keep the status: 'will be taken offline’. This has been happening since last week, before that the 'Take application offline’ task would immediately take the application offiline. Does this have any influence on the running application? How do I fix this? Kind regards,Mark

Hi all,Is it possible to commit the auto-save when all the field of a form are entered or when switching screens?In our application, the auto-save commits every time one column is updated. This is linked to a handler and process flow, so every commit takes some database processing power and time. When users work fast (e.g. click an answer in a combo box and fill in a textbox afterwards), the commit hasn't processed the first action, sometimes resulting in loss of data.In the GIF, you can see I entered 'Ja’ on question 4. When I select the next question, and go back to question 4, the answer is set to ‘Onbepaald’. As far as I know, this is due to the handler and process flow actions.   I want to know if it is possible to only commit the auto-save when a next question/detail is selected, so the screen will only commit once.Thanks in advance.Kind regards,Rick

Hi, I am running into a weird issue with an API request. Firstly, I’ve made a client application on my test environment (which is hosted on Azure). Sending both post and get requests work perfectly with the client credentials.After testing on the test environment, I moved on to testing on the acc environment. I have created the client application in the same way as on the test environment. However, the acc environment is hosted on premise. When trying the same api request for the acc environment, I get the following error:Specifically: Bearer error="invalid_token", error_description="The issuer 'https://p2p-acc.tkb.nl/indicium' is invalid". I am trying to figure out how to fix this error, however there is a third party the is in charge of the on premise environment which also cant seem to figure out how this error is solved. Has anyone else ran into this issue? And how did you solve this error?The request does work for a basic auth request, even with the exact same rights as the client

Hello, Some questions on notification.When a process flow notification is triggered, users can see it upon logging into the system. But if the user is already logged in, how long does it take for the notification to appear for them?                     - I’m experiencing an issue where the notification sometimes appears and sometimes doesn’t if the user are already logged in. What could be the possible reasons for the notification not showing up consistently?  How long does a notification items remain in the Notifications after it’s sent? I’ve noticed that once the status changes to 'Sent', the notification disappears. Is there a configuration setting to retain it for a longer period? or how can I see all previous items?  Additionally, how long does the notification remain visible on the portal? Is there a configuration setting that allows us to adjust the display duration?   Is there a way that I can capture the sent date when the notification is sent and  capture  the statuses (below

Hello, We are executing an external request to call a process flow in a custom component. The execution is successful and the process flow is completed, returning a 204 status.    However, the toast / panel notifications displays this error. Do you think this is because the 204 status (no response body content) is treated as an error? Can this be suppressed in any way? Thank you. Best regards,Valentin  

Just a quick question, can the Public API call be tested against the SF? https://docs.thinkwisesoftware.com/docs/indicium/api#public-api-calllike GET server/indicium/public/sf/entity(ID) ?

Hello Community, We are trying to implement a radius search on a map element.We have a table with geocoordinates (Lon and Lat), which we can also convert into a geography::Point.For the purpose of planning, I now want to know when I am on a dataset, which datasets from the same table are X kilometers away to do further planning.On the MS-SQL Server side, we know what to do:declare @point geography = geography::Point(<Latitude>, <Longitude>, 4326);SELECT id, geo_pointFROM [table]WHERE @point.STDistance([geo_point]) <= 40000; -- input distance in meters But in the Sofware Factory / Universal GUI we are currently unable to find a solution. Clearly a task with the distance as a parameter and the current geodata of the selected data set. And as a result we could get a list with IDs which data records are within the specified radius. But how do we filter this and how do we prevent everything from being recalculated immediately when the data set is changed? Or are we thinking i

Hi, In my application I am trying to download a file that has been stored in a folder in a local file storage location. The file storage location is configured for the environment I am on.However, I am getting the following error when trying to open the file:The column that has the storage location is indeed file_name_queue. But the file_id is null, which would suggest to me that the file is not found. The file is stored in the folder of the storage location. What could be a reason that the file_id is null?