Product updates
Ideas
Groups
E-learning
Documentation

Community
Thinkwise Platform

Thinkwise Platform

Questions, discussions, news and updates regarding the Thinkwise Platform.

1419 Topics

Recently active

Most replies Most views Newest first

Hugo NienhuisHero

asked in Questions & Conversations

What could be the reason that the DeleteAppointmentTaskScheduler is working with the SF-model, but not in IAM?

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?

4 days ago

Dennis BeerenVanguard

asked in Questions & Conversations

How to display percentage in the UI (when value in DB is in decimals)?

I am looking for a way to display a percentage in the UI, while the column contains decimal values in the database. E.g. 0.51 in database displays 51 in UI.I expected that the domain control field 'Percentage’ would do the trick, but it doesn't. The documentation is not very specific about what the Percentage control does when it is selected in a domain:I cannot be the first to deal with this issue, hence I hope that somebody here can point me in the right direction.Thanks in advance!

4 days ago

Marco KleiwegSidekick

asked in Questions & Conversations

Business Intelligence - Repeating data on each row in cubes.

How to ensure that data is displayed on each row instead of suppressing duplicate data.So in the example hereunder I want to have “AVE” on 10 times instead of 1 time.Who can help?

4 days ago

Tejo van de BorSidekick

asked in Questions & Conversations

Use regex in domain to create specific entry

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.

5 days ago

Tejo van de BorSidekick

asked in Questions & Conversations

Creating json message with column alias

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?

5 days ago

Sulea EmaRookie

asked in Questions & Conversations

How to make a task button by deafult to be disable ?

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

5 days ago

John SevartsRookie

asked in Questions & Conversations

Auto refresh in Web GUI causes refresh in other tabs / menu's

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.

5 days ago

Jefferson DelacruzApprentice

asked in Questions & Conversations

How do I by default zoom out resource scheduler when opening for the first time (in Web GUI)

Hi everyone, I was looking for a way for web GUI resource scheduler to zoom out the times scale showing 8 months instead of 7 by default. I checked the documentation and the full model module in SF and I found the zoom factor under the web and windows setting in the extender, but they work differently from each other. In web its designed to be Boolean implying we are only enabling the feature and, in the windows GUI we are giving instruction what level of zoom are we requiring. Is there any other way of zooming out the time scale for the web GUI?My current Time Scale I don’t find any difference after i enabled this option

6 days ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Universal - Chart - Date bug .. why is it showing timestamp instead of date?

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.

8 days ago

UshaApprentice

asked in Questions & Conversations

SMTP connector fails in process flow with process variable as expression

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.

9 days ago

Edwin SaanSidekick

asked in Questions & Conversations

Use log IAM only 1 user

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

10 days ago

Mark LeunissenApprentice

asked in Questions & Conversations

How to abort a failed synchronization to IAM?

Hi all, I have a question concerning a failed synchronization to IAM. As can be seen on the image below, the synchronization to IAM has failed on the step ‘Synchornizing: project’. However, it doesn't seem possible to abort the failed synchronization. So, how do I abort a failed synchronization to IAM.I have tried to cancel it via maintenance → jobs, but this doesn't seem to work. Additionally, in maintenance → Jobs, the ‘active job’ isn't listed as an active job (second image) Thanks in advance. Failed synchronizationNo active jobError

10 days ago

Alex KerschkampApprentice

asked in Questions & Conversations

Execute process flow upon loading screen

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.

10 days ago

Tejo van de BorSidekick

asked in Questions & Conversations

Get file content without temporary saving file

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.

10 days ago

kensonlatchmansingSidekick

asked in Questions & Conversations

Import Issue Universal GUI

Hi all,I am trying to import data using a excel sheet in Universal GUI, but am running into a problem where the existing records won’t update. Context: importing data in a detail screen.Steps taken:export data using option “Export immediately” changing some fields in excel > save excel sheet import using the “Import (update existing rows)” option. Also noticed that it doesn’t update but rather add the rows again.Please help! Thanks

10 days ago

Thomas OfmanApprentice

asked in Questions & Conversations

Possible error in data conversion using expression

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

11 days ago

Thomas OfmanApprentice

asked in Questions & Conversations

Handling data conversion with multiple versions

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

11 days ago

kensonlatchmansingSidekick

asked in Questions & Conversations

Message design differ

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.

12 days ago

Page 1 / 57

Badges

Freddyhas earned the badge Publisher
Erwin Ekkelhas earned the badge Superhero
Sjors Niestenhas earned the badge Blogger
Mark Jongelinghas earned the badge Blogger
Jeroen van den Belthas earned the badge Problem solver

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login to the Thinkwise Software Community

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.