Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Anne Buit

510 Replies

Oldest first

Newest first

JasperAdministrator

Executing tasks in a transactionCompleted

It is now possible to mark a stored procedure task or stored procedure subroutine to execute as an atomic transaction for SQL Server and DB2. This will affect the generated code for this stored procedure.

Robert Jan de NieThinkwise blogger

Excluding multiple NULL values for indexes by defaultCompleted

Unique indexes can now be configured to exclude null values.

EsterModerator

Process action to copy files.Completed

Two new connector process actions have been added: Copy file and copy folder.

Andre te RaaCaptain

Execute as optionCompleted

We've added an execute-as option for SQL Server procedures, functions, CLR procedures and CLR functions in version [url=https://office.thinkwisesoftware.com/docs/blog/2018/10/07/2018_3.html#execute-as-option]2018.3[/url].

Tom SteffensRookie

asked in Questions & Conversations

IAM admin per application

Hello Florian, Version 2018.1 of the Thinkwise Platform has revised the authorisation of administrators in the Intelligent Application Manager. [url=https://office.thinkwisesoftware.com/docs/docs/iam/administrators.html]This[/url] list provides an overview of the different types of administrators and their capabilities. In your particular case, several Application owners should be configured. An Application owner cannot configure users (including him- or herself) to be Application owner for an application. Only Application administrators and Main administrators can do this. Does this answer your question?

Anne BuitCommunity Manager

published in News & Blogs

Drag-drop of recordsBlog

[h3]What about drag-drop [i]before[/i],[i] after[/i] and [i]between[/i] rows?[/h3]At first glance, it looks like this drag-drop is not suitable for re-positioning rows in a list. One would think this requires you to be able to drag-drop [i]before[/i], [i]after[/i] and [i]between[/i] rows. But this is not the case, depending on the source index and target index you can make a very fine guess of how the rows should be ordered after the drag-drop operation. The following code example can be used in the drag-drop task when the source- and target variant are the same. The parameters sent to the task are the following: [list] [*][b]sales_invoice_id[/b] – The sales invoice, mapped by the bound task and the drag drop link. Equality required! [*][b]drag_invoice_line_id[/b] – The dragged line, mapped by the drag drop link. [*][b]drop_invoice_line_id[/b] – The line on which the dragged line is dropped, mapped by the bound task. [/list]The task code should re-position all lines between the

Anne BuitCommunity Manager

published in News & Blogs

Drag-drop of recordsBlog

[h3]What about drag-drop of nodes in a tree?[/h3]Similar code can be used when re-positioning nodes in a [b]hierarchical tree[/b]. When the node is dropped on a node with a different parent, the user probably wants the dragged node to be positioned under the dropped node. When the node is dropped within the same parent, only re-positioning is required. If you want users to only re-position nodes within the same parent, you can map the parent_id at the task and the drag-drop link to make the GUI check for equality. See below for the re-position task code: [code]-- Check if we didn't drop to self if @drag_tree_id = @drop_tree_id return -- Find the current order_no and parent_id of the dragged node declare @current_order_no order_no declare @current_parent_id tree_id select @current_order_no = order_no, @current_parent_id = parent_id from tree where tree_id = @drag_tree_id -- Find the desired order_no and parent_id of the dragged node declare @desired_orde

Eric FrankenVanguard

asked in Questions & Conversations

Calling a procedure when closing an application?

The extended property does seem to be configured correctly. However, I'm fairly certain this property only works when using IAM as meta, not SF. Can you try to sync the model to IAM and see if it works when you boot and quit the GUI on IAM?

htimmermansCaptain

asked in Questions & Conversations

Software Factory language

Since the language for a user cannot be set per application, the user preferences menu shows all known languages in IAM, not just the active application. However, German and Chinese should not be present on a clean installation as default languages. We have found the root cause, this has been resolved for future versions. A hotfix has been released for 2018.3 to remove these languages (provided they are not in use by another application).

Andre te RaaCaptain

asked in Questions & Conversations

Task to control a process flow

When you compare it to 2018.2, 'None' might seem a bit weird. However, all types have been renamed in 2018.3 to better reflect the type of logic that is used in this task. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/6bbb79a8-c082-4f92-bb0e-7838ac18b08b.png[/img] This is why it's called 'None'.

PimWarrior

Formal option for persisted computed columnsOpen

Hi Pim, this can already be done by adding the keyword PERSISTED to the end of the calculated field query. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/b8e6dd63-577b-42be-8b76-8dcda560f737.png[/img] Keep in mind there are some limitations when using persisted computed columns, they must be deterministic.

K.BakkenesCaptain

Code review for current version.Completed

It would be good to think about why control procedures from another branch end up in your own branch in review-status to begin with. Best practice is to have all control procedures reviewed before they are merged to the trunk. A new branch would always start with no control procedures in review.

PimWarrior

Formal option for persisted computed columnsOpen

A checkbox could be introduced to achieve this, yes. We could convert the existing PERSISTED keywords without too much effort. However, as long as we do not need other parts of the Software Factory, IAM, Indicium or GUI's to make a distinction between persisted and non-persisted columns there's not much to gain. Yes, there are no sanitizations done on the expressions you write here, so be careful ;) I wouldn't go as far as to call it SQL injection as this is a setting configured during the development phase by a developer, not in a live environment by an end-user. None of these snippets ever be modifyable by an end-user so there's no risk there. Same counts for templates, SQL prefilters, validations etc.

Kevin HorstThinkwise blogger

Testcase recorder: change of tableOpen

Hi Kevin, You aren't the first one to ask for this feature, so I expect many votes! The reason this hasn't been released with the initial version of the test engine and test case recorder is that there was no reason to identify the different documents. Switching from the initial document to a new document wouldn't be difficult, but there would be no way to switch back between the varous opened documents as there was no mechanism in place to differentiate the opened documents. With process flows, this was eventually solved by providing a document ID that can be stored as a process variable and used later in a process action to return to the document. We'd need a similiar system in place for the test recorder and test engine. In the meanwhile, I would recommend creating a test suite for tests of processes that span multiple menu items. This would indeed mean recording one menu item at a time.

JasperAdministrator

published in Questions & Conversations

Multirow task execution

This feature works very well in conjunction with drag-drop. When you drag multiple rows, you can have a multirow-task execute once with all the dragged rows.

Arjan SollieThinkwise blogger

Easier way to add tags to objectsCompleted

From the reactions, I'd expect this idea to have a few more votes.. :thinking:

asked in Questions & Conversations

Suite upgrade instructions

Hi, welcome to the community site! Regarding the first question - The Software Factory is a Thinkwise Platform product so the same SQL scripts are used when upgrading the Software Factory as any other product. This includes checks, constraints, etc. However, you shouldn't have to run these scripts by hand. There is a deployment tool available which will help with the upgrade process. When you download the installation/upgrade package from the Thinkwise Community Portal, make sure you download it for version 2018.3 (the target version). [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/a24a66b6-9ffd-4586-a880-0f07fcf164db.png[/img] Extracting the package will provide a folder with an executable called twDeployerGUI.exe. You can use this tool to upgrade APPLICATION_IAM_ONT, APPLICATION_SF_ONT and APPLICATION_IAM_PROD. The company product database will not be affected. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/4d8af4a4-f5b1-460c-a8

Some improvements on visibility of open documentsOn the backlog

Hi JeanPaul, Thank you for your suggestions. That's a lot of open documents! A few notes as we've delved into this before with our UI/UX experts. The shared scrollbar between the open documents and the menu is intended to help usability when using a mobile device. We don't want the user user to feel like he's scrolling in the 'wrong' part of the menu or that he has to aim for the lower scroll region. The treshhold where a scrollbar would be introduced for open documents would also be a bit arbitrary. Grouping zoomed detail documents under their parent document was something that was considered but this was deemed not an option as the parent document can be closed at any time. When the parent document is closed, the zoomed detail documents will remain open. Allowing the user to collapse the open documents might be a good solution for your scenario. Would this be a good solution in your opinion? Our UI/UX experts have prototyped several options for displaying the bread

Passing parameter values between forms / screensClosed

Hi Frans, I'll try to summarize your question, please let me know if I'm on the right track or way off. You have two entities in your application: [i]purchase order line[/i] and [i]sales invoice line.[/i] These entities use the same third entity: [i]stock info[/i]. While adding the [i]purchase order lines[/i] or [i]sales invoice lines[/i], you want to be able to select a record from [i]stock info[/i] or add a record to [i]stock info[/i] and select this one. You'd want to reuse the screen to select or add a record to [i]stock info[/i] for both scenarios. Normally, this screen would be easy to reuse. You'd use a look-up to select or add the [i]stock info[/i]. Both look-ups can share the same entity and the same variant. This wouldn't require a screen to be configured for both scenarios. From your question I can assume that this is not the way this has been implemented. Can you describe the current implementation for me? Perhaps you can add a screenshot or two if this make

Harm HorstmanSuperhero

Add option 'Keep Translations' to rename tasksCompleted

[quote=Arjan Sollie]All, If I'm correct, the requested solution should be available in the latest SF Suite (2018.3). If not, it should be in the 2019.1 release.[/quote] Correct, this change didn't make it to version 2018.3 but is planned to be released with version 2019.1. The translations will be copied automatically.

Harm HorstmanSuperhero

asked in Questions & Conversations

Error messages in Reporting Service (3.20)

Hi Harm, This type of error message is not thrown by the reporting service and probably has something to do with the underlying report processor. I assume the service is processing a Crystal Reports report? The DISP_E_BADINDEX seems to be an error where the provided parameters do not match the report parameters. Can you check them? They are case-sensitive.

K.BakkenesCaptain

asked in Questions & Conversations

Using a different 'merge' program when solving template conflicts

WinMerge and K3diff3 are the only supported code diff and merge programs at the moment. It is currently not possible to configure the Software Factory to use a different program. I took a quick peek to see if it was possible to test an implementation quickly but a license is required to attempt 3-way merges with UltraCompare. Having the diff and merge tool configurable would be the easiest way to go. Feel free to create a topic in the ideas section to make it possible to configure a custom diff and merge tool.

Some improvements on visibility of open documentsOn the backlog

Hi JeanPaul, Yes, we did consider grouping the opened documents themselves as well. The problem with this we identified was that users are generally very aware of the order in which documents are opened. The moment we start grouping the opened documents, we let go of the absolute order in which the documents were opened. The full list is deemed important because of that. It's a bit of an arbitrary decision for now, I know. It will be interesting to see how this plays out when users start working with this GUI in production environments. Statistics about the average number of open documents and how often users switch to the wrong open document would be valueable to make a substantial claim on what is more important - a grouped set of opened documents to save vertical space or opened documents in their original order. We will continuously monitor and gauge the reaction of both users and developers to features like this and adjust accordingly.

Mark JongelingCommunity manager

asked in Questions & Conversations

Is it possible to generate a 'DB' script with a different database name than used before?

Hi Mark, You are correct, in 2018.3 the fields Dave was writing about have been moved. These settings can now be found in the menu, under Deployment - Runtime configurations. The database name used in the default runtime configuration will be used in database creation scripts.

Mark JongelingCommunity manager

asked in Questions & Conversations

Can I attach an external SQL file to the 'Execute source code' step during 'Creation'?

Hi Mark, You can create a new control procedure in the code group MANUAL. You might have to remove a prefilter from the code groups in the look-up to be able to select it. The template of this control procedure should contain the code you need to run. This template can be assigned to a program object, also called manual. This will cause a new code file to appear in the source code execution screen, at the bottom, called (coincidentally) manual. This method will not read a file from disk, and instead will require you to put the code to be executed in a template. Will this suffice?

1
2
3
4
...
21

Page 1 / 21

Badges

Sanne Buitelaarhas earned the badge Geek
André Heijmerikshas earned the badge Preparator
Yarahas earned the badge Geek
Robbert van Tongerenhas earned the badge Firestarter
HJ van Dalfsenhas earned the badge Transcriber

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