Questions & Conversations

Good morning,Yesterday we have tried out the extended property that should enable an integration between Thinkwise and Matomo: We would like to use Matomo for heatmaps and session recordings.Despite that we have set the extended property (and even installed the JS; https://developer.matomo.org/guides/tracking-javascript-guide), Matomo's dashboard is not receiving any input from our application built in Thinkwise. Could you explain what we need to do in order to integrate Matomo properly?Thanks in advance. 

Hallo everyone,we have a tree-view in Universal GUI (2023.2.10) that contains a Icon column. The Icon cames out of a domain with a set of elements that represanted some kind of anser types.We also define the image-column in the SoftwareFactory: But in the GUI we dont see any icon. But I think there is a little space that represanted the space for an icon. When we change the screentype to a grid, the icon will shown as expected. Do we miss something or do we somthing wrong? Or do icons not (yet) work in the tree view under UniversalGUI? Thanks an kind regardsChristian

I created a column in a table with the xml data type. However during execution of the source code of the update trigger of that table, I get the following error caused by this field.Therefore I would like to exclude this field from the update trigger, but I cannot find a way to do this. I already set the “Trigger for update” attribute of the column to false in the subject, but that doesn’t do the trick.The following highlighted code fragment in the update trigger is the problem I guess.Is there a way to exclude this field from the automatically generated update trigger?

Is there any link, documentation or whatsoever to help a non microsoft person to get the email provider using graph working. I just don't get it to work, and there are no logs with error messages to get me started.  Where do I make the client, and how I see if it works. I added as a test a graph client/secret (made it via de azure identity > Applications), made a notification template and send myself a notification via email. I just see status 'failed to send' but cannot find anything in any logs.  

We have an item database with about 50.000 records, limited to 200 records (we need 200, this cannot be lowered for better performance) a lot of records contain an image with the varbinary database storage method. I am unfortunately not able to test if the images are the cause of the performance lag, but i am quite sure, because within seconds there are 100's of mb's used when viewing the item table (other larger tables with just text cause no problems). The problem only occurs on the windows client not on universal, and the problem is exaggerated on wifi or vpn because of the mb's that are transferred to the clients. I have tried to hide the image column (the one for viewing) but the performance dip stayed. Almost as if it is slowed by the existence of the image blob varbinary column. Is the system perhaps trying to show the full images instead of smaller thumbnails? is there a way to limit the mb usage while viewing the grid?

We have a Reporting Service installed and configured to look at multiple instances/databases (development and test). All records in table rapport_queue are processed for the first connection. When a record is added in the second application, it is not processed by the Reporting Service. After a restart of the service, all records with report_status = 0 are processed correctly. New records will not be processed after a restart. We have uninstalled the Reporting service (3.00) and installed the latest version (3.20) with no different result. What could be the problem? Config: connectionString=" Data Source=CFS-TWDB01\THINKWISE; Initial Catalog=CF_FINAS; Integrated Security=true; User Id=; Password=; Persist Security Info=True" providerName="System.Data.SqlClient"/> connectionString=" Data Source=CFS-TWDB01\TEST; Initial Catalog=CF_FINAS;

Hi,I was wondering if it's possible to disable the ‘auto selection’ of a row in Universal. This in part with auto-edit/save enabled can lead to wrongful data entries by accident without even noticing (fat finger mistakes).In the Windows GUI this behavior already exists. Even if auto-edit is enabled the user has to knowingly click on a row to ‘activate’ it for auto-editing. I've looked into the available extender properties but to no avail. Thanks!

In the testing phase of SF 2021.1 we tried to change a process flow from using the DB connector to the new Application Connector. However, we don't seem to get this working.See the process flow below.When calling the process flow via a POST from Insomnia, we see no results. The process flow stops at the Application Connector (see screenshot below). We expected to see the next process actions in the Indicum Universal DB event log. The input of the Application Connector is as follows:How does this Application Connector work? Are we missing something?

We have a view which contains a lookup column to another table. Whenever you edit a row in this view, the user is able to select a value from the lookup. This looks like follows:Whenever we press this lookup, the user is able to select a cost record:This works like intended. However, we would like to have a prefilter which filters the records on a vessel type which is selected on the parent table (in this case our parent table is so called calculation). See the image below:So the idea is when this prefilter is ON, we want to filter all the cost records in this case on L-Class ice. Is it possible to collect this value and use this in our prefilter?  For now we activated the search bar, to make the user manually fill in their vessel type. Thus, filter that way on their desired types for which they want to find cost records. This is not how we want it to work though. Using a prefilter would be way better to achieve this! Does anyone know if this is possible?

Hi, Are there any guidelines when implementing a multi tenant architecture using Thinkwise. Which means we have 1 database instance for multiple tenants (organizations) sharing the same tables. Each table will have a tenant_id to distinct the owner of the record.I want to figure out which possibilities there are to store tenant specific information in a table:Creating for instance 10 extra fields that can be used by the tenants is probably not really a good option in Thinkwise as I've not found a way to have context/tenant specific translations. Creating tenant specific fields in the base tables is probably also not the best option if we have for instance 5 tenants that want to use 10 additional fields. which means we have to create 50 extra fields in he base tablesHope to get some good ideas from theThinkwise community. Thanks!

The Docker containers are deployed on this page: https://docs.thinkwisesoftware.com/docs/deployment/container_deployment_docker_composeThe Indicum container is connected to the database (it is managed in the logs) and the Universal container is also connected in the logs and warnings are given for errors.I've tried many things in YAML including ENABLE_REVERSE_PROXY and FALSE which says "404 page not found".Please help!This is my YAML (but apparently also with the standard and with just about all possible current ones). Original in Dutch - Above translated:Ik heb de Docker containers gedeployed zoals op deze pagina:   https://docs.thinkwisesoftware.com/docs/deployment/container_deployment_docker_composeDe Indicum container heeft connectie met de database (heb ik gecontroleerd in de logs) en ook de Universal container geeft in de logs geen warnings of errors aan.Ik heb in de YAML veel dingen geprobeerd zoals de ENABLE_REVERSE_PROXY op FALSE te zetten, maar wat ik ook doe, ik krijg in de

Multi-selecting rows is quite new in Universal. We think the functionality itself is really interesting, and that is why we tested around a bit with it. A task is able to execute multiple times, depending on the amount of rows you selected. Recently, we have added a Context procedure which disables a task in certain situations. Whenever a row is selected which does not meet the requirements specified in the Context, then the task is disabled. If you multi-select a row for which the task is enabled via the Context, then the task is enabled again eventhough a row is selected for which you should not be allowed to execute the task. Luckily, the Universal GUI shows the following message when trying to execute the task:We noticed this behaviour does not happen in the Windows GUI. There the task is executed even if one of the selected rows disabled the task. Therefore, the questions we have regarding the multi-select functionality are:Is this behaviour final in the Universal GUI? If not, is

Hi there, We would like to know if its possible to download a pdf file (or convert it to base64) through an api. Sadly the API only gives the PDF file instead of a base64 encoded string. If abose is possible. Please explain how. Because we dont know where to start even. Results :Preferred method : Save it as base64Optional and not preferred : Save the file on our own server.Must have : Displayable on our own application

The users in our EndProduct can create employees for their company within the application. We have a task that creates a relation + an employee record. In addition to creating an employee we would like to be able to create an IAM user with the information and credentials the user has supplied. So we made a subroutine called ‘create_iam_user’. This subroutine does inserts/updates on the IAM database. After creating an employee record the subroutine will be executed. But when it does, we get the following error in return. The users in our EndProduct have no rights on the IAM database and the ‘User Admin’ rights are not granted. I tried altering the procedure to execute it as OWNER or as a SQL login that does have ‘User Admin’ rights. After changing the procedure the execution (via SSMS) of the procedure succeeded with a SQL login that has no IAM rights. However when trying to execute the procedure via the EndProduct user we still receive an error. Why doesn’t the ‘EXECUTE AS’ method work

When accessing the Universal GUI from the web browser, Windows authentication is first requested. Only after ignoring (canceling) this pop-up will you arrive at the login screen.How can we get rid of the first pop-up?   

Hi all, Does anyone has a clue how to solve this message.The index ligt buiten de matrix grenzen. It happens when I try to open a detail list contact person on the relations subject. Don’t remember we changed something there.It occurs direct when pressing the detail tab contact person. It’s a detail what worked for ever? It occurs in my testdatabase right after restoring a backup from live and running the upgrade.     bij Thinkwise.TSFComponents.TSFGrid.buildVisibleColumnIndex(Obj obj)   bij Thinkwise.TSFComponents.TSFGrid.SetObj(ObjViewContextUserPreferences objViewUP)   bij Thinkwise.TSFComponents.TSFGrid.afterControllerSet(TSFController controller)   bij Thinkwise.Shared.NullableObservable`1.OnAfterSet(T newValue)   bij Thinkwise.Shared.NullableObservable`1.OnValueChanged(T newValue)   bij Thinkwise.Shared.Observable`1.set_Value(T value)   bij Thinkwise.TSFComponents.AbstractViewBuilder.bindControl(IAbstractScreen rootControl, ScreenElement element, IImplementsScreenElement control,

What is the purpose of the parameter cursor_to_col_id? I tried to move the cursor to a specific next field after moving another field.  Just adding a statement like below, does not make any difference. SET @cursor_to_col_id = 'document_number' Could anybody give an example or explanation on how to do this?   

I tried to set up the “forgot password” function in IAM. So I filled in Global settings the email service and the IAM user has the function “change password” on. But I get some strange errors in the logs of Indicium after I use the forgot password function.  

I don't like the distinction between the colors in the default color palettes (see attached image) and would like to create a color palette myself. I would like to know if that is possible and if it's possible, how it can be done.

Hi,I am using the DevExpress report application provided by thinkwise. I want to localize my report so I can export it in multiple languages. The report is for invoices.I found this link in the docs: https://docs.devexpress.com/XtraReports/401573/detailed-guide-to-devexpress-reporting/globalize-and-localize-reports/localize-reportsHowever I cannot find this option in the devexpress provided by ThinkWise. Any suggestions on how to achieve localization?

We like to show the contents of interface messages in a previewer control. I found out that this is possible with an expression field, with the formula like below and use a domain with control type HTML. ' body { font-family: Calibri, Tahoma, Arial; font-size: 14px; font-weight: bold; } ' + REPLACE(REPLACE(REPLACE(t1.message_body, '<', '<'), '>', '>'), CHAR(10), ' ') + ' ' It is nice, but it does not fully give the desired output. Any suggestions?

For a project, we would like to be able to create RDBMS users from inside the end product. For context, we are using a configurator inside the end product from where we are able to enter the first employee of a new company. We would like to make that employee be able to log in after we finished the configuration. I know which steps to take if I do it by hand; namely: sync my application to IAM, apply the roles to the database, create an IAM user, connect the user to a role, apply the user rights to the end product database and IAM database. Then the user is able to log in. But now I would like the end product to do this process. I'm able to create an user in IAM and give the user the right user group. Now I'm stuck because I can't apply the user rights to the end product database and IAM database. I noticed these tasks aren't Stored Procedures on the SQL database. So the question is, how can I make this work? I heard that in other projects people have run into these challeng

Hi, I want to fill some values in a form on the moment that the user starts editing. I wanted to do this in the default procedure, but this is only executed after an edit has happened and not on the moment that the edit button is pressed (like the layout procedure). Is there a solution for this in thinkwise? Thanks

We want to implement single sign on (SSO) on our application. We are using the Windows GUI which makes connection with Indicium. We connect over the internet. The Indicium installation is on an IIS server in our own network. The ini file looks like: metasource = iam rdbms = indicium server = https://application-indicium.xxxx.nl/api The usernames we have are e-mail adresses and in IAM are configured as ‘Authentification type’ = IAM. We would like to use the Office365 authentification (online sign-in services). Is this possible and if so, how do you do it?

Hi, we want to setup that the Universal GUI sessions expires in x minutes. We've create an application pool for the Universal GUI (Agent disabled).In the advance settings of that application pool, by 'Process Model’ we've set the ‘Idle Time-out’ in x minutes.  What happenend in the Universal GUI now is that after the x minutes the session ‘freezed’. When you start a task or someting, the session responds after af few seconds. Also tried setting the session state as described in Docs. But in the Universal site i'm not able to edit the Session State. When  i set the session state in ‘Default Web Site’. is not working.  So what is the right way to setup timeout in Universal GUI?