Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Topics started by Jeroen van den Belt

41 Topics

Most replies

Recently active Most views

Jeroen van den BeltAdministrator

published in Questions & Conversations

Survey closed, see topic for results: using the Model content (Full model) screen

IntroductionThe Software Factory provides a menu item where it is possible to access screens related to a large part of your model, named “Model content” (formerly “Full model”).Because these screens are not shown in the context of a particular process, all available data in the screen is shown. This results in a lot of tab pages that display a lot of information.These screens are also present on another place in the SF, where the are optimized for the process they are part of. Think of:Data model > Tables: when you want to create a new table. At this stage you don't need to worry about the UI aspects of the table. User interface > Screen types: when you want to change a screen type. This screen contains a handy designer which can be used to visualize what your screen will look like. Processes > Tasks: when you want to introduce a variant for a task. The screen type here is set up hierarchically, which means there will be enough space to work with when a variant is introduced.

Jeroen van den BeltAdministrator

Or prefiltersCompleted

Selecting multiple prefilters now always leads to: where [prefilter 1 query] AND [prefilter 2 query]. I would also very much like to have the possibility to make OR prefilters. Not only between columns (colour = red OR shape = square) but also within columns (colour = red OR colour = blue OR shape = square).

Jeroen van den BeltAdministrator

The effect of granting rights to an objects on its childsOn the backlog

A number of wishes have been submitted in TCP concerning adding rights to an objects.They indicate that when rights are granted to an object, they must also be granted to its childs. Same goes for revoking these rights. I was able to extract the following situations:Rights for a table should pass on to its columns Rights for a task should pass on to its task parameters Rights for a report should pass on to its report parameters Rights for a menu should pass on to its menu items Rights for a process flow should pass on to its process actionsA number of questions about this wish:What if a new column / task parameter / report parameter / menu item is added after setting up the rights? If you give a table rights because you need a column look-up, you now only get the display. Should this change? Am I still missing situations that should also be taken into account for this wish? Personally, I think that when adding a table task, for example, it is going too far to give rights to both the ta

Jeroen van den BeltAdministrator

Save your own prefilter queries / filter expressionsOn the backlog

Using UP, it is already possible to create and save your own prefilters, by entering values for the available columns in the table. This always leads to an and-based prefilter, which has limited options. I would like to be able to make my prefilters by writing a query or by saving my filter expressions. This way you can also make your own or-based prefilters, use subqueries or joins, etc.

Jeroen van den BeltAdministrator

Being able to automatically assign a validation to a developerClosed

Sometimes we agree in my development team that specific validations should always be solved by the same developer. In that case we run the validations and assign them to the right person, using the assign task. Would you be interested in the idea to be able to arrange this in advance? We could add the developer field in the validation --> maintenance screen. When this field is filled, the validation task automatically assigns this validation to that developer. Of course you must be able to deviate manually afterwards for exceptions.

Jeroen van den BeltAdministrator

Filter in treeviews without losing parent nodesOn the backlog

Let's say I want to apply a manual filter in the following treeview, so I can see all validations assigned to me. This will lead to the following structure: I would very much like to be able to keep seeing the parent nodes, leaving this full branch of the tree intact. This way you never lose the structure of your treeview out of sight while filtering.

Jeroen van den BeltAdministrator

Show source for generated objectsCompleted

Sometimes you want to makes changes to generated objects, for example the code of a generated control procedure or validation. You can't see from which source these objects are generated. This can be from the dynamic model in the project version you are working in, or from a linked base project. How ideal would it be if you could see in one instance from what source a generated object like this originates. This way you can directly make your adjustments in the Software Factory, without having to query on the database in which projects the generated field for this object is empty.

Jeroen van den BeltAdministrator

Make it optional to include inactive control procedures when performing a code searchCompleted

When searching for code in the screen 'Code search', inactive control procedures (and their templates) are always included. Most of the times, however, I want to search/analyze impact in active control procedures because they have an actual effect on your end product. Results for inactive control procedures then only distract me.I propose to add a new checkbox to this screen, making this an optional feature: "Extend search to inactive control procedures". This checkbox should be empty by default, in my opinion.

Jeroen van den BeltAdministrator

Provide the result column of a function with an identity valueOpen

In SQL server you can provide the result column of a function with an identity value.The idea is to make it possible to model this in the SF. Reported on behalf of @Robert Jan de Nie, credits goes to him.

Jeroen van den BeltAdministrator

published in News & Blogs

Detecting identical aliases in your SQL join- or where clauses

Hi all,Who hasn't experienced this? You're testing your SQL code, only to discover that you're getting more results than expected. In some cases, accidentally using the same alias within the same join- or where clause can lead to this scenario. For example, “where t1.customer_id = t1.customer_id”. This effectively creates a condition like “1 = 1”, which is always true.In this small blog, I'll guide you through detecting this situation throughout your branch's codebase. To effectively follow this blog, you'll need access to a code editor that has built-in support for regular expressions. If anyone knows a more efficient way to achieve the same results, please share it in the comments. Hopefully this helps!Software FactoryGenerate the code files using the Software Factory:Start up your Software Factory. Switch to the desired model and branch, for which you want to check identical aliases, by starting the task Models > Switch branch. Go to the screen Deployment > Creation. Generate

Jeroen van den BeltAdministrator

🔥 Hotfix - SF 2019.2 - Breakpoints for screentypeshotfix

In the 2019.2 release we have added the invalid character check/replacement to screentypes. This also led to breakpoints (<) being incorrectly replaced. In this hotfix an exception to this character has been made, so that breakpoints can be used again. Other invalid characters will still be replaced with an underscore.

Jeroen van den BeltAdministrator

🔥 Hotfix - SF 2019.1 - get_gui_tab_variant_col performancehotfix

A new hotfix has been made to improve the performance in some situations when starting an end product against the Software Factory 2019.1. Technical: adjustments were made in the stored procedure get_gui_tab_variant_col.

Jeroen van den BeltAdministrator

🔥 Hotfixes for week 43hotfix

Hi everyone!We’ve released the following hotfixes for 2021.3 platform version:SF 2021.320211029 - Corrections in creation process The task to run a complete creation now waits for other jobs to finish, no longer result in the possible failing of a creation. When a project version was upgraded, the question is now asked again if a new project version should be created. The process flow responsible for focusing on the active definition generation step has been made a little bitt less aggressive, leading to a better user experience. 20211027 - Corrections in creation process A possible situation where the upgrade script was not automatically checked does not arise anymore. There no longer is a specific situation where it might appear that executing a new project version to the database succeeds, when it actually doesn't. Some other minor improvements. IAM 2021.320211029 - Corrections in creation process We've been getting several questions on how to deal with messages stating that a j

Jeroen van den BeltAdministrator

Setting for confirmation when a task has completed successfullyOpen

This idea focuses on a new setting for tasks. This settings would allow you to indicate whether you want to receive confirmation that the task has run successfully after its execution.For some tasks you just want to be sure that they have been run completely and successfully. It would also be ideal for situations where you work on some other things while the task is running. You will then be notified when it is completed.Currently, this can be achieved by writing additional code or including the task in a process flow. I would prefer to have a formal setting in the model to do this.

Jeroen van den BeltAdministrator

Difference comparison between a variant and its base table/other variantsOpen

It regularly occurs that I can't figure out why a specific variant has been made, especially when no meaningful variant name has been used. It can be a lot of work to distinguish the differences with the table it's based on, or with other variants, in order to determine whether its existence is still justified.For this reason I would like to be able to execute a automatic comparison between a table variant and the table it's based on or with another variant for that table.

Jeroen van den BeltAdministrator

Include some more data when saving cubesOpen

This idea is created on behalf of some of our users, combining their ideas into one.When saving a cube view as an UP cube view, it would be desirable to include some more data/settings:Prefilter state: for example, a detailed overview of hours will often cover the last period, where a trend analysis will cover several years. When you are always interested in the trend analysis, you have to activate the prefilter yourself every time. Active filters: any manual filters should also be saved. Selected print options: a user now has to reset these with every print. Expansion of rows: the rows are always expanded when working in the cube view, even when the rows were collapsed when the cube view was saved.

Jeroen van den BeltAdministrator

Code search using multiple search strings, matched using AND/OROpen

I'd like to be able to perform a Code search in the SF using multiple search strings, instead of the one string we currently provide. I'd also like to specify if the search should match all (AND) or match any (OR) of the conditions.Example 1:Search for code that contains “model_id” AND “branch_id”.Example 2:Search for code that contains “status = ‘planned’” OR “status = ‘in_progress’”Should you have any thoughts on how this should be presented in the UI, considering the available space in the screen, please reply in the comments.

Jeroen van den BeltAdministrator

🔥 Hotfixes for week 12hotfix

Hello everyone!We’ve released the following hotfixes this week:SF 2019.2 and up20210317 - Fix variant join in i_ui_tab_cube_view In the Universal GUI, when Show cube view is turned off in the variant, this cube view will no longer be shown. SF 2020.1 and up20210325 - Tinyint in system versioning When a new column is added to a table that is system versioned, the actual system versioned table also gets the new column. The value this new column gets depends on the datatype. We fixed an error that a new tinyint column would get '-1' as default value. A tinyint cannot contain a negative value, so we changed this to '0'. SF 2021.120210323 - Role column sync performance fix The process of synchronising to IAM has been increased in performance. 20210326 - SF DB to Azure Some code is fixed that resulted in errors while exporting or backing up a SF database to Azure. This has not changed the functionality of the code, but just works around some SQL Server Management Studio issues. Enjoy your we

Jeroen van den BeltAdministrator

🔥 Hotfix - IAM 2020.1 & 2020.2 - System flow correctionshotfix

A hotfix has been been made for IAM 2020.1 and 2020.2. It corrects 2 system flow situations: The gui_appl_system_flow view is altered, which makes it possible again to disable system flows. An index has been added to process_flow_schedule_log. This index prevents a table scan which could cause locks. The index now forces a seek instead.

Jeroen van den BeltAdministrator

🔥 Hotfix - SF 2019.1 to 2020.2 - Determining active runtime configurationshotfix

Recently we introduced a new GUI feature, which was also highlighted in the SF 2020.2 release notes: see this URL. When no project, project version and runtime configuration are provided in the INI-file, the Windows or Web GUI will load all active runtime configurations for the current user from the Software Factory. This hotfix improves the way of determining what is an active runtime configuration, preventing too many runtime configurations from getting started by the GUI. The conditions for an active runtime configuration are now: The project is a work project The project is not a base project The project version status is not ‘Inactive’

Jeroen van den BeltAdministrator

🔥 Hotfix - SF 2019.1, 2019.2 & 2020.1 - Performance Get GUI for table variantshotfix

A new hotfix has been made for the SF 2019.1, 2019.2 and 2020.1 to improve the performance of the Get GUI for table variants. This will speed up the start-up time of your end products.

Jeroen van den BeltAdministrator

🔥 Hotfix - SF 2019.2 - Rename/delete table task with data setshotfix

A hotfix has been made for the SF 2019.2. It was not possible to rename or delete a table using the corresponding task, when the table was used in a data set. This has been resolved with this hotfix.

Jeroen van den BeltAdministrator

🔥 Hotfix - SF 2019.1 and 2019.2 - Task delete messagehotfix

A new hotfix has been made for the SF 2019.1 and 2019.2 to fix the delete task for messages. When a message was used as a confirmation message for tasks, deleting the message would also lead to the task being deleted. Deleting a message will now no longer delete the associated task, but instead empty the confirmation message column.

Jeroen van den BeltAdministrator

🔥 Hotfix - SF 2019.1 - Layout type output for expression columnshotfix

This hotfix for the SF 2019.1 makes it possible again to set the layout type output for expression columns. This way an expression column, which is read-only by default, can be hidden in the layout procedure.

Jeroen van den BeltAdministrator

🔥 Hotfixes for week 52 - And a happy new year!hotfix

Hi everyone!On this last day of the year, we’ve released the following service update: IAM 2020.2, 2021.1, 2021.220211231 - Fix for copying user with user preferences When copying users with user preferences, some preferences could not be copied due to identity values being different after insertion, resulting in referential errors with details of preferences. This was already solved in IAM 2021.3, but we decided to also provide this as a service update for other supported IAM versions. Hope you all have a great New Year's Eve. Enjoy, stay safe, and see you all next year! Thinkwise Product Development team

1
2

Page 1 / 2

Badges

Robert Wijn 2has earned the badge Adapter
Guido Bijlhas earned the badge Adapter
Dave Bieleveld Starcodehas earned the badge Critical Thinker
Theo Neeskenshas earned the badge Critical Thinker
Niels Koophas earned the badge Geek

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

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.

OK

This file cannot be downloaded

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

OK