Questions & Conversations

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.   

Hi,I created an index on 2 columns to get unique value. columns However, I am running in below error in creation : An unknown error occurred while executing 'create unique nonclustered index "unique_invoice_number"on "invoice"( [INDEX_COLUMN_DEF]) include ("company_id", "invoice_number" )'. Error: 'Column name 'INDEX_COLUMN_DEF' does not exist in the target table or view.'. Please let me know what am I doing wrong?

I'm looking for a simple way to process barcodes read with a wireless barcode scanner. I can configure the barcode scanner in such a way that it sends a TAB after every barcode that is read.I have already tried to get it done with a table task and also with a detail form with auto save option. Both solutions do not work flawlessly.A multi-line field could also be possible, but the GUI expects an ALT+TAB at the end of each line.What is the best approach for an application running the Windows GUI?

Hi guys,I’m using color selector as a control for a domain and I’m having trouble understanding what the database output means.I saved this color: and its being saved as this int: how do I get the RGB value from this?

Going to the Session log page in IAM the User Action log is empty for I can see in the Session Log entries when users log in, but their action log is empty . 

hi,We created a base project to use specific tables in multiple work projects, and added translations for EN/NE. When I link this base project, the translation objects are copied, but not the specific translation texts.Do I need to start an extra task or something? Can’t find any documentation on this.

Hi Community, I've been tasked with solving the following issue: Show a different screen type when device is a tablet. The first thing that comes to mind is the Breakpoint setting under Screen types > Form. Unfortunately this won't work due to the fact that your average tablet has a greater resolution than the average computer screen. When using CSS in websites this issue can be solved quite easily. The following solutions are available through the use of media queries. Solution 1: use a media query that checks the DPI or DPPX of the device. https://developer.mozilla.org/en-US/docs/Web/CSS/resolutionSolution 2: use the input type of the device to check device type: https://stackoverflow.com/questions/12469875/how-to-code-css-media-queries-targeting-all-mobile-devices-and-tablets/42835826#42835826The second solution might break when using a 2-in-1 laptop with touchscreen OR a tablet with keyboard and mouse.The question is: Is it possible to change screen type based on the input type

Hello!I have this error in the error log "Process action "connect_to_api" in process flow "process_flow_test_api" in application 2 returned the following message: "The external webserver (…..) responded with the following error: 'The remote server returned an error: (401) Unauthorized.". I have tried to call the process flow from Postman with the Post method and I get status 201 Created .We have a client certificate on that server and my ip address and the ip address of the app are whitelisted.Do you know what can cause this error in the error log ?