Questions & Conversations

Is it possible to set up a task like below?I want a kind of tabular entry for some data. The closest I can get is this:But that is too wide, the tab sequence is not as expected and I would like to have the labels gone or at the top.

Hi,What is the maximum querystring/url length supported by indicium that actually will be parsed? Is this the same as the maxQueryString/maxUrl that can be set as a config setting in the requestlimits?: Request Limits <requestLimits> | Microsoft Docsrgds Ricky

In the feature matrix it is stated that the refresh process action does work. However when I update a detail (with a task, which triggers the process flow) and I do a refresh of the master object table, that seems not to work. Is this possible yet. Also the auto refresh function does not have effect (yet) in the Universal GUI. I'm afraid my conclusion at the moment is that users need to refresh themselves all the time? 

Hi,I have upgraded our environment to 2021.1. This is the first version with (mandatory) Indicium for us.In SQL Server Profiler I see that there is a query running every second that checks if there is a pending system flow: SELECT * FROM i_core_pending_system_flow WHERE date_time BETWEEN @after_date AND @before_date;At this moment we do not use (automatic) system flows, so my question is if it possible to change or disable this ‘every second’-interval?Thnx.Patrick

Is it possible that if I use a filter, that the prefilters will be turned off? So that I also get to see all the data that is behind the prefilters in the screen as well. 

I would like to know if there is an existing Stored Procedure in IAM that can return me the Application alias that I am currently logged in? 

Is there a way to create an Excel-file with multiple worksheets?Preferrably I would like to have a task for writing to each worksheet and connect them in a process flow with the write file in the end to create the actual Excel file.How do I do this?

Is it possible to start a system flow by using an Indicium API call without authorization?Or is there a workaround?We want to use this to verify an email address by using a link inside a mail. 

Hi, I've defined a view vw_tour_resource. Some columns of this view I would reuse in another view vw_tour_driver.When testing the query itself for the view vw_tour_driver, then in works fine. But when creating a new version, then I get an error I think the root cause of this is that the view vw_tour_driver is created first before the (existing) view vw_tour_resource as it is alphabetically earlier.I tried to influence it with Generation order no and Priority, but that seems not working. Tried with giving higher or lower priority, higher or lower Generation order no, but that seems not helping.How to fix this issue?  

We want to improve our automated tests on the web gui and Universal GUI. Currently there is a feature "Process tests" (https://docs.thinkwisesoftware.com/docs/sf/test_cases.html#docsNav). With this feature you can record steps a user could do in the application. This covers all situations that cannot be covered by unit tests. For example when a task is no longer visible due to a change in the roles & rights. Unfortunately there are some downsides of this feature;It only works for the Windows GUI It doesn't have a 'setup' and 'teardown' (clean database) It cannot be automated with ci/cd toolingBecause we only use the Web GUI and are also targeting the Universal GUI we cannot use this feature. We're investigating the possibilities to solve this. We are looking into Selenium WebDriver (https://www.selenium.dev/). This requires some programming knowledge (or you could use the Selenium IDE), but by using this we could cover all test cases. Because it's developed using i.e. C# we could a

I don't understand this validation. I have a table on which the primary key (1 column) is also used as look-up display value. This should be unique. The code like below illustrates it the best I think;-- code generated by the SF;create table dbo.[dummy]( dummy_id varchar(100) not null, dummy_description varchar(500) null, tsf_valid_from datetime2 (2) generated always as row start hidden not null , tsf_valid_to datetime2 (2) generated always as row end hidden not null , constraint [dummy_pk] primary key clustered ( dummy_id ), period for system_time (tsf_valid_from, tsf_valid_to))goinsert into dummy (dummy_id) values ('Test'), ('Test') -- second insert will failI think the validation is in this case invalid?

I have various environments with their own IAM. On starting IAM one opens with IAM, another with SF and another with an Other application.The order in which the icons appear is also different. And, it is not always the topmost that is started.AndSo two questions:How do I indicate which application to start on starting IAM? How do I influence the order in which the various applications are displayed in the lower left corner?

Hi,I am creating scanner functionality for the mobile GUI which also must be available offline. I have the possibility to insert a new scanExample of my insert.var db = context.application.getStorageContainer();var scan = context.application.model.getObj("scan");var inserts = [];var newRow = { date_time : new Date() ,session_id : rowObject["session_id"] ,product_id : rowObject["product_id"] ,scanner_id : rowObject["scanner_id"] ,slaughter_sequence_no : rowObject["slaughter_sequence_no"] ,weight : rowObject["weight"] ,is_vib : rowObject["is_vib"] ,processed : 0 ,deleted : 0 };var insert = (function (insertRow){ // add record return db.insertBookmark(scan, TSFRowBookmark.fromObject(scan, insertRow), true);})(newRow);This works great.What I now need is the possibility to do a select from the sc

Goodmorning, Is it possible to clear a form after an insert? I don’t see a setting for this. I tried also to do something with the processflow using the add action, but that also had no effect.I use a formlist in combination with a form. Thank you,Corné van der Linden

At a detail reference you have the option to do some Model settings. One of them is cascading delete, which removes all detail records that are linked to the removed parent record. Set null will probably reset the link to the parent to null.I also see that there is an option for cascaded update. I'm not familiar with cascaded update, and would like to know what it does and what to keep in mind?I'm currently working on a trigger that copies child records when a parent is connected to another record. Concrete: I have a table A with B as details. I also have a table C with details D, which has details E.For records of table C I want to select various A's and place them in the linked table D. But at the same time make a copy of the linked B's and place them in the linked E. Is this a situation that can benefit from cascaded update?When removing a record from table D I will use cascaded delete to remove the linked records in E. 

Our customer just wants to add a filename to the database without actually uploading the file itself.I get the impression that if you want to select a file and then retrieve its filename, you automatically have to upload the file.Is this impression correct? Or how can I get a filename (with or without path) by selecting a file without actually uploading the file?

Is there an easy way to see which items have changed in a given period and/or by a certain developer?This would be very helpful in reviewing changed of a co-developer.

EDIT: I didn't look good enough: Hi,I have a task that can be used in multiple ways depending on a parameter.I can make variants of that task with different default values so I can use the same task in multiple ways.But I noticed that I cannot add the same task multiple times to the same table. I understand that I cannot do that if they all use the same, of no, variant. But different variants should be possible I think!?For now I will duplicate the tasks, unless someone has a more elegant solution :)

Is there a way to set defaults for generating source code?Currently I always check the write options, but it would be nice if there was a way to set these defaults. And I was wondering if this is already a feature of the SF.

I would like to create a Dev Express report using the Reporting Service. Currently we are using Crystal Reports, which works fine using the Reporting Service, but I receive the ‘Het laden van het rapport is mislukt.’ - error when I try to create a Dev Express report. Is any additional action required to create a Dev Express report? The report itself contains a simple text field, I tried to create a report with and without a database connection.Data from the rapport_queue:id 114991 export_file_extension pdf export_file_name test export_file_path C:\Thinkwise\DEV2014\Testdata\webshop_obv\ report_file_spec C:\Thinkwise\DEV2014\Applicaties\cf_finas\4.59\Reports\report_devx_test.repx report_status 3 report_message Het laden van het rapport is mislukt. exporteren 1 geexporteerd 0 printen 0 geprint 0 printer_name NULL no_of_copies 1 mailen 1 gemaild 0 e_mail NULL mail_cc NULL subject NULL body NULL profile NULL mail_from NULL mail

Recently we upgraded our web GUI from 2019.2.17 to 2021.1.14. I noticed that nothing happens when opening a subject from the menu on the left when the subject is already opened. In the past the tab of the open subject was activated. Is this a bug?

Hi,I've made a barcode scanner view where i scan a barcode and it inputs the text behind the barcode.Is it possible that when i scan another barcode it automatically changes field “Barcode” with the new text? It needs to have the same effect as selecting the barcode text and scanning the new barcode. Is it something i can edit in Thinkwise or is it a seperate query that i need to write?  Barcode after scanning. Scanning a new barcode doesn't have any effect on changing the Barcode field (i need to select the field and the value in it to make a change) 

I want to set a default grid row height for all tables in a project.I found an option to set it for every table separately under the settings tab of Subjects  But is there somewhere an option to set a default for all tables/views?I tried to find it in Themes, but maybe I overlooked it? 

When we execute a print task it takes the parameters planning_tekenkamer_onderdeel_id and bgs_bestand. The report doesn't import the parameters planning_tekenkamer_onderdeel_id and bgs_bestand. 

For a console / touch screenapplication, I wish to deliver a full screen solution.Just one screen, which opens on startup, without menu, without ribbon.Would that be possible?