Thinkwise Platform

I’ve just upgraded to SF 2020.2 and noticed I cannot download / edit the reports:If I click the button (in red) and save the file, it results in a empty file. I did use the task ‘Upload images and reports to database’ according to the manual.I’ve checked the table ‘report’. The column ‘file_spec_data’ does contain some binary data I see, but when downloading it remains empty. How can I edit DevExpress reports?

When pressing enter while adding/editting data in a list, you will automatically go to the next editable field.  However, when pressing enter while editing the last record in the list, you will go to the next editable field in the last line. Our user thinks that is confusing behaviour. The user thinks he is making a mistake and his changes aren't saved.Is there an alternative for this?

We’ve created a system flow that sends e-mails via a ‘queue’ table. We capture the SMTP status code in a process variabele and act according to the response. The SMTP status code will be updated in the queue table.   When testing we try to set-up a recipient with an incorrect e-mail address. The response we expect is status code ‘-4’ (Unsuccessful (one or more addressees could not be reached)) but the result is ‘0’ (Succeeded)   Our task then marks the e-mail as ‘sent’ because SMTP status code 0 is returned. However Outlook itself response with a ‘Delivery has failed’.   Why does the SMTP connector return 0 and not -4?

In the Software Factory (2020.1) I cannot remove a Platform under Project overview > Platforms. It keeps referring to ‘Excluded menus’. But where can I find ‘Excluded menus’? I cannot find it in the Full model and have no clue where to look. (What is an Excluded menu actually?) The DELETE statement conflicted with the REFERENCE constraint "ref_platform_platform_excluded_menu". The conflict occurred in database "SOFTWARE_FACTORY", table "dbo.platform_excluded_menu".  

Hi all, I have a finance overview grid, with three group label. General Cost Revenue Is it possible to have the group label border extend through the grid?  This would greatly improve on the usability.   

Hi,  Is there any solution for the following problem. I have a lot of fields that need to be edited (addresses, money, etc) and that needs be printed. This works quite well, but the client would love to have a wysiwyg-sort of editor.  So, ideally I want to have my text-fields on the left, and a live pdf preview on the right.   Any chance this can be done? Much appreciated!    

Hi,  I’ve a scenario with a sales order with a sender company with related location and receiver company with related location. What is the best approach to make lookups for the both locations? For sender location, it should filter the available locations on the sender company and for the receiver location, it should filter on the receiver company. Both sender and receiver are retrieved from company table and location from the related company_location table. Can I use same lookup or should I create different ones?  I have this scenario for more tables in the application. Thanks in advance.   HJ van Dalfsen

Because of an earlier issue (https://community.thinkwisesoftware.com/deployment-12/what-is-causing-the-clear-panel-message-in-the-panel-informatie-1030), I installed the latest web GUI (2020.1.14). Unfortunately that caused another problem. I am getting the following error: Deze taak kon niet worden uitgevoerd omdat er een component mist. Raadpleeg uw systeembeheerder voor advies. Well, I could ask my system administrator, but I don't think he will be able to help me with this, so I am asking you guys for help. The situation is that there are a few tasks that are being executed managed by a process flow. The first one is a SP and the second one is a task that executes TSFReportMailer. I think the problem is with the second task. Is this a known bug? What can we do about it?

From the 2020.2 version of the Thinkwise suite, the way of determining effective role rights has changed. This may have consequences when you use the IAM feature to apply user rights to the database. This text focuses on what may have been changed for you, and how to deal with these changes. Calculating the effective role rights To determine what actions a user is allowed to perform, we use effective role rights. Effective role rights are a combination of: Meta model settings Role rights Previously the effective role rights were calculated in IAM. However, the meta model settings and role rights are both stored in the SF. So it makes more sense that the effective role rights are already determined in the SF, and pass on to IAM during synchronization. So this is done from the 2020.2 version. This also offers major advantages for the auditing module that now exists in IAM. After all, it is no longer necessary to calculate in IAM which maximum rights a user had during a certain perio

When I create a Deployment Package I notice a difference between the upgrade methods “Smart” and “Full”, also described here: https://docs.thinkwisesoftware.com/docs/sf/creation.html#3-generate-source-code. We often have small changes, so using the upgrade method ‘smart’ is preferred, because a ‘full’ update is quite heavy and can take a while. But when choosing for ‘smart’, the script ‘020_Upgrade.sql’ isn't (always) created. I have this situation for example when I only change a query in a view (no model changes). Why isn't there a 020_Upgrade.sql containing an update of sf_product_info table generated when having only some minor changes?

When the user opens the (desktop) application for the first time, our application might be a bit overwhelming. That's why we want some 'tutorial' or landing page where the software is explained. This could be a web page with some videos embedded in it. This is a bit like downloading a new app on your phone where the important parts are highlighted in a 'scroller view' (each dot is a page) or there is a highlight on certain button or action. The user should keep seeing this window, until he clicks somewhere saying "Don't show again". I did read this post that looks a bit similar: https://community.thinkwisesoftware.com/development-13/how-do-i-set-a-table-as-a-start-object-or-landing-page-when-ever-a-user-logs-in-889 By following the steps described on the link above we could add a menu item with 'first start' and set that as a start object for each user. Problem is that it will start each time, where it's quite difficult for a beginner user to disable this the next time: You have to

How do you translate Maps extender item? I've input the translation objectsd in the extender, but they are not showing in the Translations form.  

Check constraints is only defined on tables. However it could be helpful to define constraints on columns or even domains. Searching on internet I find references that constraints on domains have the advantage of defining them just once instead of defining them for every use. I have not found any information in the community, so I assume there is a reason why constraints are only defined on a table. So what reasons are there for only defining a constraint on a table instead of also defining them on columns and domains?

I'm trying to insert a record via the Indicium Universal OData API. I'm getting stuck on a read only field. Consider the following data model as example: I have the tables project and project_vrs (having a reference between them). Please note that ‘project_id’ is read-only in the table project_vrs, and there is no identity used. If you generate the model you'll see the following screen: The user can open/add a ‘Project’ and via the details he can access ‘project_vrs’. It also allows him to add a project_vrs. My question is, how can I reproduce the Windows GUI behaviour via the OData API? Doing a POST call via Postman inserts the project:   The project_id ‘TEST’ is created. When I try to add project_vrs I get an http 403 error: The Indicium log shows the following interesting line: dbug: Indicium.Controllers.TableController[0] Cannot change the value of the property 'project_id' of 'project_vrs'.The application model prohibits editing this property. This is probably cause

Do temporal tables count as one or two tables for licensing?

I'm experimenting with the OData API and I was wondering what the possible response messages are in case of exceptions / errors. I found out that there's a response header provided called “TSFMessages”, which is base64 encoded. Decoding this value gives a result like below: { "MessageType": "ApplicationDbMessage", "RawMessage": "<msg id=\"import_error\"></msg>", "MessageID": null, "NamedParameters": null} Is there an overview of all MessageTypes? E.g. what can I expect? And what do the other parameters do?

I managed to create an API task to upload images in the application, save a record in the database and store the file in azure file storage. This opens the door to new features  One more optimization could be made for how the storage location should now be included in the API call. I would like to get the yellow marked piece from the settings in IAM. Or rather not want to participate in the API call at all.   Any idea how this could best be solved?

I'm pretty sure I have asked this before (either in TCP or perhaps when calling Thinkwise): is there a way to set the size of a popup (lookup) in the GUI? I've checked TCP but can't find the answer I'm looking for. Neither in the ini documentation (looked for “window”, “size”, “popup” etc etc etc) Either by setting a extended property or in an INI file. And if so, is it configurable per subject (don't think so) and if not, isn't that something to add as a new idea here?

Hi All, perhaps it’s an old bug and is it solved already. (We’re still on the 2018 version, hopefully we will update this summer)  Is anyone know with the behaviour that a list bar menu group is opened when starting the application. In this group is only one item. If we close the group, the group will not open again. It stays closed until we restart the application, and then it’s opened by default. I don’t see any settings in the SF or the IAM related to this ‘feature’

Is there anyone who has a working example of the maps component? I find it quite difficult to Implement the functionality by trial and error, based on the documentation. It would be nice to have a fully filled extender definition, plus the definition of a source table, including sample data.    

Hello! A question. I want to fill a column in a table with a default value. I can do this in many ways, but normally in SQL I can do something like this: ALTER TABLE MijnTabel ADD CONSTRAINT DF_xxx DEFAULT GETDATE() FOR MijnKolom Something like this. I wanted to do the same thing within the SF, but it seems that is not possible. What I did was go to the table and then fill in 'GetDate()’ as the default for that column. However, then I get a message during deployment that there was a problem converting the varchar to a date. In short, it sees 'GetDate()’ not as a function, but as a string (the single quotes were added too).  Long story short: is it possible to use GetDate() as a default from within the SF, or should I use another method (f.i. create a default that automatically fills this field with the current date) BTW: there is a slight difference between these two: if I were to use GetDate() as the default, it would get the date when the record was added. If I create my own d

Is it possible to add a 'DEFAULT' constraint to columns via the TSF? Currently we fill trace columns via insert and update triggers but this results in unwanted trigger actions. The insert trigger will update the same table and thereby triggers the update trigger. Which in return executes the whole update trigger. (See code below) We have multiple places where this trigger nesting causes errors or wrong results. If we could add a DEFAULT constraint to the insert columns the code of the insert trigger won't be necessary anymore.

Hi,  We have a web app and have several parties with several users using this software. Now, every time we have a new release and push this to production, all users have the latest version - with new features and bugs fixed etc.  What possibilities are there for having a popup appear with a change log where we can show what has been implemented, has been fixed/changed and such?  Users acknowledges this update and can use the app.  This saves us an email or call to our users every time we update  In an ideal world we would even be able to send a push message, in case of unforeseen reboots or backups or whatever.  Any thoughts on this?    Alex    

I try to send an email via the TsfReport mailer using a smtp connection. This connection does not require a username and a password so I left those entries empty. All other parameters I have created and filled with a value. However the task keeps giving the error: Value cannot be null. Parameter name: address.  I checked the documentation and I even added the parameter e_mail and the parameter email. (At the smtp section it is ‘email’ in the top section it is e_mail?? I also added the smtp_host variable. I have given all the variables a default value, so there is no code involved.  Could security be an issue? If the smtp port is not open for that address, is this the error I’m getting back?     The stacktrace gives….    at System.Net.Mail.MailAddress..ctor(String address, String displayName, Encoding displayNameEncoding)    at Thinkwise.Shared.Mail.SMTPMailer.createMail()    at Thinkwise.Shared.Mail.SMTPMailer.Send()    at Thinkwise.Extensions.ReportMailer.TSFReportMailerBase.T