Topics started by Arjan Sollie
All of you, that have worked with Microsoft Azure, have probably noticed that Azure does not allow you to mutate or select data from a different database than the transaction database. However often you find yourself in a situation where this is necessary. This blog will help you with exactly that. This blog describes 2 features which you can use.Feature 1 External DatasourceMicrosoft SQL has a feature available called “External Datasource”. This feature supports selecting data from an external source, but does not require to connect to this external source. It is kind of like a fake table within your database, which selects data from the defined external source. While using an External Datasource it is possible to select data from another database within Azure. Do keep in mind that it is not (yet) possible to mutate data using an External Datasource. If you would like to mutate data on a different database, you have to use the second option this blog will describe.How to configure an
This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalSending emails from within your application is a common feature and can be implemented in many ways. However the traceability of sending emails from your application is often difficult. Therefor it is very usefully to gain some insights into which emails have been sent to whom and whether the email has exactly been sent. This topic demonstrates a basic setup for gaining insight into your email traffic. SolutionFirst of you will have to set up some tables. This example will also contain tables used by the Thinkwise Reporting Service. This topic will allow you to email attachments created by the Thinkwise Reporting Service. This topic will not explain how the configure sending emails with a template. If you would to know how to do that, look at this topic: Example email module. Create the following tables (if you do not use the Thinkwise Reporting Service, ignore the reporting_service_r
Currently in the Software Factory the checkbox Enable task/report in empty subject is set to true. Personally I would like the default set to false. In most cases the task/report should not be available when there is not subject. The exception is the case in which you would like to enable the task instead of hide it.
Easier way to add tags to objectsCompleted
Currently the tag tab is only available within the full model object. It would be a whole lot easier, and faster, if these tag tabs were also available within the modellers such as: task (+parameters), report (+parameters), data model + subject modeller (tab and columns).
Lookup combo values based on table value functionOn the backlog
When adding or updating a record I often find myself in a situation where I would like the selection (combo lookup) of field C to be filtered based on values I have set in fields A and B. Currently the Software Factory only allows you to create such a behavior when you include fields A and B to the lookup reference column list. This poses a bit of an issue when for example you would like to filtered based upon a date field.There is a better way to create such behavior. If the Software Factory would allow you to determine the lookup combo values based upon a tabled value function. You could then include the values of fields A and B into the parameter set of the function.
Data authorization prefilter NamingCompleted
When configuring Prefilter rights for specifics roles, there is an option named Data authorization prefilter, which determines whether a prefilter is always active and locked. I myself and other developers I have worked with, find this name a little confusing. Therefor I’am looking for a better name for this option. This topic has been created to determine whether this name might have to be changed. If so, which name is the preferred name?
Hi all,In order to synchronize data from a local MS SQL database to a MS Azure database, Microsoft offers a tool named the “SQL Data Synch”. In order to use this tool, a table cannot be using a user defined datatype. By default the Software Factory generates tables in MS SQL Server based on user defined types. You need to be able to disable this and instead use system datatypes when deploying.Therefor I would like to be able to configure this within a project version. And I would like to specify whether this is done for tables and or stored procedures. In some cases you would like to enable this for tables, but not for stored procedures.Currently you can set this by manually setting the column “alias_allowed” in the table dttp to 1 and after that alter the column user_defined_dttp on the table dom. This should be something that you can configure within the project version.Do keep in mind that you should still be able to deploy the user defined datatypes so that they can be used in SQL
Currently when setting up a task or subroutine within the Software Factor the checkbox Atomic Transaction is set to false by default. It be better if the default is set to true instead of false. Normally all tasks and subroutine (procedures) will have to be set up using an atomic transaction. In some exceptions you would like to disable this feature.
Currently the Software Factory allows you to assign a different screentype based upon a breakpoint. This is a very useful feature. Unfortunately you still lack the option to optimize the different screen layout. Because all subject configurations such as the grid, cardlist and form are still having the same setup. This leads to setting up a compromised setting for these components. So that it will work on a large and small screen.How great would it be to be able to assign a table variant based upon the same breakpoints! This will allow you to fully configure your table for multiple resolutions, and therefor devices.Obviously the GUI will do some scaling, to help with adjusting the grid and form, but often on smaller screens things such as the sequence of fields or the grouping of fields should be different. Users do not want to scroll before being able to see the most important data on this table.All of this can be configured if we could assign table variants to breakpoints.
Currently as a developer you are able to set the default column width for columns on a specific table. This will overrule the default column width set on project version level.This is a very useful setting, especially when developing for the Universal UI. Currently such a setting does not exist for the task and report parameters. Often when developing task and/or report popup windows one or more field contains a long text, for example the name of an item. Without being able to set specific column width for this task/report I am unable to increase the field size. Therefor I would like to set a setting for setting the column width on task/report level.
Maintain project version destinationCompleted
Files used by an application, say images, reports etc., are store in a specific folder. In most cases the location of this folder is different for the development environment then it is for the production environment. IAM provides a task the update all the file links within a project version. This is a useful feature. However I would like this feature the store the altering made to the path (difference between development and production). Currently you have to update this path each time you synch a version, whether this is a new or already existing version. In my opinion this is redundant. IAM should be able to store the altering made within the path to set it the right path used in the production environment. Therefor automatically update the path upon synchronizing the next time.
Improved use of variantsOn the backlog
Currently when setting up a table, a variant is used to define an exception as display method of a specific table. The main set up is used by default and only when you would like to use a different display method, you set up a variant. This approach often leads to issues with the use of prefilters. For example a specific prefilter is set to disabled and hidden on the default display method. However this prefilter should be enabled and visible on the variant. This is not possible. The same issue surfaces with hiding columns on the default display, but enabling them on the variant. The solution is a default variant. This variant is created upon creation of a table. This is also the default display method of the table. It is not possible to display a table without a variant. By using this approved the issues, which I've described in the previous paragraph, will no longer be an issue. To reduce the workload whilst setting up these variants, the main settings (which're currently bei
I would really like to be able to see in IAM whether a process flow ran successfully or not, and if not, what error was thrown during the executing of this flow.Also, I would to be able to assign an email address to which a notification can be send when a specific flow fails during execution.SQL server agent jobs provide this kind of logging and tracing, there for clients of mine that we used to running this system automations through SQL agent are currently having difficulty to determine whether their system flows are running correctly or not.
In our current Graphical User Interface it is not possible to configure task, report and prefilter bars. Meaning that either all objects within the bar are being displayed or non at all. I have been told, that there is an extender, which allow you to configure these bars. I was wondering if the option to configure bars will be introduced within the Universal Graphical User Interface? Instead of having to set up an extender outside the Software Factory.
Currently when using a tree based upon a grouped column, the label of this column is displayed on top of the value of that grouped column. I would like to be able to disabled this label. Often I do not need this label and for some users this is very confusing. In this example I would like to hide the label text Ship Manager. All I have to see is the value “Athena Marina Co. Ltd. This will also keep the tree view much smaller, since currently this takes up two rows instead of one.
The SF suite 2019.1 features a validation check "All rights role will become deprecated". It warns a user about the fact that the "all rights" option on a role will be removed in a new version of the SF suite. I was wondering: when this option will be removed, will all the roles, which had this option set tot yes, be converted into a role with full access to every object available within this project (version)?
While reviewing control procedure templates I continuously keep seeing trigger template in which people declare variables and set them. It would really be helpful if we could automatically check trigger templates for the use of variables, whilst not using a cursor. Variables are required when using a cursor. In nearly all other scenario's triggers do not require the use of variables. Most times, that these variables are being set, this will lead to errors when the inserted contains more then 1 record. Therefor I would like to suggest we add a validation (or an option within the code review screen) to check trigger templates for this mistake. This would significantly lower the chance that developers will make this mistake.
Currently the Software Factory offers several options to automatically refresh data on your screen, such as the following:You can set the auto refresh based on a specified time You can refresh it by implementing a processflow that upon activating a specific document the document is also refreshedThe first option is an option which is pretty simple to configure for multiple screens. The second option will cost you allot of time, if you need to set this up for several screens. I keep running into cases where I need to implement the second option for allot of screens. Therefor I would like to request a checkbox for the second feature on the table (variant), similar to the checkbox available for refresh option one.So in summary, I would like a checkbox on table/variant level to automatically refresh the table when activating it as a document.
Currently when downloading a TW Suite upgrade, the downloaded folder contains 2 TW deployer executables: twdeployer twdeployerGUI I find it confusing that the executable, that starts the deployment tool, is currently the twdeployerGUI. Based on the names, I would expect that the executable, which I have to use, is the twdeployer. However this executable is used to start the deployer while using command prompt. Therefor I would suggest, change the name of this executable. So for example twdeployerCONSOLE or twdeployerCMD. If any of you has a better suggestion, feel free to post it as a reply to this post.
If you are using a Windows GUI, which is connected to the database using the Indicium Basic, to use any form of single sign on?Currently I have set this up for a client of mine. They will have to insert their username or email address and password. But their Windows Credentials match their account in IAM. So you would kind of expect that the Authentication option MSWINDOWS would be available when using the Indicium Basic as your server. Is there any way to set this up?
Now that our processflows have become more powerful I find myself programming more code templates for specific processteps. At the moment this requires quite a bit of work. I have to go to the functionality screen and create a new control procedure and template from there and then search for my specific processtep, which sometimes can be a bit of pain. Also reviewing process procedure templates within a processflow is a bit of a pain. Because there is no quick way to see the code linked to a processtep.What would of great help is being able to create/manage control procedure and templates from a specific processflow step. This will save alot of time during development and will make the review work of processflows alot easier aswell. Within the processflow screen you will get a control procedure screen that automatically filters on code group process. And it should also include a prefilter for showing control procedures that have at least 1 template linked to a step of this processflow.
The universal UI uses the lazy loading concept. This has the benefit of not having to load the whole application upon login. This makes the UI feel a lot faster than its predecessors.However upon opening a screen it will load all the required components for this screen. This sometimes makes loading/opening of a screen feel kind of slow. I personally think that having a kind of hybrid form of lazy loading and loading the whole application would be perfect. It would be super usefully to fully load the screens, that a specific user opens most often, upon loading (login) the application (top 5 for example).IAM can be used to determine the top 5 screens which have to be preloaded.
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.