Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Thinkwise Platform
Questions & Conversations

Questions & Conversations

Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community

2,708 Topics
9,319 Replies

When you subscribe we will email you when there is a new topic in this category

2708 Topics

Most replies

Most views

Newest first

IonutSidekick

asked in Questions & Conversations

Dropdown targeting variants slow loading

Hi!We have quite a few dropdowns which are pointing to variants and seems like for all of them once a few weeks we get them stuck on this "Loading...”.The strange part is that if you let it open and wait to dissappear, click again on the dropdown, the results are there.Do you have any idea what is going wrong? Is not for a specific table and some variants don't have anything fancy, just some prefilters. If we try directly with the table/view, the problem does not persist.

532

1 month ago

Dennis1690Sidekick

asked in Questions & Conversations

Get ID value from row

Hi, im trying to retrieve the parent_row_id from a newly added row. However @ and T1 both dont work. Anyone knows how I should fix this?select top 1 step_nr + 1from calculation_step--where calculation_method_id = t1.calculation_method_id «order by step_nr desc

506

1 month ago

Daan HeemskerkSidekick

asked in Questions & Conversations

Start flow with change filters and save filters / prefilters

I am trying to do something like this; According to the documentation change filters should not start an Universal flow, but it should start a system flow, and how else then a user changing the filters could a flow be started? So, what I try to do is not to use the step to change the filters but to get the result of the user doing so, but nothing happens.Am I missing something or is this just not possible?What I want is to know the selection so that I can apply the same selection to a report on the page, while the page is based on another Query.I’m also wondering if the report would be filtered when based on the same subject / table as the user is viewing?Being able to run a task on all the rows within the current selection ( not those selected by the user could also help ), as I manage to only output the report based on the users selection in the grid, but I would also like to create and option comparable to the export option; Daan

774

1 month ago

Robert Wijn 2Vanguard

asked in Questions & Conversations

No validation token after enabling 2FA

Hi,I am trying to enable 2FA bij selecting the login verification option “Password and TOTP token” in IAM. When I try to login with that account for the first time a dialog is shown with a QR-code to register. After scanning the QR-code from the authenticator, the App is registered and a TOTP token is provided. However no validation token is provided, which has to be entered next. I have tried this with Google Authenticator and Microsoft Authenticator with the same result. I have entered an existing e-mailaddress at the user level, but to no avail.Did I miss something that needs to be configured or has someone encountered the same issue and can provide me with a solution?I am using 2024.1

535

1 month ago

ElenaTodirenchiVanguard

asked in Questions & Conversations

Look up field not loading any data

Hello! In our project we have a task with some parameters that are completed by the user from the pop up. We put that task into a process flow, it’s the third step in the process, and when the pop up appears the fields that are references to another table are not loading any data. And also if you click on the look up icon is not loading any data even if in the table there are records.Do you have any idee what this can cause this problem? because when we are running the task from the table is not having any issues.

957

1 month ago

Niels KoopVanguard

asked in Questions & Conversations

Sum not updated when new item is added

Hi we have a table for invoices, and another table underneath it for the invoice lines. When we add an invoice line and press ctrl + enter, the sum of the invoice is updated. However, when we press ctrl + + the sum is not updated.So, the sum is only calculated after saving an item, but not when adding a new item. How can we make this work?

773

1 month ago

Joey van GentevoortApprentice

asked in Questions & Conversations

Issue with performing task on empty detail through odata api

When I try to execute a task on an empty detail screen as per the odata manual at OData API | Thinkwise Documentation (thinkwisesoftware.com) i get a 500 error. The Error in the live log is not very useful unfortunately and we are completely stuck on this. Any help would be welcome.The api call:{baseurl}/order_vbs(order_nr='1015007')/empty_detail_ref_order_vbs_kwartaal_gegevens_order/task_herrekenen_kwartaal_gegevensWe are not passing any parameters in the data json as they are not required for the execution of this taskI have checked (and double checked) the table names, reference, task name and PK ;)The line in the live error log:

916

1 month ago

SanderAdamVanguard

asked in Questions & Conversations

PDF viewer on Android not functional on Chrome

Hello everyone!We encountered a problem with the PDF viewer on Android's Chrome browser. It does not display the PDF-viewer, and we tested this on a more recent version of Android, and an older version of Android:Now this is what we get when we open it on Chrome. When we open it on a browser like FireFox, or Microsoft Edge, we get exactly the PDF we ask for. It shows the PDF viewer, on the newer Android and older Android versions. In the following release notes this should have been fixed: We have our web server settings set correctly as far as I know. So why would it still fail to show on Chrome? It does work on Firefox and Microsoft Edge. This is already good news, but we cannot predict what kind of browsers our end users will use.

704

1 month ago

Theo LeijenApprentice

asked in Questions & Conversations

BUG? Unknown error when tsf_send_message 'message',null, 1

I want the message to abort so i added the '1’When using '0’ it warns and everything is ok See also live error log Is this a bug?

1408

1 month ago

avanderveldenVanguard

asked in Questions & Conversations

Pie chart in Universal results in error

In the windows GUI, the pie chart "works”, but in the universal GUI it results in an error. I also tried to change the order & colors using conditional format. Without success. Is that not possible?

663

1 month ago

BlommetjePartner

asked in Questions & Conversations

Optimizing Lookup and Filtering based on selected values

Hi,I have a table named 'Activity' that includes a lookup to an 'activity_type'. Depending on the selected activity type, I modify the layout to ensure users input the correct values.Additionally, there is a lookup to a 'Carriage' table. Based on the activity type, I need to display either incoming or outgoing carriages, and filter these carriages to match the same origin and destination values, which are also fields in the 'Activity' table.Previously, I managed this by duplicating the 'carriage_id' field and displaying a different field based on the selected values. I then used a trigger to populate the original 'carriage_id' to ensure it is always set.This approach feels complex and cumbersome.Are there any more efficient methods to achieve this?Thank you.Blommetje

421

1 month ago

BlommetjePartner

asked in Questions & Conversations

Issue with Max no of rows: New Entries Not Displayed

Hi, For several screens I want to Implement the max no of rows. Say my Accounts table, ordered alphabetically from A to Z. When I add a new account with name AAAAAA, it surely displayed on the screen. However, when adding company ZZZZ it’s not displayed, resulting in the The saved data can not be displayed on this screen. SHOW -- snackbar message. What options do I have to work around this? A process flow with a Go to Row comes to mind.. But perhaps there is a more general solution for this? Kind regards, Blommetje

684

1 month ago

Harm HorstmanSuperhero

posted in Questions & Conversations

Rotate image files

Images taken with an iPhone are sometimes shown rotated in the previewer. I would prefer to see the previewer show the images correctly based on the metadata.But if there is a way to manually correct this from within the application, that would be fine too? I would like to create 2 tasks (Rotate Clockwise/Counter Clockwise) that can do this.In this case, it concerns a scenario within the Windows GUI and files are stored in the file system (Windows on-premise).Does anyone have experience with this?

1112

1 month ago

Harm HorstmanSuperhero

asked in Questions & Conversations

Optimize the behavior of the previewer for text files

We need a simple solution to show text files in the preview better than below.In dark mode the back ground color should be white or the text colors inverted.And is there any possibility to wrap the contents of a text file in the previewer? Any suggestions?

493

1 month ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

ODBC drivers in container package indicium

We are running [indicium] in containers and I have a question on the database connector. What are the available ODBC drivers? We need SQL server (obviously) and PostgreSQL And in the (near) future perhaps also Oracle. https://docs.thinkwisesoftware.com/docs/sf/process_flows_connectors#database-connector

542

1 month ago

SanderAdamVanguard

asked in Questions & Conversations

The task option 'Popup for each row' only updates one row after selecting multiple rows

Hello everyone, I have a task which needs to be able to update multiple rows in succession, in this case, the pop up for each row is the best option that gives the most readable code. Seeming in this screen, no large chunks of data needs to be processed at once. But I ran in a problem: when I select multiple rows and and this execute this task, it only updates one row. This task only contains one field to make sure we target the correct row in the database. Normally it is hidden, but I set it to read only to see how it would behave. This is how the task is set up: Await result was set to Yes (no progress bar) after this screenshot was takenWhen I execute the task in the situation intended for our end users, it behaves like the following:I select multiple rows on which I want to set the slider to the off positon via the task. But instead of updating multiple rows in succession, it only updates one row at a time, the first one I selected during that multiselect.When I set the field which

554

1 month ago

MehranRookie

asked in Questions & Conversations

/* Rename changed datatype image */

Hi, I'm seeking assistance regarding an issue I encountered during the creation process in Thinkwise Software Factory (SF) while executing source code. The error message I received is as follows:An unknown error occurred while executing '/* Rename changed datatype image */exec sp_rename 'image', '__image__', 'userdatatype''.Error: 'This action cannot be performed on a system type.'.It seems that the error is related to attempting to rename a system-defined datatype, which isn't allowed in SQL Server. This occurred specifically in the "Creation Process" under "Execute Source Code."Could you please provide guidance on how to resolve this issue and ensure that the creation process can be completed successfully?Thank you for your support and assistance.

382

1 month ago

Mark_PlaggenborgHero

asked in Questions & Conversations

Will the "Filter expression" find its place in Universal as well?

Having worked several years with the Windows GUI, I have gotten quite accustomed to the use of the “Filter expression” for certain cases. For the customer product it was not a standard option I would have explained to my users, but they did solve certain search situations for the more advanced. A very powerful tool actually.What is the likeliness this feature will find its return in the Universal GUI?Mainly also as the route for the SF is to be the Universal GUI and not the Windicium GUI that was mentioned several years ago. The reason I was not asking before as I was awaiting that last to make its appearance. Pressing the little arrow down made it availablePossible to filter several conditions like a Boolean function Able to also input it as a text (which you could use to recreate the filter as it never got a feature to save these).

482

1 month ago

Harm HorstmanSuperhero

asked in Questions & Conversations

Start process flow on field exit

Is it already possible to start a process flow when leaving a field a form in edit mode and auto-commit enabled?I searched in documentation for this and did not find anything.

366

1 month ago

SanderAdamVanguard

asked in Questions & Conversations

Hidden prefilters suddenly showing up

As strange as it may sound, I have two prefilters set to on_hidden and off_hidden respectively, but when I click the not hidden prefilter, the hidden two suddenly show up. This seems to happen in the variant of a a table. The following screenshot shows how the prefilters are set: When the user goes to the right screen, they see the following:There is only one prefilter beside the search bar. But when the user clicks the prefilter the following happens:I do not know why it behaves like this, I have checked the context procedure and we do nothing in those with prefilters. And it does not have a layout procedure. What could be wrong?

443

1 month ago

Stan WoltersRookie

asked in Questions & Conversations

Scatter plot with dynamic x-axis and y-axis

I was wondering whether it is possible to visualize a scatter plot within Thinkwise cubes? If so, which chart type should I use? Furthermore, I want to be able to set up the x- and y-axis dynamically such that they are always at the average level of the value specified on the x- and y-axis (see picture below). Is this possible?

623

1 month ago

HJ van DalfsenSidekick

asked in Questions & Conversations

Universal file upload security

Hi,We are searching for a secure file upload solution in a customer portal (universal GUI). Has someone experience with this to have a secure file upload that no infected files or malware files are uploaded to the server? Initially, we created a process flow, mailing the file as attachment, and then reading out the mailbox, so that there is at least a check via the mail. But that takes some time and is not clear to end user why the uploaded file is not immediately visible.So we are searching for an alternative approach.Thanks in advance!

904

1 month ago

Dennis1690Sidekick

asked in Questions & Conversations

During deployment Column isnt deployed making the check script fail

As the title states, im running a deployment in which a column should be added to the upgrade script. However it doesnt upgrade the table with the new column. This results in a failed deployment.What I did:Validate, Run full creation and smoke test my development enviroment. I made sure the column exists and works.Validate and check my Full create script in development. This contains the new column.Set the correct SF_model_infoDeployment packagerun the deployment. Added the log for reference. Thanks in advance

362

2 months ago

Alban_TCaptain

asked in Questions & Conversations

how to debug issue with Crystal Reports report?

In my TW application I use several Crystal Reports reports.The customer sent me a new version of the report, other than the rpt file and 2 additional parameters for the stored procedure used by the report no big changes.I've replaced the original report with the new report and added the 2 new parameters.When I try to open the report from the application I keep getting: Other reports work correctly, just this one report is being naughty :) :(

1088

2 months ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

performance tree universal GUI

For one of our customers we are trying to populate a tree view with 29800 nodes. It feels sluggish. The base query takes 1 second. How can we investigate further where delays are coming from?

15310

2 months ago

Page 4 / 109

Badges

avanderveldenhas earned the badge Transcriber
Tim Waalewijnhas earned the badge Problem solver
sven.neuteboomhas earned the badge Geek
Arjan Solliehas earned the badge Transcriber
Arie Vhas earned the badge Advertiser

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login to the Thinkwise Software Community

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

Enter your email address

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.