Propose your fantastic ideas regarding the Thinkwise Platform to our Product Team.
In Windows GUI, the translation is used for detail tabs, incl. case sensitivity In Universal, are only CAPITALS used? Why? Please make this consistent with Windows in order to comply with our styling guidelines
The good part about working the the Thinkwise platform for quite some years now is that you build up a lof of reusable parts. However it is very difficult to extract reusable parts from a model, export it and import it as a reusable base model. Two main ideas:Most basic, export model for environment A and import in into environment B, if the base models are not available in the new environment import fails. Also when a base model has a different name. In this case in both environments the date_helper was downloaded, however in one it had a different name. More powerful, and if you really want to become a 10x developer ( @Arie V ) is to have the ability to export a part of an existing model to reuse in a different model or even better create a base model of it. Now it's pure manual labor to or remodel the things you want in a new model, or copy the whole model and clean up the parts you don't want. All manually. Being model and relation driven, a nifty solution to pick a table, a menu item or starting point as such, and determine everything you need to export everything that relates to it. Another thing I would love to see is to have a function/procedure repository. The overhead of the Thinkstore model download is too large. You end up with 50 base models, all with 1 or 2 functions/procedures etc.. that do generic stuff. Would be great if for example the functionality/subroutine parts could talk with a type of github repository that could be forked. No need to import full models, just reusable pieces of SQL code.
Quite often users need to upload multiple files from Windows Explorer and/or Outlook (attachments). I wish there was something like a ''Multi File Upload" control, with drag & drop, that enables this. After this I like to handle each incoming file with a process flow. Or is there already a workaround, to achieve this?
As an IAM administrator, I want to see the last and next scheduled runs directly from the list of available system flows, so that I can quickly understand the execution timeline and sort flows by these dates for easier management.Additionally, I would like a dedicated screen (e.g., "Scheduled Runs") to view all upcoming runs across all system flows, so that I can gain a complete overview of future runs for the next day, week, or month without having to check each system flow individually.This will significantly enhance usability and provide better insights for managing scheduled flows.
In the list Scheduled systemflows I am missing a few columns that could make life a bit easier. The query to show the list already has the fields I am looking for, but the GUI doen't show them. I am talking about Schedule_id, last run and next run to be added to the list. These columns combined with a pre-filter like “Unscheduled flows” would make it much easier to find jobs that may need attention (an active schedule for instance) or may be marked as no longer needed for a next release of the application…. Query result of non scheduled jobs Query result of scheduled jobs
I would like an option to invoke the standard import functionality through a process flow or another method. Currently, the import/export function is hidden behind the three dots, making it difficult for some users to find. It would be great if this functionality could simply be started from a regular task.
Having search and pre-filters together, it makes much more sense to move the filters also to those 3 dots And maybe also manage prefilters
I have made a Conditional layout rule that highlights values in the (nullable) Year end and Year end old columns if they are different, the condition being specified as such:This produces the following result in the application. I think it is unintuitive that the two null values get marked as Not equal to each other. I understand this is how sql works, and I think it would be useful to allow tsf users to specify that null values should be marked as not equal to each other.This could be done with a manual null check:t1.year_end = t1.year_end_old or (t1.year_end is null and t1.year_end_old is null)for Equal to, or simply something like isnull(t1.year_end, '') = isnull(t1.year_end_old, '')This option to enable Null value comparison in this way would be toggleable with a checkbox.
Currently text parsed to the parameter is handled straight as given. In some cases when you would show there some text like name of a company having special characters, then the message is not coming properly.When for example giving the input ‘<text>ROLLER Gmbh & Co. KG</text>, then the message comes incorrect showing like:To make it correct, you have to replace the '&’ with '&amp;’ before parsing it to tsf_send_message.Would be good if these special characters are handled within the tsf_send_message. Otherwise you have to implement a custom procedure as wrapper to do the replacement
I try to manipulate the filename of a SSRS report by with a default procedure, but it seams impossible.The file path is not accepted, the filename colors red and an error message occurs: What is the right approach to achieve this?In addition I like to mention that in the WebGUI I am not able to change the filename of the generated PDF report with the default procedure.For example to add a time stamp in the file name. (e.g. 20230628_083405_WeekReport.pdf)The documentation is also not clear, the property names do not match and it is not clear what is the difference between the properties File Path and Export PathFile specification = File Path ?Export location = Export path ?
In the past the filters in the role screen in the Software Factory worked different than how they currently work. When you would enable the prefilter “Read only rights” it also displayed the objects/tables for which you had set more than the read rights, for example update or insert.Currently those tables are only shown when you enable the prefilter “Full rights”. I can understand that you would like a prefilter that only shows table/object for which the read rights checkbox is checked and the insert, update and delete are disabled.However quite often I would like to filter on tables for which at least rights are checked. Currently this can only be done by manually filtering on the read checkbox.Could you please reintroduce a prefilter that shows all tables for which the read checkbox is enabled?
Would be very helpful to have a filter: has rights.There is a filter: full rights and a filter read-only rights. But a filter has rights (might be full, might be read only), would be helpful.
Currently after running a Platform upgrade the indexes on the IAM are fragmentated. This is the result of pushing the new IAM and/or SF model into IAM. Without executing a TSF optimize to rebuild the indexes and statistics, the loading of my applications is not as fast as it should be.I would like to see the TSF optimize step as a part of the Platform upgrade itself, instead of having to run it manually.After synchronizing the model into IAM, it should also optimize the indexes. This in order to prevent a performance issue.
I found 2 problems with the tsf_user function;If I use the function as DBA (with a direct login to the database) the function gives a guid. The function can confuse the SQL-Server query optimizer with the result that the function gets executed multiple times.As a workaround I replaced the function by a view, which checks if the CONTEXT_INFO value isn’t a GUID, and an additional check whether the user returned is actually present in our user table.I did not investigate what it would do with the performance when I made the function schema bound, but the view is much faster… and I think that making the function schema bound might give the same result. ( It would not bind to anything, but SQL-Server might understand that there is no need to evaluate the function more then once ).
This idea came into existence from this idea: Just like user-defined prefilters, I’d like to see user-defined/persistent pinned columns. This could be setup the same way as how user-defined prefilters are setup; in the User Preference in IAM.Currently when a user sets pinned columns on a table/view, this will not be remembered and the next time the user opens the table/view, the user will not see the column pinned anymore. This is by design, however I’d like the option to keep them 😁
When you are working towards a release of your application there are a few things you need to check/set up. Most of these steps are included in the deployment screen of the Software Factory. However, the data migration screen is currently missing from this.This should either be included in the Creation menu group or even better be included in the deployment pages/steps. Currently this step is often forgotten/missed resulting in deployment issues.This also applies to the New objects screen, please also see this idea:
Automatic data migration between branches when renaming tables / columns | Thinkwise Community (thinkwisesoftware.com)This comment is very true, however not every upgrade has relevant data migration information. And since it is a separate screen apart from the creation proces, it is easily overlooked.Therefore I suggest to include the data migration screen as a tab in the creation screen (before or after the validations). It could be disabled/hidden when there is nothing relevant to show (for example only new tables/columns that are not mandatory), or a badge could indicate the number of rows with relevant actions worth checking.
When you are working towards a release of your application there are a few things you need to check/set up. Most of these steps are included in the deployment screen of the Software Factory. However, the “New objects” screen, meant for configurating roles based on model changes, is currently missing from this.In the 2025.1 release this screen will be improved and included in the menu group Creation. However, this new screen should be included in the deployment pages/steps. Currently this step is often forgotten/missed resulting in deployment issues.This also applies to the Data migration screen, please also see this idea:
To enable end users to work more efficiently in applications, tool tips can make an important contribution.Such functionality is already available in the scheduler, but this would also be a valuable feature for grids, forms and card lists.For example, full information of an asset can be given, while the only the code of an asset is shown in a maintenance list. A shortcut/link to the asset screen could be part of the tooltip.Simply put, I would like to capture in the column definition the name of a function that returns an HTML output that will be displayed as ToolTip if the cursor is on the field for more than 2 or 3 seconds. By on-demand executing the tooltip function, filling grids and forms can remain fast.Input parameters of the ToolTip function:tab_idvariant_idcol_idrow_id (= PK field values of selected row)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.