Questions, discussions, news and updates regarding the Thinkwise Platform.
Recently active
Goal Something that can often occur in your projects is working with order numbers. This is also done in the Software Factory itself. In our case, when the column "order_no" (for example, 10 and 20) exists, the column "abs_order_no" (in that case 1 and 2) pretty much always also exists. Now you may want to increase the "order_no" for each record by 10. When you add several new records between 2 records, the increment of 10 between these records is interrupted. To correct this, we have renumber tasks in the Software Factory. By using these tasks, the increment between the order numbers will be restored using the "abs_order_no". These renumber tasks are created dynamically in the dynamic model of the SF. I would like to share this concept with you. This is the model part. But I'll also include the control procedure code and template code for the code of the renumber tasks itself. Let's get you inspired! Solution Create the tasks by executing the dynamic model code in the zip-file.
When creating an application, using icons is an important part of the user experience. Likewise, reports can add a lot in terms of BI. Up until now these files have always had to reside on the file system, which can bring some added hassles during deployment. The files needed to be present in the correct location, all users needed the appropriate rights to access these locations and after deployment IAM always had to be pointed to the right location to be able to find the files. With the release of version 2020.2 of the SF and IAM we’ve taken some steps to relieve these issues. Starting with 2020.2, icons and reports will be stored as BLOBs in the database. This means that whenever the database is deployed, all icons and reports will automatically be deployed with it and the SF and IAM will instantly have access to them. Icon overview screen Uploading files to the database After upgrading to 2020.2 you will need to upload all images and reports from the file system to the datab
When the ‘forgot password’ function is used in the webGUI, a token as shown below is sent to the user by mail. This token is probably very safe, but also difficult to copy in handwriting (correctly), and the safety it provides is does not reflect the functions Zeeman provides to most users. Is it possible to configure a shorter/simpler token? I was thinking of a 4 digit numeric code, but a 6 digit code (provided by the forgot password function in the mobile GUI) would also be ok.
I'm unable to use the tile menu in Universal, although it is the only menu made available in IAM for Universal. What am I doing wrong?
For certain tables such as invoices there’s a lookup to an address table based on a unique address id. The address table has a (hidden) column with a multiline expression containing street name and number, postal code and city. Thus 3 lines effectively. This field is set as the default display column for address lookups. The issue is that in every form of a table that is targeted by this lookup the address appears as a single line. Line breaks completely disappear. I can get around this by adding a new expression column in say the invoices table and make that multiline as well which then displays address data correcty as 3 lines. But since expression fields are always read-only this makes it impossible to change the address through this column. I can of course ‘hack’ this limitation by adding code to a layout procedure that hides the expression field in edit mode and displays the actual address id column instead but that I think pretty much defeats the purpose of having a simple look
When working on a mobile device like a phone (limited display size) expression fields cannot be made visible in the SF in component “Card List”. I wonder why… Anybody a clue why this is not allowed in the SF (2019.2)?
Varbinary issue SQL Server Management Studio doesn't handle very long strings and varbinaries very well in the query window. It hangs for several seconds as you try to scroll over that line. And in fact, some versions will even display a warning about long lines when opening a script that has at least one line over a certain length. In the Thinkwise Platform this is a problem when you want to synchronize your project version to IAM with a script. This script can contain long varbinary values, used for pictures and documents. This has always been a potential issue, but from version 2020.2 of the Thinkwise Platform files like icons and reports are stored in the database. Which makes it a lot more likely that you will encounter this. In SQL Server there is a way to split up these long varbinary values, by using line-continuation in T-SQL via the backslash character. This could avoid the problem. However, we don't want to go this way because: 1. Splitting up varbinary values is very ti
Hello all, I have a question about unit tests. We're currently working on getting to grips with this subject. But I'm kinda stuck on one specific unit test. I have a default that I want to test. It is a simple one that removes spaces from a string, as follows: if @cursor_from_col_id = '[field]'and @[field] is not nullbegin set @[field] = REPLACE(@[field], ' ', '');end; But now I'm lost when adding the input parameters for the unit test. I'm choosing 'postal_code’ as a parameter with input '1234 AB’. But when I run the test it just returns '1234 AB’ (so it failed). I also tried adding 'cursor_from_col_id’ with input 'postal_code’ as an input parameter, but that also didn't work. Looking forward to your answer!
Hi, We use the resource schedular and it works fine. But when i checked the setting [Zoom factor] under web settings i got an error "object reference not set when we log in." Does anybody have experience with this? thanks in advance, regards Ronald
Hi There, We have used the report mailer (TSFReportMailer) for mailing the report to users with smtp. In windows it is working well but unfortunately when we deploy it on our IIS webserver the follewing error shows Does anyone have experience with this? The next step is to deploy to a azure enviroment! Reguards Ronald
When I open the SF (2020.1 with GUI 2020.2.10) there's a button called “Version control” in the Developer tab page. I do notice some warnings. What does the tab page do and should I be worried things not working properly? I'd assume all should be green or blue. Some assemblies are referring other (patch)versions and some assemblies cannot be loaded it seems. TSF_dotNET, Version=2020.2.10.0, Culture=neutral, PublicKeyToken=nullThinkwise.Runtime, Version=2020.2.10.0, Culture=neutral, PublicKeyToken=nullInfragistics4.Documents.Core.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Documents.Excel.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Shared.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Win.Misc.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Win.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKe
Hi We use the resource schedular and it works fine. But the customer wants that when he scrollss horizontally the vertical scrolls stays the same position. Now the vertical scrollbar is automically set to the top. The user must then click the scrollbar to select the bottom row. This is not handy when you want to scroll from horizontale and see the bottom rows. By the way a bigger screen solved the problem but is not the solution. Does anybody have experience with this? thanks in advance, regards Ronald
hi, I have an overview of ‘orders’. I can print one order to PDF, based on variable order_id just fine. If I select multiple orders, i will print fine, but instead of one long pdf, i download 1 zipfile with 4 (e.g) orders in it. However, I need it to be 1 file with 4 pages, 1 order per page. I know this is possible, but I can’t figure it out. My report is build in Report Builder. Do I need to modify my report, change the settings in SF OR both..? Anyone can point me in the right direction? Much appreciated!
I’m going to generate this project! Where are my program objects, oh, it’s generating…. Does this sound familiar? In the 2020.2 release, we will introduce a cool new feature to send notification emails when generating a project. To receive these emails, an email address can be provided. Best practices will be to use a group email address to notify all team members working on the project. Microsoft Teams offers an easy solution for group emails. Every channel within MS Teams has a unique email address which can be retrieved by right-clicking on the channel. This email address can be used to send the notifications emails to the channel. The notifications will pop up on the channel as follows: Generation start and finishThe notification email will be sent at the start and finish of definition and source code generation. When generation is quick and finished before the start-email has been sent, this email won't be sent at all. It's no use to notify that a certain version was l
Hello, Is it possible to start outlook within a process or task? Kind regards,
Goal Sometime you need to extract only the file name (or maybe extention) from a file path. Solution declare @file_path varchar(500) = '\\server_name\folder_name\folder_name_2\file_1.txt';select right(@file_path, charindex(char(92), reverse(@file_path)) - 1)
First off: I'm hoping it's OK that questions are asked about Universal, especially since it is an essential part of our current development. We've set all our project versions to Inactive (except the current branch), but nonetheless all our project versions show up in the left bar of Universal. Our current project has a larger number of Inactive project versions, so the list gets very long.
Hi, What options are there for triggering alert for the end users, perhaps based on groups? I have an app with several user groups, and I want them to have two things; an in-app overview page of all items due. (for example, invoice that need to be paid, or orders that need to be closed). I want them to receive an email every morning at 0700 with all these items. I can’t find anything in SF of the documentation. I thought of making an Table Variant and filter on the date field. (if invoice_due_date = tomorrow..) but I wonder if this is the best. Any thoughts on this? Kind regards, Alex
I personally like the group label option for a grid, however when you start a group label and there are hidden columns the last visible column never is included in the group. The only way to solve this is to unhide all columns, and hide them in the Grid-layout and make sure they are not within a grid-group. Would be great if this problem could be solved.
Is it fair to say that the @cursor_to_col_id parameter in a default control procedure is not working in Universal?
Can processes be executed in Universal? It seems not to work at this time.
We're currently testing our project in Universal. We've seen that tasks from the menu work in the current interface, but are not starting from Universal. When we click them we get the following error:
I have nothing against drags, but drag rows are not my thing. Is it already possible to disable this on a per-user basis in the runtime configuration, or UP? If so, I must have overlooked it in the documentation. Otherwise I would applaud exposing this feature in an upcoming SF release! -edit- For me it would suffice to be able to disable the behaviour of default drag/drop; just tick it in the context menu in the same way as I have to do for ‘editable grid' to enable it.
Currently we're testing our application on the universal. The issue we're having is that the themes we apply in the SF aren’t shown there. We’re using the RC2.1.0 GUI version with platform version 2020.1 Note: the themes are applied if we use the web gui.
Many organizations elect to audit access to provide insight into application usage and potential security issues. In the Intelligent Application Manager (IAM) version 2020.2 a logging mechanism is introduced which makes these audits possible. Auditing The purpose of auditing is to be able to see which user had access to a certain object in one of the applications at a certain time. To access this information, an Auditing group is present in the Advanced menu, which includes an Access Analysis menu item. The corresponding screen looks like this: Access analysis A filter is included at the top of the screen. In this filter you can enter a Audit period from and a Audit period to in the Period section. IAM will then calculate what the maximum access rights of a user are for a specific object in a specific application during that period. The results of this calculation can be found in the tabs in the bottom half of the screen. A tab is available for each object that can be authorized.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
