Questions & Conversations

As of version 2023.3.12 the between operator has been added to the filter in the universal gui. However, when I apply this operator on a nvarchar, int or date field, the filter field remains unusable/read only. Does it require an extra setting to function or is this a bug? I am currently using 2013.3.13. Operator ‘contains’ and  ‘equal to’ result in an editable field, operator ‘between’ does not: 

The search/filter option in the Universal GUI seems to change its appearance depending on the amount of space available.1) Search bar, ready to type2) Looking glass icon that you click to enable typingOption 1Option 2Option 2 after clickingCan I force it to always be the 2nd option?This to make screen uniform, as sometimes you can have both options in one available screen (because of detail tab that has less room). Some of our customer will not understand why they will differ in screen.

Hi there, I am wondering where I can find /  download the Thinkwise Extractor.I am currently attempting to upcycle a legacy application to see how much time we can win by using the upcycler. The application had a MariaDB database, which i converted to a Microsoft SQL Server database. From there, I want to use the Upcycler, According to the docs (https://docs.thinkwisesoftware.com/docs/upcycler#extract-the-metadata-from-your-legacy-application), the first step is to “Extract the metadata from your legacy application”. I am investigating if I can use the Thinkwise Extractor for this. I read that it is a command line tool, but I cannot find it in our Thinkwise installation or TCP. How can I make use of the Thinkwise Extractor? Thanks in advance! Nick Janssen

Hi,Since this morning our previewer does not work in the web gui. It works  fine in both Win and Universal.Also, downloading the file in the Web gui works, so the paths should be ok. oh ohAny thoughts on why this is? I don't have a clue now. Blommetje 

We are thinking about running 2 instances of Indicium to separate the load. We want to keep one for use with the Universal GUI and another one for possible external processes (which might put more pressure in the service). The thing is that Indicium is responsible for running the scheduled system flows.Is this possible without both indiciums trying to run the scheduled system flows? 

I have a screen where people can add attachments. In this case an '.msg’ file has been added. When clicking on the row, the following error comes up: This does not happen on all computers where the application is used.This is the screentype we have created for this part of the screen, which contains the 'Preview component’ to show the content.The error does not show up when other files are being used, for example a .png file.On the computers which have this problem Outlook is installed, also the preview in Windows Explorer does work: I suspect the customer has prevented the use of some files which Thinkwise needs to preview this type of files, but I don't know what files is needs.How can I solve this problem, of where do I need to look to find the solution? 

Hello, I am trying to synchronize the tool but when i run the peak filters, it keeps canceling itself and not calculating all values.  

Hi,Short question, but since the latest upgrade of the SF the step in page ‘Generate Source Code’This step sometimes takes around 15 minutes. I can’t explain why, since we do not have a crazy amount of ‘Functions’ in the code group: 14. All quite simply functions as well, e.g. get usr_id, get_dateAny thoughts on why this specific step (other are crazy fast!) takes so long, and what can be done to fix it? Thanks! Blommetje  

Hi communityIn our application we use the tsf_translate function for the translation of messages in our business logic (see post  for details) .However, we have some problems using the translated messages in unit tests. The function is depends on the session_variable ‘tsf_appl_lang_id’, but this is not set during the execution of the unit-test.Setting the session_context for ‘tsf_appl_lang_id’ in the preparation of a unit-test is also not possible, resulting in an error ‘Cannot set key 'tsf_appl_lang_id' in the session context. The key has been set as read_only for this session.’ during the execution of the unit-test.Any ideas how to test for messages generated by tsf_translate in a unit-test?Your help would be appreciated. 

Hello,we currently use a badge to show how many interface messages are in status ‘queue’. This works great when you display interface messages as a main subject, but when referenced from the perspective of a interface message type, the badge shown in the detail tab still counts all interface messages in status 'queue',  despite the interface message type to which they are linked. Is there currently something on the backlog to readjust these badges automatically based on the reference from which they are shown, or is this something a developer needs to take into account while developing? If the latter, what exactly is a best practice in this? Thanks in advance!

In my opinion, the prefilters Active- and Inactive users in the IAM users screen are misleading, what do you guys think?I would have expected the condition behind the prefilter to look at whether the user falls between the start and end date of the account. In the example below, I would expect this as an active IAM user.  Actual date 19-04-2023 is between 17-04-2023 and 21-04-2023What the prefilter actually seems to do is look at the user's log sessions.  from [usr] as t1where ((exists (select 1 from use_log_session l where l.tenant_id = t1.tenant_id and l.usr_id = t1.usr_id))  and (exists(   select 1   from tenant ra1   where ra1.tenant_id = t1.tenant_id     and (dbo.is_authorized_tenant(ra1.tenant_id) = 1))) )  and (t1.[name] = N'(In)active ((In)active)order by t1.[email] If my interpretation of active/inactive in previous example is wrong I would expect the prefilter based on current sessions to filter for users "currently" having an active session in the application. This does not

Hi,Is there any way to change the visualisation of the cubes in the universal gui? Or are there plans to change this? We would really like to use cubes more, since it is a great way to visualize the data, however the current visualisation has too many limitations to make it actually work.Here is an example. The rows are all displayed next to each other, and therefore takes up a lot of space. Also looking at the number it is not clear what row is a sum of what is below it and which rows are details of the one above.We want to have it look more like it is in Excel: Rows are displayed more compact, and with lines and bold text it’s easy to see what’s a sum and what is the detailed information. Is there currently a way to achieve this or are there plans to make this possible? 

Hi,Is it possible to generate a timeline within Universal? Does anyone have a creative idea for creating something similar to the example below? 

I want a drop down for merchant to view all the categories of products they sell.Can you assign treeview to a view? 

I was somewhat surprised that when I use the “print file” process action the printer is a mandatory selection:This means that we need to add all 100+ printers into Thinkwise. And any new printers in the future we would need to add and add a process action per printer to the flow. Not very efficient..When I email the pdf instead of printing I don't need to add all possible email adrresses to Thinkwise… Why aren't the printer setting parametrized like for example the email or ftp settings?Or is there another way of doing this (unattended printing without user interaction to any printer in the company).

In the software factory I defined a report with two parameters. These parameters also exist in the Devexpress file uploaded to this report. After running the report in the Windows GUI the debug info clearly shows the report was fed with the correct parameter values. However apart from the static headers that exist in the design the resulting file remains empty. No data is retrieved from SQL Server. I’ve tried both PDF and XLSX as output with very similar result.When I open the file in Devexpress from the cache folder as mentioned in the debug info and then enter the same parameter values there the report does work. This suggests the GUI does not communicate the parameter values to the report.I haven’t seen a form or task to link a specific parameter in SF to its counterpart in the report file so I assume parameters in SF need to have the same name as those in the report file. Is that correct? If so what could I do to make the GUI produce a complete report?

We have a web application built in Thinkwise on Azure SQL Server. Currently all our user need to be registered by admins manually. For our web application we want to build in a self registration for unregistered and unknown visitors. We have some instructions by TW, but has anyone done this before and how did you solve this? 

After upgrading 2023.1 to 2023.3.12.0 the icons in the menu and the tasks are lost.   

Normally the top menu and the filter (in the menu) are shown there. But sometimes the application crashes and there are red crosses shown…  there is no error shown before or something.  

If we don't have outlook open we get the following message when using the mailer:If outlook is open then the mailer does start up in outlook. 

I have a task in a tree-view to jump to a given date in the scheduler (calendar). This is a detail tab of the tree view. The task starts the process flow below. Unfortunately the activate scheduler returns status code -1. What could be the reason? 

When i set a task to refresh after execute to document(in the tasks table task settings), but also include the task as the starting point of a process flow, it seems the refresh is no longer executed. Is this behaviour intented or a bug/oversight? Because although i can use a refresh action in the process flow, the task refresh, does the entire screen. In the process flow i’d have to know exactly all the tables that are in screen and need to be refreshed. Without building the process flows dynamically is there i way i could achieve both? Have the task refresh the entire document and be the starting point of my flow? Tnx in advance.The reason i need the task(1) in the process flow is to start another task(2) that has a windows command, i also need the task(1) itself because it has a template.

Hello everyone,We have a label with long text which we want to wrap to a certain width but not to violate the css of other tags. I guess we can go with a overflow-wrap: break-word but not quite sure how we can fix it and which class do we need to change.

Can we exclude the usage of images in an HTML control?We need HTML formatted text but the users are not allowed to insert images.I'm hoping to find something better than issueing a message AFTER saving the record :pWould be a pity if someone is typing a big long text with images only to discover afterwards that he/she shouldn't have used the images...

I receive following error when exporting from the universal gui:The value 'xlsx(include_headers=true, translate_headers=true, translate_data=true)' is invalid for parameter $export. Valid values are: CSV, XLS, XLSX This happens using universal gui versions 2023.3.12 and 2023.3.13. I have no problems exporting when using universal gui version 2023.3.11. Similar errors are generated when using different settings when exporting data.I am using indicium 2023.3.11, platform version 2023.3.