Questions & Conversations

Dear Thinkwise, Soon we want to install and use SQL server 2019. (Available since 4 nov 2019) We work with SF 2019.1, IAM 2019.1 (and higher), Indicium 2019.1.7 (and higher), WebGUI 2019.1.11 (and higher). On your website you only show support for SQL Server 2019 RC. (https://docs.thinkwisesoftware.com/docs/2019.1/kb/lifecycle_policy.html#microsoft-sql-server) Can you confirm that SQL Server 2019 in combination with the above named products is also supported? Yours sincerely, Eric

I'm trying to execute a web service call after modifying a record. According to the documentation it can be done via a process flow using “Modify record”: https://docs.thinkwisesoftware.com/docs/sf/process_flows.html#modify-record It says the following: This process action will also work in combination with modifications in the list. If this process action is not a start action, then the GUI will give preference to a form to deal with the action. If there is no form present, then the GUI will try to find a grid. If a record in the grid is modified, is successfully stored and there is a follow-up action that can be called, then a possible row switch action that handles the save of the data will be prevented.   Problem I'm having, is that when editing in grid the proces flow isn't triggered. It's triggered when adding or editing via form, and also when adding in grid it's triggered. But not when editing in grid. What am I doing wrong? I have the following process flow defined: And this

Is there a specific reason why pre-fliter in Indicium don't work on subject which are marked ‘Offline available’ is true? As soon as ‘Offline available’ is switched off for the subject, the pre-filter is applied.

Hi,   When exporting a grid to Excel the data will be shown in Excel with the standard Calibri font. I would like to see my data appear with the Tahoma font. When I change the default font in Excel to Tahoma, my data still appears in Calibri. Is this because the grid is exported with a standard lay-out using Calibri? If so, can I change this to Tahoma? Or do I have to use conditional formatting to change the ‘export’-font? I would like to do this for all grids by default.    

For big dataset it could help a lot for the performance to avoid using 'LIKE’ in where clauses. I expected a different behavior, depending on 'Filter Condition’  Example: Combined filter value: 2019 2020  Result:    SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] LIKE '%2019%’) or (t1.[ACC_YEAR] Like '%2020%’) Should be: SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] = 2019) or (t1.[ACC_YEAR] = 2020)  

Hi all, Can someone explane what the purpose of the “Task parameter tags” and how it works. This can be found by the tasks.   There is no documentation avaibele on this subject yet.   Regards   Ronald Gombert  

The Thinkwise suite adapts colors of SVG icons to the menu items and tabs they’re used in. That’s a really nice feature. But how do I color SVG icons in other places such as image combo’s and prefilters? Of course I could color SVG’s manually but I much rather control this in other ways such as themes and conditional layouts. I’ve tried conditional layout but it only affects text unfortunately. I would also like to be able to add padding to icons. The only way I have seen so far to make icons in a grid smaller is by making the column narrower but that’s not always an option. We’re on version 2019.2.

Is there any easy way to set focus on fields within mobile apps. The layouts don't seem to work.

What is the trigger to update ‘modified on’ within templates ? I see in my merged version using Full model, item Templates that when I sort on ‘modified on’ some templates have the same date as in the previous version (Trunk or Branche) and some not. But when I check the needed changes in that templates the changes are there ! It would be much better (and more trustfull...) if every changed templates has the right (=last) ‘modified on’ from Trunk or Branche, depending the chosen merge-action. I read the topic  'How is code history in templates supposed to work?’ but I'm talking about the date modified in the template itself

Is it possible to test offline functionality in the 'debug viewer’.

Is there a way for a user to see which screens and records he has opened lately, with the possibility to navigate to them right away?

A user of the web GUI wants to create a new password for his user account. The authentication methode is “IAM” and login verification is set to “Password” in IAM. Because we host the application on our IIS for multiple customers, we are the administrator of IAM for these customers. I know I can set a new password in IAM myself, but I do not want to know the users password. So I want to let him change the password himself. The settings “Allow change” in IAM is set to “True”  and Expires is set to “Change after login”. The user is able to set a new password in the following form:   After changing the password, the following message appears: So far so good. But when trying to login with the new password, I get an error: But the user can login with his original password, so the change/update did not work! Same problem when trying to reset the password via the option “Change password” in the blue tab.     The Application Pool user has owner rights on the database, so that should not be the

how to create sql sequence in SF 

I have multiple users and I have to assign opening objects or landing page as per the users.. eg: buyer, supplier, management etc. When ever a specific role user logs in, he/ she is suposed to land on respective screens.

How do I make a cube editable? Like this:   

The Windows GUI can recolor black SVGs to match the label color, but the Universal GUI needs SVG's with no color. Should I uncolor all my SVGs or should I wait for a Universal release which fixes this?

Hi,   I am trying to get an application for mobile up and running. I have made a small test application and deployed it on a test server using our test_iam. When trying to log in using the desktop viewer I receive the above error. The network tab in debug shows no error. Using insomnia I am able to login to retrieve the metadata using the same credentials. The IIS and indicium are working fine, we are also using it for communication with our webshop. I checked all iam user settings, but they seem fine since I can start the application with the desktop GUI as well. screen login:   What am I doing wrong here?  

Is it possible in some way to expand and collapse all items in the Resource tree view with the Resource scheduler? Currently the resource tree is fully expanded by default but I would like to be able to collapse them all in one go if possible.

Although I didn’t learn about this in my standard SF training I recently found out that there is a way in the SF to make a column unique by creating a unique index. See picture below:   I wonder if this is common practice when one needs a value in a column to be unique? Are there any drawbacks that I have to take into account? I also wonder why this option isn’t available when creating the column?

The new version of the SF 2019.2 has a new prefilter "My projects” who's default active. The Software Factory doesn't recognize our NIVERPLAST project as "My project” anymore. I don't know the exactly prefilter conditions but probably this prefilter is watching to the database-user in combination with the user who created the project in the SF or something like that?  For me it feels like a bug but maby there is a good explanation for it?    Project: … (Hidden behind prefilter "My projects” )  Prefilter "My projects” default ON    

I like to create a very simple grid to add and maintain records in a table. To make it even more easy for inexperienced users, I like to create an ‘Add’ button in form, with a task without logic. Result:   To let it work I like to make use of a simple process flow. For some reason, it does not work. The process flow monitor remains blank. What am I doing wrong?          

In our application we usually allow the standard export of a table through the button on the lint. In many cases though there are columns which are used for calculation of presentation but are not meant to be exported. It would be handy to hide these columns from the list of column to export when the user chooses the advanced export. Unfortunately hiding such a column in the ‘Subject’ tab or through a layout does not have the desired effect of hiding it from the export. So the question is: is there actually a way to hide a column in a table so that the user can never select it for export?

We would to be able to send whatsapp messages from the application to users, in this case employees. Has anyone done this with the SF? Pleas let me know.

Apparently the mobile app starts resizing the columns to a “collapsed format” when the screen size is lower than 800px. It looks like if all information for the entity is displayed in a single column, this give the following result:         Both images are the same grid. Is there an option or setting so we can force the display of the grid to not collapse this information, and start showing the configured columns (second image)? 

I'm trying to let the end user import ‘large’ sets of data (CSV/Excel) into the database via the Web GUI. It's not that large as in this (https://community.thinkwisesoftware.com/development-13/best-practice-for-inserting-large-amounts-of-rows-into-one-table-837) thread, but large enough to let the web interface time-out. The problem then is that the import is partially done: It could have imported for example 3k of 50k records. The end-user doesn't know what to do: What part is partially imported? And how to fix it? I'm trying to speed this up, but I can't really increase it's performance. When I take a look at the debugger in de Windows GUI I see a lot of database-calls per row. For each row the default and layout concept are triggered, and the record is inserted per piece. Imagine you want to insert 50k records, and each cycle takes only 5ms, but when it's multiplied with 50k it's 250 seconds. From a user point of view this is absolutely unacceptable (besides it probably crashes in t