Thinkwise Platform

Hi,when we try do download an installation package from the TCP of about 400MB in size, we can't download it at our office due to some firewall issue.At home, downloading is no issue.Other downloads don’t have this issue, and we can easily download files of several GB's.As our technical IT partner has some issues finding the root-cause and solve it, the question if someone else experienced this issue and has a solution.It should be somewhere in the firewall (ours is a Watchguard)Thanks.best regards,Cyril

Hi all, We have run into a problem with a table task in the Universal GUI.  As can be seen in the picture below, the screen where the table task is located has three ‘types’ of screens.In the blue you'll find the main screen ‘my sales orders’ which is a variant of sales order. In the red you'll find the details of my sales order, the sales order lines. Beneath it is the form of sales order lines and the detail of sales order lines (shown in green).With the current screen, the table task (shown in the yellow box) does not work. This table task should start a process flow and takes four parameters. Once we delete the form of sales order lines (shown in red) and its detail screen (shown in green), the table task works and starts the process flow. If either the form of detail screen or the detail of sales order line is activated again, the table task stops working.  We have run into this problem with mutiple other table tasks/ process flows, specifically when there is a screen type with a

When adding a task in the action bar/task bar in Universal GUI, is it possible to only show the icon instead of icon and text (whether or not there is space available)?would like to show icon only 

According to the documentation on the reporting service, i-net clear reports is not supported. Is it possible to build a system flow to send emails containing reports that use i-net clear reports? If not, what alternatives are there to send automated emails with reports using i-net clear reports? Thanks in advance.

Hi all, When showing opened documents in Universal gui we get the text “Open Documents” (img 1).Can I set my own text? Because I don’t find the term “documents” fitting.img 1Thanks

Payments in ThinkwiseWe have created a lunch app for our colleagues where they can register whether they used the company lunch. The cost for a single lunch is €2,50 and this must either be paid directly or from your wallet. Therefore, we had to integrate some sort of payment provider.This article describes how we implemented this payment provider for a single payment. We used an ideal (Dutch payment method) provider. Please note we solemnly implemented this for the Universal GUI, therefore it might not work as smoothly in one of the other GUI’s.Payment processBefore diving into the solution, it is important to have a little understanding on how payment providers work. A payment provider must be connected in order to make any payments. Once there is a connection with a provider you will find out that it does not return any useful information by itself. For example, if you would like to know the status of a payment you will need to send a request for this status to the provider. The pro

Hi. See attached video. When I open my App on a mobile device it doesn't adjust the default tiles to the available width, whilst after I do a search it functions the way I would expect it. Initial: After search: 

I am trying to fill a view's form within a process flow on the add row action.Let me give some contextI have a view in my application that is used to create a “klus” this view uses a process flow to achieve that goal. process flow designNow i am trying to design a new process that creates a “klus” triggered by a task on another table. Some of the values of this table i want to be present in the form on the add row action.I added a new alternate starting point for the flow that opens the view and passes the required values as process variables. I however cant seem to get them into the form.View with process_flow monitor openI have tried adding them into the input parameters of the add row process action but this does not seem to work. Am I missing a step somewhere?Input parameters of the add row actionGreet Anne

Hi. I've created a calculated column in SF and used the domain NUMERIC(16,8) ..  however apparently doesn't look to there.. it makes it NUMERIC(38,7).. however this calculation has 8 behind the decimal. How do I make it at least a precision 8?  

Hi. Today one of my trainees added in the model the default value via expression and he added the getdate() function as mentioned in the documentation: https://docs.thinkwisesoftware.com/docs/sf/data_model#default-valueBut although it says SQL server is the only one to support it, it create a very strange insert statement at upgrade time, which is not accepted by SQL server. select t1."DataCadastro"(getdate()) as "DataCadastro" from __Processos__ t1It looks like something was not generated correctly in the SF. 

When i tried to open my application in Universal GUI, the application opens but no data is getting displayed from DB and  it is showing  error messages as ” Reset dataset failed. Error: An unknown error occurred, please contact your administrator.” and “ [unknown_error]” .It is not updated with latest data model change too. Has someone faced this before? What could be the issue? 

Hi Community, While implementing different API's we noticed that it could be difficult to write the authentication headers. Examples of these headers are often written in C# or JavaScript and not in SQL.  Is there a way to write these authentication headers in other languages than SQL?  Thanks!  

I think the Universal handles the setting 'Start with Empty Filter' incorrect. It should not clear the context of a detail when it's opened via a detail tile. 

For my project, we need to use SF as a form, to be filled by candidates who get selected in the recruitment process. The initial data for each candidate comes from a third party (ZOHO recruit) database. As per the requirement an email will be sent to the candidate with a link (universal url), after clicking on this link the form should open. As per my discussion previously with the Thinkwise solution experts, credentials are necessary in order to logging into SF. The workaround for that we are using is creating users for each candidate using their email-id as the user-id. My concern is that, for example : there are 20 candidates per day filling the form, then in a month there will be around : 600 and in a year : approx. 7200. Will this cause any issues in the system performance in the long run? Is there any other solution for this issue?

Hi,I made a small change to a PROCEDURE template and when I tried to generate the code group on the Functionality > Assigning > gear icon I get the following error: The control procedure it points to seems to be autogenerated?Any pointers on what is going wrong here?

Does anyone know if it is possible to use a date-time mask in SF?We have set the default date-time representation in our application using the extended property CustomDateTimeMask.For 1 specific screen we only want to display the month and day + time, so e.g. 22-12 13:24 instead of 22-12-2022 13:24.Is this possible with the help of a mask or something like that, or do we have to convert to a text field (ouch)

I want to create users in IAM using API. In order to POST the details , I am using below JSON query as the Body. Its working via Postman, but not through SF. I think the format to write JSON query is not correct. Has someone tried it. Please let me know the correct format to use JSON query in Body of an API.Postman DetailsSF input 

Good day,I’m trying to open a URL with a task (Windows GUI) but I can’t get it to work.Per the docs, I created a ‘Windows command’ task and gave the Object name the value ‘http:’. I created a task parameter ‘url’.To open a dynamic URL without knowing the default browser, you can trick the task by using 'http:' as Object name and set the first parameter to the URL to be opened. The same goes for other URI schemes like 'mailto:'. The default browser opens up, but it doesn’t go to the URL. I even tried ‘http:[url]’ but I can’t get it to work. However, if I ‘hard code’ a link in the Object name, it does open up.What am I missing?

We have deployed the Software Factory to Azure. With the new 2022.1 release we are unable to save the deployment .sql scripts. As workaround (or improvement) we can download the files from indicium (/iam/sf/code_file?$filter=project_id eq '<project>' and project_vrs_id eq '<project_version>' and code_file_generated_code ne null&$select=code_file_id, code_file_generated_code)I would like to automate the download process, but struggle to get the login token from indicium.How do i programmatically authenticate to indicium to download the deployment scripts? 

Hi,I’m struggling with the change detection. It seems that our @col_id parameter doesn’t get filled (always null). In the docs it says that the column will only have a value when the logic is called if the table to which the column belongs, is shown as a detail. In our case we display the grid of a table and we have the form of this object under a detail tab. Context, layout and default procedures have no problem reading our @col_id but in the change detection, the value is always null.I thought the primary key columns of an object would be available and filled when a detail tab is opened or a row is selected. Is this not the case? Is there a way around this? I would rather not refresh all objects whenever one object gets changed. 

For our demo App we are utilizing API's that have to be called per row. So we have 28 states and to get my data I want to have a solution that checks which data is missing and then automatically fetches this data per state in this case. Same goes for a company with multiple locations… how do i get my App to automatically get all the coordinates for these locations? Basically a cursor for the HTTP connector. I've tried another solution in the community to go to the first row and then cycle to the last.. but it didn't work because the key values are not passed on and secondly it's a GUI action so the user has to wait until the GUI visually went through all the locations. Any suggestions on how I can subsequently invoke a http connector based on a query result?

HI. I have a company with 49 active locations…  but I cannot seem to show them all on the map. Is there a limit somewhere defined?  And how do I overrule it?   

Hi, I have a table ‘contract’. I have a table ‘charges’. I’ve created a connecting table ‘contract_charges’I want to enable Drag&Drop so that the user can easily select (multiple) charges, drop them into the connecting table, and there see an overview of all connected charges for that contract. I’ve created views based on the tables. I open ‘contract’, and show both ‘charges’ and the connecting table as detail. The view for ‘Charges’ is a select * from charges cross join contract. When I drag to from ‘charges’ to table ‘contract’, the task works ok. The row shows in ‘contract_charges’ - however, I think it is counter-intuitive to drag to ‘contract’. I want to drop them into the connecting table. When I try to do this, SF automatically sets both parameters to ‘Check for equality’. This is due to the fact that the parameters exist in both tables(?). If I remove contract_id from the view, it won’t show as a detail (; therefore the cross-join). Can I create a workflow where you can dro

I keep getting asked to login..  and I am 100% sure the credentials are correct.