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
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).
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.
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.
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
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.
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?
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 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.
Lookup combo values based on table value functionWorking on it!
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.
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?
Hey everyone,I would like to migrate from the Basic Indicium to the Universal Indicium. I am currently using the Basic Indicium for interfacing with another system through the web. Does the Universal Indicium support the full API interfacing features which the Basic Indicium supports? And are there any differences between those 2 types of Indicium that I should take into consideration when switching from the Basic to the Universal Indicium?
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.
Filter in tree componentDuplicate
Currently when user uses a filter within our tree component, the GUI will only display rows matching the filter value. I would like to tree component to display all the parents of the row matching the filter value and the rows matching the filter value, instead of only displaying the rows matching the filter value.
Currently when an idea, which I have submitted, undergo's a status change, I'm not informed about this status change. Personally, I would prefer to receive a notification of this status change. Is it possible to configure the community so that a user, like myself, receives a status update when an idea's, or its status, is changed? If this is not currently possible, it would be of great help to add this feature.
Some of my clients do not want their users to be able to add, update or delete records from within lookup popups. Currently this means that I manually have to disable this by created a variant which I assign to the lookups, allot of work.What would be of great help to me is being able to configure on project version level whether users can add, update or delete records from within a lookup popup.
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.