Solved

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?

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.[img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/0b4f2bf9-9b43-492f-9028-9013896fa316.png[/img]

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

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)?

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