Questions & Conversations

When utilizing the database function `dbo.tsf_user()` in a stored procedure, the value does not resolve the user requesting/executing the stored procedure, while using Indicium to do the request.To sketch 2 similar, but different situations.A process flow is executed through the Windows GUI. Stored procedure is executed while generating a report in DevExpress. Stored procedure utilizes `dbo.tsf_user()`, which results in the currently logged in user, the one executing the query. A process flow is executed through the Universal GUI. Stored procedure is executed while generating a report in DevExpress. Stored procedure utilizes `dbo.tsf_user()`, which does not result in the currently logged in user, the one executing the query. For other features in SQL, this error does not occur, for example for building certain views, functions, etc…However, for the stored procedure that is being used in the DevExpress report the currently logged in user is not being retrieved. Causing our reports to

I had a long break (a weekend) between starting the execute source code step, and addressing the errors it came across. After the weekend I resumed, and skipped the error it came across in the tasks step (renamed column was not yet renamed in a template, happens all the time).For the past 2 hours it’s been stuck on 55%: Generating new definition is still blocked:  I don’t see any processes that relate to thinkwise in sp_who2, though I might not be looking for the right thing. How do I resume or force-quit the execute source code task?

I have a column with a lookup that shows the “Name” value. I have set the Filter to “Contains”. In my filter it does stick with “Equal to”. Lookup Filter conditionU-GUI filter form resultIf I now try to search for component that have “Engine” in the name, I cannot get this result:Filter box Grid snippet with component names that I wish to see by only using Contains “Engine”Tried with several lookup controls, but does not seem to enable the option. How can I make it change to “Contains”?Usage: Platform 2025.2

AI provider type: Azure OpenAIChat completion model: o3-miniDoes anybody have experience with the LLM Chat Completion action and solved the cleanup needed on the Chat History output to bring it back to a usable format?I had encountered a Status Code -4 of the action, which turns out to mean: “ Unsuccessful (invalid history). See the input parameter Chat history in the table above on how the chat history should be formatted.”In my example I just put the Output Parameter of the LLM Chat completion in a Process variable and use that again as input of the next request. Turns out the output is so enriched, it does not follow the required format anymore.Here my example:Prompt: “Pick a number between 1 and 10”Received chat message: “Alright, I'll go with the number 7.”Prompt: “Now add 3 to it”This fails and that is because the history does not look like mentioned here: https://docs.thinkwisesoftware.com/docs/sf/llm#example-customer-support-with-llm-chat-completion[ { "role": "system",

We're experiencing performance issues in Universal with a certain view. I already tried using ForceRecompile in extended properties to make it load faster but that doesn’t seem to have an effect. I rewrote the sp_prepexec statement to a regular select query and it's just as slow. This is the query that’s being run on SQL Server: declare @p0 tinyint, @p1 nvarchar(6), @p2 int, @p3 int, @p4 intselect @p0=200, @p1=N'%A%', @p2=1, @p3=201, @p4=200000SELECT t1.[tsf_row_number], t1.[bedrijf_nummer], t1.[klant_groep_nummer], t1.[klant_nummer]FROM (SELECT ROW_NUMBER() OVER (ORDER BY t1.[klant_nummer] ASC, t1.[bedrijf_nummer] ASC, t1.[klant_groep_nummer] ASC) AS [tsf_row_number], t1.[bedrijf_nummer], t1.[klant_groep_nummer], t1.[klant_nummer]FROM (SELECT t1.*FROM [vw_example] t1) t1WHERE t1.[klant_groep_soort] = @p0 AND (isnull(t1.klant_geblokkeerd_voor,0) in (0,1)) AND (exists (select kg.klant_groep_nummer_hoofd from klant_groep kg where kg.bedrijf_nummer = t1.bedrijf_nummer and kg.klant_groep_

Hallo, Is it possible to combine Cube and Chart in one page? Now I can toggle between this Cube and Chart, possible to make it in one screen?     Thank you

Hallo, How can we apply colors or apply conditional layout in cube?example for below cube column KPI 1I  wanted to apply a text color to the result, if the average is less than 30 the text value will change to a different color  Thank you 

Hallo, applying image in conditional layout is not showing, even if i remove the background color   it doesn’t display the image, are there other configuration needed to set? thank you

How can I show an image in grid based on a public URL? I have a field with a varchar domain and UI control ‘Image link’. When configuring the storage location as storage type ‘AWS S3’ we get exactly what we want, however we want it to work using a public URL instead of an S3 bucket. We have tried ‘File system’ and setting the base path in the ‘path’ definition of the File System configuration. This does not show the image - see screenshot below. Unfortunately the indicium logs do not show anything related to fetching/showing the image/thumbnail. The developer tools show two requests related to the thumbnail. One does a count (no clue why) and the other seems to do something with filtering and returns the extracted file name from the URL and shows the indicator IsInvalid = TRUE probably meaning the file, url or request is invalid:URL:http://server_name/indicium/sf/1111/work_order_view.trade_work_order_kind_normal?useControlBasedFiltering=true&$filter=((subsidiary_id%20eq%201186)%20a

Hi,We have a view with a auto-edit and auto-save form, we have 1 editable field which is a barcode, after entering a barcode and hitting <tab> (which a barcode scanner does) in universal the focus goes onto the next object and does not save the record, is that intended? (2022.2.14 gui) Focus is on the 3 dots, top right.Also: When entering the screen, I cannot change records because of the form being in edit mode, we first have to cancel the row and select a new row. For us not a big problem for now, but I don't think this is intended?

 It is not clear on what the checkbox ‘Available’ depends. And there is the option ‘Make Available’ is also not visible when using the Grant task.Can someone explain this?

We have some processes developed which import Excel-files, for example for Sales Order creation.This process looks like:Excel-file will be placed on a network-location 1 time per minute a Microsoft SQL Agent job will run and determine if there is a file in the network folder if there is a Excel-file in the folder, some T-SQL code will open this file via an OPENROWSET action (using ACE OLEDB 16.0, and modified registry setting TypeGuessRows from 8 to 1 to support more rows to be analyzed for data type determination)  the data of the excel-file will be stored in a general Import-table a procedure will then analyze the new imported data based on predefined rules per customerSo we have several templates to import for the Sales Orders as several customers want to use their own Excel-file format.Then the issue we have:Now and then (say once per year), the ACE OLEDBD-drive in MS SQL Server will stop working out of a sudden by also providing the following error-message: Cannot initialize the d

We try to get a detail screen refreshed after closing a modal document. The document pops up by means of a table task + process flow from a detail grid.Solution 1:Trigger a process flow on closing the modal popup Not working, the Close Document seems to not work as a start action in process flowsSolution 2:Trigger a process flow with a table task that closes the popupNot working, the popup closes, but after this, nothing happens Any better ideas? 

Hallo, How to create a dropdown list as filter for Year and MonthFrom Period = This will display Year & Month To Period = This will display Year & Month The selection will retrieve those within the selected year and month from the table. Please advice Thank you in advance  

found above topic because i have the same issue.Is there any option to passthrough sas-token through a parameter in the task?Security wise it's not an option to store the token in a table or hardcoded in the report

Hallo, I have a field from which I can toggle between delivery and warehouse Delivery it will display other related address fielddelivery Warehouse - will display another fileds and hide the address fields (above) warehouse If I select 'Delivery' and enter some  address information, then switch to 'Warehouse', how can I clear the address information values from the delivery? and vice versa if I switch to Delivery then the value on warehouse will be cleared. I tried to incorporate the clearing of fields  to layout function but it doesn't work Please advice. Thank you

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

Hello everyone,In our custom components I am trying to integrate the event listener so I can switch to dark or light mode depending on what mode our application is in. But the code, which the documentation suggests, does not seem to work. I did the following:We use TypeScript so typing has been added.This is, aside from a few console.warn statements, a copy from what is in the TW docs. This is the suggestion from the TW docs with a few console.warns added so every log pops out.And this is the output of this bit of code: As you can see it does not get into the window.addEventListener. But if I change it to the following I get another result:The result is as follows: It does more, it gives me the console.warns I was after, but I don't get the TW status, which I was expecting. I am fairly certain I am doing something wrong somewhere, what could it be, as I am out of ideas. 

Hello,I am currently trying to install the icon set bootstrap thinkstore solution. However i can not get it working in my own model.I am currently following these steps1. Turn model into base model (this might be wrong but if i don’t it does not show up as a linkable model?)2. Link to project.3. Generate project.Error Message:The MERGE statement conflicted with the FOREIGN KEY constraint "ref_validation_sf_upgrade_validation_msg". The conflict occurred in database "SF", table "dbo.validation".I have one more thinkstore solution installed the “Application Log“. I think i’m missing a step somewhere or i am incorrectly changing it to a base project?Kind RegardsAnne Vries

How can i add Dutch to  the Thinkwise SF application in IAM   can only choose english in form  

My customer has configured the SSO with Azure ad as identity provider. So off course, if the user is disabled in the AD, the user can not login the tool. However, the Application Manager of the Thinkwise solution would like to see which users are active or inactive. The filter of active / inactive does filter out users, but we dont know based on what. therefore I'd like to ask for help with the following questions:1 - if a user is disabled in the IDP, is that somewhere registered in the IAM? -- If not, is there some best practise of how to make that happen?2 - What does the filter "in active user” in the user table in the IAM filter for exactly? I thought it was based on the date field, but aparently there are more variables.  Thanks for your help.

For a label generating application I have created a screen on which the user can modify a label, and directly view a preview of the label. The label gets generated in a separate service (accessed via web connection).The problem is with the pdf display, it is using the default browser pdf viewer, which is not ideal. Some problems I've experienced with it so far are:On edge: the viewer has an editor built in, and on every refresh the displayed pdf becomes smaller (probably to do with the zoom level of the browser).  On brave: the left-side menu is open by default  On chrome: it's not that bad, but it still has much more than I'd like the user to see (download, print, zoom, rotate options). Example on chromeAlternatively I tried displaying the label as a png.This does remove all the extra functionalities we don't need in the preview, but for some reason I can't print a png using the printers in thinkwise, only pdf, is this really the case? So to summarize, 2 main questions:Can I display a

Hello everyone,As reported before by René W: This issue was suddenly not reproducable anymore, but it pops up again in the software. But only on one report, all other reports work fine. Somewhere something has changed but I can't seem to find where. We recently, just before the summer holidays started, upgraded to 2025.2 of the Universal GUI, before that we never had any issues with opening this report.What has changed which may result in this, I cannot seem to find where I need to apply something to get it working again.

I want to know if/what custom CSS I can use in order to show clearly that the user is working in a non-production environment. Preferably I'd like to show something in the left hand menu bar so it will be always visible. 

Goedemiddag community,Een tijdje geleden heb ik de File upload api gebruikt in combinatie met een HTTP connector om een excel te kunnen uploaden en uitlezen. Vanwege security redenen probeer ik nu de HTTP connector uit te faseren en te vervangen met de web connection connector. Hier loop ik helaas tegen problemen aan die ik zelf niet op kan lossen. Om jullie mee te nemen in het proces:    De webconnection kan worden gemaakt want de tokens worden goed uitgegeven op opgehaald:Via postman lukt het om het excel bestand te stagen en te commiten via oath 2.0 waar ik gebruik maak van dezelfde webverbinding als in IAM staat geregisteerd. De webconnection waar die fout gaat:    De processflow logs:  Request URL .. /premium_prolongation(65)/detail_ref_premium_prolongation_premium_prolongation_excel_staging/stage_import?add_new_rows=true Request Method POST Request Headers Authorization: <811 length> User-Agent: Indicium/2025.1.14.0 Content-Type: appl