Questions & Conversations

We have several VIEWs with a trigger attached.Everytime we add a column to the view or make a small change to the internal query we need to manually remember to also regenerate the triggers for that VIEW.Is there a way to automate that? An error like the ones the user get when a DEFAULT or LAYOUT isn't regenerated would also help a lot. Currently the trigger is just missing causing seemingly mysterious things to happen (the mystery is mostly why they do not happen).

EDIT: It seems to be related with Firefox. In Chrome all looks correct. Hi,I'm currently doing some testing of our TW applications in the universal interface and I noticed the following: Why are the “Aantal” and “Ontvangen en geindentificeerd” not on the same baseline?Is this a feature or am I doing something wrong? Maybe it is the fault of Firefox? 

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!

hi,During the Creation steps in Deployment, I’ve had some problems because I used preserved SQL names (check, revoke) in the data model. How come the SF does not validate this during Creation? Or am I missing something?The list of preserved words is getting bigger and bigger..

I try to generate source code but it tells me it is waiting for “Execute source code”. No big deal normally but “Execute source code” isn't doing anything as far as I can see…  When I try to connect to the db with the little lightning bold button and press Execute nothing seems to happen….Other times I ran into this issue I was able to connect and cancel it, but not today :(Any ideas?

Is it possible to show a DevExpress report preview as a screen component like the file preview in the Windows GUI?Our intention is to show for a list of records a preview of the related report, to verify if the data is ok, to reduce the user input for click on a report button and each time a popup is coming.

Is it possible to have Two-factor (2FA) authentication enabled on Windows GUI with Indicium-basic as application server?If so how do I setup this?

I am building a screen in which a barcode can be pasted and entered with a barcode scanner. For this purpose I’ve created a view with only its form visible and in it only a barcode field. This field should be editable multiple times without having to click any GUI buttons. According to the view itself these are updates of the barcode field. Behind the view is an instead of update trigger that adds the new data to a table. This works. As soon as a barcode is typed into the field and ctrl+enter’d a new row is added to the table.The problem is the form isn’t editable immediately despite having auto-edit enabled in its subject settings. I need to click in another tab in the gui and then return to the view to have its form editable. This seems to be the standard behavior of auto-edit in tables too.I’ve done some testing with combinations in a process flow to make the form editable without needing any user input between barcode updates but so far I’ve been unsuccessful to make this work. For

Hi. In the latest Universal the combined filter is always showing..  although everything is turned of in the settings.    

I created a cube with view type chart and chart type 2nd line. We use the chart in the Universal UI. On the x-axis dates are shown and on the y-axis a value is shown. The data is visible when hovering over the dots on the line, e.g. “2021-10-01, 44.13K”. Is it possible to hide the dots on the line or disable the hovering feature so the user can not see the value?

Hi, is it possible to trigger a update action of a detail (2) by clicking on de update of the main screen type (1)? The reason for this is because of some confusion of which update button to click.Thanks. 

Hi,Is it possible to create a lookup without a keyboard input field? See the attached image. I only want the dropdown menu, no field with a cursor in which I can search through. The reason for this is that we use tablets, and whenever we select a text input field the keyboard appears in the screen and the user has to close the keyboard.  

I upgraded our applications in a single IAM with multiple tenants. There are 2 tenants and one user from one tenant has access to different applications. We achieved this by making a new tenant, create 2 usergroups, for each tenant 1, and then aply the user rights to IAM. Works fine. However, when I try to upgrade these applications I have the following error displayed while trying to applying the roles to the database:I bypassed the situation by removing the authorisation before applying the roles to the database and recreate the authorisation afterwards. Why is this not possible? (using TW platform 2021.3)

We use the HTTP connector to communicate with a API hosted by Swagger UI. Because this API services is running on the same server as our Indicium (IIS) we use a localhost URL.   HTTP connector - URL  We receive the folowwing response:⚠️ -1 - Unsuccessful (unknown) System.Net.WebException: The SSL connection could not be established, see inner exception.---> System.Net.Http.HttpRequestException: The SSL connection could not be established, see inner exception.---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure: RemoteCertificateNameMismatch  Is it possible to disable this validation (certificates check) for this specific process flow? 

I am fiddling around with payment API's and for a better user experience I am searching for a good way to show a QR code with payment link to use within banking Apps based on the actual QR code "qrCode": "HLT505HNFLRX7M6TGIINAP9HUZ9J1V2WR7HMZXYDC0195QEG10ZW4A2T926W", 

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.