Questions & Conversations

When you make alterations to the model, especially the data part that results in an upgrade script. What are the best practices when someone create something that is not accepted by the database. In this case the you can choose to ignore and go on or to abort. To not loose data it's best to go for the abort scenario. But then you get stuck with all the renamed tables and all or partially the new tables already. When you fix the problem, there seems to be no easy way to rerun the upgrade script because with every existing you get an error..  so 130 tables renamed and 130 tables new = 260 messages.. Can there be an option to just ignore the messages?  Or can there be an option to roll back the situation by deleting the new tables and renaming the backups back to its original name? Now I just 'hack' my way through it via SMSS, but perhaps the SF can offer something more elegant. 

Hi,I have tables which have a is_deleted column. Now I want to make a clear distinction where is_deleted = 1. I can do this with conditional layout where the background color is specific color, but adding this for each table is very time consuming. fyi: My application is in Universal GUI.Is this possible with the dynamic model? If so, how should I do this? Thanks

I have a cube view with cube view columns sorted descending. When I show the cube with the SF model, it works fine. But when I synchronise it to IAM, it does not sort the columns descending anymore (2021.2). Only when I use the ‘sort by cube field’ (not mandatory) it works also in IAM. Is there a reason for this behaviour? 

Hello,We are using the Exchange connector to process e-mails, which arrive on a certain e-mail address, within our ticket system. These emails often contain attachments and are saved using the sendGetAttachment + saveAttachment. However if the attachment is an e-mail the @byte_array will be NULL and will not be saved. Does anyone have an idea why @byte_array is NULL when the attachment is an e-mail?Thanks in advance.Greetings,Randolph 

I created a unique index and I deployed my project. When I try to delete this index I am getting“An explicit DROP INDEX is not allowed on index ‘ sales_person.unique_sales_person’ . It is being used for FOREING KEY constraint enforcement.”error message.I tried to clean install but it didn’t work. It is in software factory version 2022.1How can I solve this? 

We need to transfer our real-time freight data via an XML file to our carrier. In what way can I do this safely using Thinkwise?Is an FTP link secure enough for this? 

Has anyone figured out how to implement barcode scanning in the Universal GUI. At this moment when I scan a barcode in a TEXT field the GUI does not perform an ENTER. So the value is Shown in the field but, the value is not processed by the default because the GUI does not handle the scanning action of the terminal as an entered value. (I already tried different settings on the scanner like HEX suffix 0X0A (Which is the equivalent of ENTER) But the universal GUI seems to ignore this suffix. So the result is that the value is shown in the field and the user always need to do something on the screen. We need to scan a barcode, process it’s value in a default, moves the cursor to another field or the same field. For example, scan a product barcode, scan a location, scan a product barcode, scan a location. A created a test form with only 2 fields and want the default to handle the scanned value and moves the cursor to the following ‘to-be-scanned’ field. Someone has ideas??? declare @msg v

Is there a way to change the message in the confirm update/delete in the subjects settings so the default buttons can have different messages?

My user ID in the IAM has English as application language, but I have multiple applications in the Universal. How to I set the default Application language for my User? I am create a Portuguese Brazilian App and I cannot find out how I start that one with the pt-BR language by default… 

Well, my co-worker saw the status bar in the TCP and instantly wants to have it in our system as well.How is this created? 

For my project I am trying to send an email as soon as the candidate saves his/her details in the form. I made process using the SMTP connector as per few suggestions via the community. However, the email is not auto generated. Below is my process flow. Initially I used “Activate detail” process action instead of the “Start task”. What needs to be changed in order to generate the email after the candidate saves the details in the form.Process Flow My input parametersThe variables have the details for the smtp connection to Zoho mails. 

I am trying to understand the rules that govern the height of the task window.It seems to be determined by the total height of the first column (I think) but on this occasion it is not. Context: We are using the tasks available to us through the resource scheduler extension. In this case we are trying to enforce the correct layout for the double click appointment task. Example:This task has fields that need to be hidden/shown based on the appointment clicked (type of appointment, state of appointment etc...)In our “standard” state our task looks like thisTask in natural stateNow we also have a “ready/definitive state” for our appointments this means certain actions are no longer available. So we hide them. Now our result suddenly looks like this result of hiding the 2 fieldsNow our 5th field suddenly jumps to the next column pushing all the fields further and further. None of the fields on the left have the checkmark next column. My question is:What determines this behaviour and how is

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.In some cases it may be desirable to know the translation of a model object, such as a table, column or domain element, inside your business logic. See for example this idea: Translating domain elements | Thinkwise Community (thinkwisesoftware.com)Starting with the last releases of Indicium and soon available in the Windows and Web GUIs, a session variable is added that provides the language of the current user. This makes it possible to automatically generate a function that returns the translation of model objects in the user’s language. FunctionTo add this dynamic function to your Thinkwise application, first create a function subroutine named tsf_translate  with the following properties:Return value: scalar Return scalar domain: transl - nvarchar(200) Input parameters: type_of_object - int transl_object_id - varchar(100)  Control procedureNext, add a control procedure in the Function

Hi,Is there a setting to set the timeout of a step of a process flow or the process flow itself as a whole?If I try to run a very time consuming Process flow I get my application hang and need to refresh the page to continue using it, despite the error the process flow will continue executing in the background  in (Indicium). Any help or suggestion is appreciated. 

Is it possible to open a reference in its main screen from a reference in another table?For example: I want to open the main screen of ‘customer’ by clicking on the customer name in the table ‘task’. I know I can open a lookup screen using ctrl+L, but I want to open it in a new tab as a main screen.   

Hi, we are using both Windows as Universal UI in combination with Windows authentication.As we have users who only have a handheld device (phone or tablet), we wonder if those users would be able to change their (AD) password from within the Thinkwise application:on request on password expiration (set in AD)Currently the user is locked when the password expires and there isn't an option at that moment to create a new password.Thanks

Hello,I am implementing a resource scheduler and am using the extended property “DeleteAppointmentTaskScheduler” to delete appointments which works quite nice.However when i press the delete key when no appointment has been selected I get an index out of range error. Is there any way to prevent this error?Thanks in advance

We are trying to design a task that has a lot of arranged parameters.The problem we run into is that when the task starts the width of the dialog isn't calculated on the widest row of parameters, effectively pushing them to different tabpages.Same with the height.We can set the desired width of the dialog but in that case TW pushes a field to the next column messing up the layout.Hope my explanation is clear.. Pictures are probably a better way to show it :) When I manually resize the dialog all falls into place: Any ideas on how to do this? 

Hi,I am currently in a position where I would like to change the order of fields based on a selected input. In the layout cp you can set fields to hidden/mandatory based on a selected value.Is it possible to do the same for the order of the fields?Thanks

In a form I want to provide extra information for some columns. I don't want to have this information always visible in the form, only when the user needs the extra information. According to the feature matrix the tooltip feature is not working (yet) in Universal GUI. When will this feature be avaliable and what is the alternative? 

Hi,As the title asks is that possible?Can I have a custom Task button that opens a URL link on a new browser Tab ?Thanks

Hi there, I’ve created a label report in SSRS to print on a Zebra printer. When I run the report from SSRS the label is printed Ok. When I save the report in the SF and I run the report from the End Application (via the SF) the label is printed 10 times smaller then when I run it from SSRS report builder itself. What can I do about this??? See photo. The first label is from the SF. The 2nd one is from the SSRS report builder 

Is there anyone who knows how to solve this problem? The error message appears only for 1 person we currently know of.  

I’m trying to setup a connection between my application and the simple notification service (SNS) from AWS. This is proving to be troublesome because of the way AWS manages these subscriptions.To subscribe AWS first sends a subscription token to the endpoint (in indicium)  that will receive the SNS notifications. The endpoint in my application then needs to reply with the SNS-token to verify the subscription.To send the subscription token, AWS sends two messages: One without authentication and then one with authentication based on the header that is received in response of the first message.The endpoint in my application needs to respond to the first message without authentication with a 401 code with a header that specifies the type of authentication that is expected*: WWW-Authenticate: Basic realm=“<application>” .Indicium automatically responds with a 401 code and the header:WWW-Authenticate: Indicium realm=“<application>” Even when using a message protocol-independent w

Hi,we are currently investigating migrating our application authorization setup to IAM a configuration.As we'd like to check from the SF if a user is member of a certain IAM-role, we were wondering if there is a variable in the system which we can use to determine the location of IAM database.If not, we will create a value in a table to lookup this setting.Thanks.