Questions & Conversations

Hi,I’ve created a context control procedure, and executed the definition in the database. But now I don’t need this procedure anymore, and deleted it in SF.Do I need a new Creation->Execute source code to get rid of the procedure in the database? Or is there a quicker option?

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalBased on a customer story.Every day at 06:45 a procedure runs for the customer and during that procedure, errors can occur. These errors are recorded inside the application and viewed by one particular user. This user only opens the application to look at these errors. If there are no errors at all, the user still has to look inside the application to find out. It would be more handy if the user gets an e-mail with a Report of all the errors. SolutionBy using the System Flow functionality, we can autonomously let Indicium take care of generating a Report and sending it to the user by e-mail.In this example I will show you what is needed to achieve this.Prerequisites:Indicium (Universal) - hereafter called Indicium Application in IAM SMTP server for sending the e-mail - this example uses a free SMTP server by sendinblueChaptersCreate a View in the Software Factory Create a DevExpress R

hi,we are using a treeview with drag n drop, but when clicking sometimes twice on 1 entry, the description field is ‘open’. It’s not editable though, but you have to click outside the box to exit. Can this behaviour be set somewhere?  

Hi,As per the subject question: Is it possible to have multiple instances of the same Process flow running in parallel by calling it as API? I want to be dynamically calling the process flow as API to start as many instances as needed to handle the full set of records. Each set will be assigned a group number to identify the different set, and this will be passed in as input to the API call for starting and processing the group set. If dynamically starting of multiple instances of the process flows is not possible I will be forced to create a dublicate of the same process flow hardcoding each group set and will not be able to dynamically call as many as I configure. 

Hi!I was wondering where the accent color in the universal theme gets applied. I am unable to find the color set as the accent color in the Universal GUI. I'm only able to see the red main color.Unfortunately the documentation does not give any examples.The accent color is set as Lime.The main color is very present and can be found in many places.  

Web GUI:After using a tab with Auto Refresh enabled other tabs and even menu’s keep refreshing:When editing, the text is selected every auto refresh, making it hard for users to type longer texts. The right-click-menu disappears every auto refresh.Auto-refresh should be limited to only the tab where enabled.

We have multiple clients using our software, and some of them may have a different version in production than other. In some cases, there is the need for data conversion because of new functionalities or restrictions. We encounter some risks when upgrading from different versions i.e. we have one client that is currently on version 6.300 and one on a slightly higher version 6.301.We developer our conversion script for version 6.400, and place it in a certain folder. However, this come with some risks and we would like to manage our conversion scripts in the SF.We already use the UPGRADE code group for scripts that have to be executed every upgrade, but in this case we need a script that will be executed in every upgrade that encapsulates version 6.400.So in our examples, an upgrade from version 6.300 to 6.400 should have the script, but also from 6.301, or even if we skip version 6.400 and go straight to a 6.401.The UPGRADE code group can be used to manage data conversion scripts for s

I have set-up a white list of file types that are supported in the file storage:However, this only works afterwards. Users can set other extensions during the import and will receive an error message afterwards. Edit by moderator - Please keep the Community posts in English ik heb bij de file storage een white list opstellen van bestandtypes die ondersteund worden:https://docs.thinkwisesoftware.com/docs/sf/overview#file-storage---allowed-extensions Echter werkt dit wel maar alleen achter af. Gebruikers kunnen wel andere extensies instellen tijdens de import en krijgen dat achter af een foutmelding. 

We have updated our desktop and webgui to 2022.1.19. The old webgui was 2022.1.16.We have a problem with the webgui.When using ctrl + to add a new record without saving the previous record, several fields ar not visible anymore, where they were in the old webgui. We checked the lay parameters using the debugscreen, and the fields should be visible according to the value of the parameter (@jrn_debiteur_type = 0 and @jrn_debiteur_mand = 1).  In the Windows gui the fields are correctly shown. Also, when we first save the previous record, and then add a new record, there is no problem. In the old webgui we also didn't have this problem. Looks like a little bug to me?

How to set focus on a specific row even after inserting a new row in a table?

Hello, I created a task that insert a row with values from table A in table B. It is possible to auto refresh the table B, so the changes to be visible after inserting, without doing a refresh on the screen?

Is it possible in IAM to change for all users in go; Set password expiration policy Set pass 'Allow Change’ checkbox Set Theme (I have a testing environment and want to make sure the end user sees this very clearly with a very different color scheme) 

how can i view the Http request content in a proces flow monitor?   

I have an issue with the DeleteAppointmentTaskScheduler. It works fine with the SF-model, but I can't get it working when I use the application in IAM. Checked:Same GUI (2022.1.18). Extended property set in SF (not overruled in IAM, and not in ini-file). Model rights for the task, parameters and tab task. The task can be used directly from the table.  Database rights (execute task).  Special charactersWhat else? 

Hi,Is it possible to create a varchar domain that has a specific regex pattern? Like a dutch postal code, having space between the numbers and letters. Or is this only possible by changing the entered value with a Default.

hi, When creating json messages for a 3rd party API, we use SQL to create the json structure. This json message has > 100 fields, and most of these fields are in our datamodel. But, of course, our column names do differ from the API fields, so we have to alias these fields in the procedure.Is there a way to have our column names following the TW naming convention, and register the API field labels? I see columns have alias property in the data domain, can we use this? 

How i can make a task by deafult to be disable and only after selecting a specific row to be enable?

Hi. I created a chart for the past 2 months..  and a few things:I have a date column, which is shown as a timestamp (date_time).. why? Looks like a bug.  When you create a chart, the SF creates date groups.. these don't work with the Universal it appears.. it just gives errors when you want to use them.   

I am trying to send an email to the employee through SMTP connector in a process flow. It works fine with constant value as input (To Recipient) field and receiving the email too. When i tried input with process variable as expression, it is showing error, status code -1. How can i make it work? In my use case, each time the email id will be different, that expression should pick the correct email id but it fails to do so. 

Hi,In the use log in IAM I can see the use_log_sessions by many users.Only 1 user does have use-log_actions?How can I turn on the logging for other users?And can I query the number of times a task is used by a user?I can see some data but this is more than 1 month ago.  select * from use_log_usr_action where project_id = 'serp'and usr_action_type_id like '%task%'and project_vrs_id in ('1.54','1.55','1.56','1.57','1.58')order by date_time desc

Hello everyone,I'm trying to realize the following; upon log on of the user, the user gets presented a more or less personalized dashboard. The dashboard contains, among other things, a list of notes (made by other users) that are assigned to the user.In order to get this done, we need to execute a process flow or system flow that fires a tsf_notify at some point. Is there a way to fire a flow when a screen loads or is loaded? Is there some "done loading" event that can be observed or hooked into? Can a screen, for instance, be configured for auto refresh, as a refresh event can fire a flow. We could make the flow stop the refresh, so the refresh only happens once. Just a thought.What would be the proper way to go about this?Thanks in advance,- Alex.

Hi,An 3rd party API gets us a JSON with a base64 encoded file which I can save in a varbinary field. Now this file contains specific text we need to extract, and this is possible by saving the file first to a temporary location, and then use process action Readfile to get the content in a process variable and then process it in a stored procedure.Can this be done without the temp saving of the file? It feels like i’m using 90’s technique 😉 but I cannot find any suggestion in documentation or community for decoding the file on-the-fly. 

Hello all,In our program we discovered that a column should have been mandatory but was not selected to be in the SF. This has been fixed in a later version by simply making the column mandatory, and we wanted to try to use the Data conversion functionality to fill in the missing data. The following expression has to be used for filling the column, and this has been selected in the SF as well;isnull(t1.calculatie_soort,(select ws.standaard_calculatie_soort_id from waarde_standaard ws))However, when generating the code for this upgrade, we found out that the SF generates a faulty statement when inserting the data from the renamed table; t1."product_type" as "product_type", t1."calculatie_soort"(isnull(t1.calculatie_soort,(select ws.standaard_calculatie_soort_id from waarde_standaard ws))) as "calculatie_soort", t1."per_1_of_100" as "per_1_of_100",As you see, unchanged columns are fine, but our change column "calculatie_soort” now causes an error, as bot the "normal” co

Hi all,when executing the “tsf_send_message” function I get 2 diffirent design of the message box.For context, in img 1A. I use a custom made message named “warning_msg” in a DEFAULT control procedure which return the design shown in img 1B.img 1Aimg 1B Now I use the same concept of the “tsf_send_message” (img 2A) in a TASKS control procedure but as we can see in img 2B, it uses a diffirent design. I think it uses the browser default message.img 2Aimg 2B I would like to use the same design accross all procedures. Please help!Thanks.

Uploaded images are displaying unevenly based on its resolution. Do we have any option to make it fit to size?