Questions & Conversations

Looking for a suggestion to make a screen part refresh after selecting a new row.The situation:In green I have a selection method which all reference after each other, so starting at 1 I end up at 4 selecting a certain record.Because of the way screentypes work, I cannot have the pink part at 5 be a reference of green 4 or else it would only be the width of green 4.So to be able to make the pink screen part use the whole width, I have a hidden view that hold the reference to the green part (1) and the pink part (5) as a tab container with a detail tab.I am abusing the context procedure to store the selected record of green 4 in table, so I can make the reference to pink 5 using that hidden view. All rainbows so far!Now the tricky part. The pink 5 does not refresh, as there is no reference from green 4 to trigger this.Anybody got an idea what can be done to achieve this refresh? Thanks in advance.

On a barcode scanner device we use the Universal GUI, we want to send feedback to the user using sounds without any text message. In the SF we can add a audio file to a message, but this only seems possible in combination with a popup/panel text message. Is there a way to only send audio? Note: An empty translation for the message still popups an empty box in the GUI which we don’t want.

I've created a client application that is supposed to log every x minutes in the thinkwise database to know it's alive. There will be around 1500 clients that would basically use the same access token, as I will use a local parameter to diferentiate the different logs. To prevent having 1500 logins every x minutes, I presume it's preferable to use the token / refresh token. I'm trying to configure the opeid Machine-Machine integration as described here:Client applications | Thinkwise Documentation (thinkwisesoftware.com)The big question for me is: Now what? I've looked for documentation about how to test the configuration in insomnia/postman, but I've not found any help here.  Could you help me with these questions for configuring in insomnia: To use the oauth 2.0 flow with client credentials 1 - I set the url the url I want to retrieve access from: GET <base_url>/organizations2: granType: Client credentials3. access token url: WHAT SHOULD THIS BE?4. client id: I presume this sho

Hello everyone,When I try to merge a branch back into our MAIN branch I encounter the following error: Just before I did the actual merge, I did a merge from MAIN into the branch I am working on to apply some changed that had been done. This merge, apart from some branch related merge conflicts, went just fine. But when I try to merge back to MAIN, I get this error. And I had the exact same merge conflicts I had a bit earlier. The conflicts were resolved the same way: the development branch was the leading branch for these conflicts. But each time I get an error on a reference regrading column roles. We have a suspicion it might be a recently deleted column, but that column cannot be found in any recent branch.What could be going wrong?

Hi all, A conditional layout on a tree view does not work in Universal. The text should be bold (conditionally). However, the layout does work in the Windows GUI. Could you provide a solution or workaround for this problem? According to the Feature matrix on TCP, the Tree - Conditional layouts should work on Universal. If needed, I can provide more information. Thanks in advance!

Hi,Recently we did a merge and a full upgrade from one branch to another. Somehow the upgrade failed which resulted into 4 tables being renamed to __table_name__We renamed them back from __table_name__ to the original table name but we found out that the constraints are missing.We tried to do a full upgrade again hoping that the constrains would return but they keep missing. How do we get the constraints back?The correct constraints on DEVThe incorrect constraints on TEST after the upgrade failed and rename of the tables We are missingDF_entity_data_mut_tenant_guidDF_entity_data_mut_insert_employee_guidDF_entity_data_mut_update_employee_guid

Hi,I’m trying the following. I have a task that inserts a row in a table ‘input_json’. This task is called as an endpoint, so a supplier can insert some data. The task works, but I have two issues; The JSON: { "id": 123456789, "package-id": "", "timestamp": 1718105305, "location": "Rotterdam", "measurements": { "dimensions": { "height": 100.0, "width": 100.0, "depth": 100.0}, "weight": 100.00 }}My task fails to read the nested values. When I remove the nesting from the JSON and post, it works ok. How can this be mapped accordingly? Secondly, the key ‘package-id’ has a score. SF always change my score (-) in the task parameter to a lower score, resulting that the value isn’t saved.How can these two issues be resolved?Thanks and kind regards!Blommetje

Hi,In an earlier post I asked how to disable the installation as PWA option for an end-user and implemented the solution using the config.json en custom.css entries. This seemed to work (and does work when opening the solution in a private browser window). For several users that have been using our solution while this option was available, the installation option doesn’t seem to want to hide. We have them clear the browser cache with no effect. Also restarting the App Service (Azure) didn’t seem to solve the issue.Is there some other location where this information is stored and/or can be cleared?

We have a system flow with a schedule to run each 15 minutes. The schedule is activated. When I look in the tab with scheduled runs, I can see the next 5 runs.When I look again after a while, the scheduled runs are updated, but the schedule log doesn’t show the executed system flow. It looks like it stopped executing system flows yesterday.I checked the Indicium and IIS logs, but found no information. I would expect that I could see all status information in IAM. Maybe this is solved in a newer version, but we are using 2023.1.What could be the reason? How can I monitor what happened and why it is not running? 

Our branching strategy is setup in the following manner: we have a “MAIN” branch and each time we release a production version a separate branch is created. The upgrade process basically consists of upgrading from one branch to another branch. This works fine, but i recently stumbled upon a problem.When renaming a table or column the data migration in the SF does not automatically see this as a change, but as a “removed”  and “new” table / column. This is probably because the upgrade scripts are generated between branches instead of within a single branch. I don't know how the SF determines when table / columns are changed or new. Is automatic data migration not possible between branches or am i perhaps missing something?For now we fixed it by by creating data migration scripts and manually set the data migration.

Hi,We have created a functionality that is working well in our DEV branch, but for some reason I cannot get it to work in our staging/acceptance environment. In a DnD area we are performing an API call to indicium. It looks like this:xhr.open('POST', 'https://{{company_url}}/indicium/sf/go_acc/document', true);xhr.setRequestHeader('Content-Type', 'application/json');xhr.send(JSON.stringify(payload));When we try to upload a file we get a 401 unauthorized error. I've tried changing my user's authorization settings in IAM to RDBMS, Windows and IAM to no avail. I've also tried adding ‘/public/’ in the url to hopefully open to the public, this led to a not found 404 error. Any other things I might've overlooked that cause this error?One thing that might be interesting, but I can't find any info on, is that our production environment runs under https://{{company_url}}/universal/ and our acceptation environment runs under https://{{company_url}}/universal_acc/. could this difference in URL ca

When I create a new model in the SF (2024.2), vrs_control_branch_id and vrs_control_model_vrs_id of the main branch will be empty (and stay empty after generating definitions) (screenshot 1). When I develop something in the model and then try to upgrade the database, no ‘upgrade’ script will be generated at the ‘creation - execute source code’ tab (screenshot 2). Am I missing something here?After setting vrs_control_branch_id and vrs_control_model_vrs_id in the database of the SF, it does work correctly.    

We are still unable to display Multi Line HTML content in a grid within the Windows GUI.Is this possible and if so, what should we take into account?Are there special requirements for HTML formatting?

Hi,I have a chart that shows the capacity per day. The x-axis shows the dates. However, the sorting of the x-axis on dates is not working properly since it sorts alphabetically instead of numerically. E.g. 10 - 11 - 1, …, 20, 21, 2, … 3,30,31…  instead of 1,2,3, etc.The year, month and day in the cube are base on 1 column: date_day_only.I think I can create a workaround here by adding the day in the view like 01,02,03 etc. but I think I am missing something here in the settings. Graph sorted alphabetically instead of numerically Cube settings 

Currently installing our TW application at a customer where Internet access is only possible through whitelisting per site. Which URL's and ports need to be whitelisted to allow license registration and license refresh?I think https 443 for:- tcp.thinkwise.app- *.thinkwisesoftware.comAre these sufficient? 

I believe the default behaviour of the GUI when adding a new item through a form is to retrieve all fields and filling them with the default value (if defined). Even if the field is hidden. All fields are eventually  specified in the actual insert / update statement (excluding identity columns it seems).I am using a column with the default value set to expression and newsequentialid(). This can only be used as a default expression for the column. So i want to exclude this column when adding a new item.I have unchecked the default, layout, context checkmarks for this field in the subjects. When i add a new item through a form i get the following error:I think what's happening is that field is still retrieved and initiated with it's default value newsequentialid(). Is there anyway to exclude this field? I found this topic on the community Uniqueidentifier with NEWSEQUENTIALID as Primary Key | Thinkwise Community (thinkwisesoftware.com) from which i derive that newsequentialid() is not su

I want to connect our ERP with Documizers/Docuflow using their API. In short: the first step is to create a workspace, the second is filling that workspace with data.I use Postman to test step 1: The ID that returns I can use in step 2.How do I translate this Postman-POST to the HTTP-connector POST?No matter what I try, Indicium is returning error 400: Bad request.My return-parameter http_result_id is filled with:{"":["Failed to read the request form. Invalid header line:     "]}in stead of an ID.This is how I activate the HTTP-connector: And this is the content of http_body:set @http_body=--ItemID'--abcde12345Content-Disposition: form-data; name="ProcessName"Koffieadvies--abcde12345Content-Disposition: form-data; name="File.Name"pdw--abcde12345Content-Disposition: form-data; name="File.Extension".txt--abcde12345Content-Disposition: form-data; name="File.Content"; filename="123.txt"123abcde12345--'The API needs a file (with is an empty one).I also tried just sending the processname, bu

Is it possible to show only the color, instead of color + code in grid in universal?Compare with windows GUISo we can hide this irrelevant info on other places 

Hi,We have a subject definition with a default sort order on three columns and a prefilter which is always on (logged on user specific content filter). When this subject is opened from a menu-item, it shows the records in the correct (subject defined) sort order.When this same subject is accessed using the API, it seems to have a different (or no) sort order. When looking at the request Universal sends to Indicium using the same endpoint, all sort columns are specified in the request.Is my assumption correct that the sort order, which is defined on the subject level, is not used when accessing the resource through the endpoint without any parameters? Or is there some setting that can be used. It would be preferred to use as much the subjects configuration where possible so it only has to be coded in the backend.

Hi there.We are using a setup that is described in your documentation: Load balancing | Thinkwise Documentation (thinkwisesoftware.com) (Azure application gateway). We are using the standard import file functionality in a particular case where the file may have >10,000 rows and 30+ columns. The process takes longer than the application gateway request timeout (20 seconds in our case) and therefore a 504 is returned.Do you have any recommendation of this setting in the application gateway? Thanks in advance! Best regards,Nick Janssen

I'm looking for an easy way to obtain an end user's Time zone- and Language setting within the end database to be to make inline translations and conversions from UTC Time to Local Time?For example to construct a HTML card list field based on multiple fields.Any ideas?

Hi,The idea is the create a link to an external application. Right now this is the table we are using with 2 fields (a lot more, but those are not relevant)external_invoice_numberexternal_urlThe external_invoice_number is a readonly fieldThe external_url is a hidden fieldI thought of using the Calculation Type: Expression for the external_invoice_number field to create the link, but somehow it is not working (or my code is not correct)Why is this not working and what is the correct way to create a link? This is the code in the expression ​​​​​​​case when t1.external_invoice_number not null and t1.external_url not null then         '<a href="' + t1.external_url +'">' + t1.external_invoice_number + '</a>'     when t1.external_invoice_number not null and t1.external_url is null then        t1.external_invoice_number     else        ''     end 

Is it possible to have a variable value (e.g., a value from a table) as the value for the constant line in a cube view? Currently, I have only managed to insert a value which is plotted in a graph, which is sufficient, but it would be great if the value could be based on a value which the user has control of (e.g., a target for a KPI which the user may manipulate).

I've created a cube in a Proof of concept application, and I'm observing some strange behaviour.  in my column I have a date field and a responsefield that can be a value from 1 to 4 (it indicates the level of satisfaction)weird thing 1: if I have a dimension based on the score field and value based on the score field, in the pivot table the dimension gets substituted by the value field.    You see here that the categoy is average score, and in the pivot tabele you see it's actually dimension. weird behaviour number 2 if I use the count on the response field, and the amount is 3, which is a value of my element_list, in the pivot table it does not show 3 it shows the translation of the element item 3.  Weird thing 3:  if I have two fields based on the score field, say total count and average, when drag and dropping one of the two it is always substituted by the other one.  it basically means It's not possiblle to have to value items based on the same field?  

Hi, We have created a subroutine, that returns a table. The input params are employee_id and Date. When I call this routine through SQL it works and returns the rows as expected. When I call this this Subroutine through Indicium (with Postman) with a GET - I do get a 200 - but no data. It does not matter if I send use params are not. How can I have Indicium return the table /results? Much appreciated!Blommetje