Questions & Conversations

Combined filtering is possible on the main table and on detail tables.For the main table it gives the translation of the main table in the attached combobox.How do I change Details to the description of the related detail table(s)? In a related issue I saw:A tooltip on the combo box. I noticed that this is automatically generated. How do I change the content? In IAM it is possible to DisableFilterOnDetails (Application>Extended properties). Is it also possible to set this in the SF? And can I set these for specific tables, so creating the possibility for certain tables to have this and for others not to have this. Preferably without having to create table variants with different filtering-options.

Our accountant need a report or view of application users and their access groups and roles. Is it possible to generate a "Roles and rights" reports or cube like this (IAM 2021.1)? I don’t have time and IAM/TSF table experience to build it from scratch in a timely fashion. If somebody willing to share a SQL query to start with would be awesome.

We use 4 prefilters for a number of screens:show everything show only location A show only location B show only location CThe prefilters are grouped in an exclusive group. Is it possible to overrule the default setting ("show everything") based on a value stored in the database per user? So that user 1, for example, gets the prefilter "show only location A" as the active prefilter, while for user 2 "show only location C" is set to active by default? 

In tab header the number of rows are displayed.Can we get the display of the number of rows which we call through a prefilter.In the prefilter I make a filter on product.In the example we should get 0 instead of 3  

I checked the feature matrix but I can't find anything related to the feature to disable the confirm button in the universal GUI. It does not seems to work. My script works fine in the Windows GUI but the button is not disabled in the universal GUI. DOes anyone know about this behaviour.

In the Universal GUI you can show a message as a “Snackbar” in the bottom of the screen.Is it possible to change the duration before it disappears? It currently disappears after around 7 seconds. I think it could be shorter (in some cases). We want to use it as kind of a confirmation / acknowledge a user has executed a task.

I like to do data mutations from inside a cube by using a taskFor some reason field values are not passed accrossCan anyone explain what are the requirements for using tasks in combination with cubes?

We use the Dev Express report component for previewing reports in the Web GUI.With Web GUI version 2021.2.10 there is a configuration option to set the default zoom level “DevReportZoom“.The values that are documented are 1 for 100%2 for 200% etc.I noticed while testing this that when i set the value to 0 the default zoom is set to “Whole Page”.Is there a value i can use to set this default to “Page Width”?

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.