Thinkwise Platform

Recently we've upgraded to SF2023.1 (with all hotfixes including 202300116 - Subrouting option copying from base models’ applied). Everything went well and we done some model generations with this version of the SF.However, after merging a branch recently, we’re facing an error during the execution of the functions. The creation of the function ‘tsf_original_login’ fails because the script contains duplicate lines for ‘returns varchar(128)’ and ‘with schemabinding’ How to solve this? Any help would be appreciated.

I want to setup an tw applicatio mainly for retrieving data by indicium, using the odata functionality. The data itself is already in the tables. I want to setup a user or role thet canb only read data, while another user/role can write also. The external parties want to access the api by a bearer token.Is there any documentation how to setup this? 

We noticed that the documentation for setting up OAuth doesn't correspond with what they see in Azure config panel, step 6 is the problem, Azure states that legacy API's are no longer supported since June 2022https://docs.thinkwisesoftware.com/docs/kb/exchange#configure-oauthHow do we set up Azure in order to get this working?

Hi. I'm a IAM administrator for some reason my own user is blocked for updates (cannot update my timezone and application language). What is causing this? I cannot find it. 

We are in the process of updating from TW2021 to TW2023 and during testing I noticed that in the windows gui one of our VIEWS no longer works as it used to do.When I open the VIEW I see the expected records and the debug shows the SELECT exactly as I would expect it (for readability I changed it to * instead of the individual fields):SELECT *FROM complaint_action_follow_up_action_gui AS t1WHERE (t1.complaint_header_id = 1682) AND (t1.action_id = 5);But as soon as I select one of the rows (form grid) I get a message that the selected row no longer exists:When I press OK the message dissapears and comes back again…. infinate loop…Looking at the data that is going thru the SQL server using an Extended event shows me this query (for readability I changed it to * instead of the individual fields):SELECT *FROM complaint_action_follow_up_action_gui AS t1WHERE 1 = 0;It seems to have lost all prefilter data causing it to always return NULL.When I do the exact same thing in the Uni

Is there a way to actually show the menu items (not groups) dynamically? I have a menu group with some options for employees and managers..  the fact if someone is a manager or employee is defined by the application. If someone is only an employee they don't need to see the manager option(s) ..  

Hi,When I make a change in a translation from say “Vat” to “VAT” this is not picked up. I works local, but my deployment pack does not make any changes in the web gui. Only when I add something (VAT.) it changes. Then I have to deploy this to all Client Environments (which can take some time, and needs to be tracked). Then I need to change it back to “VAT” in a new deploy. Quite a hassle, and for some reason this happens way more than I’d like to, with all the abbreviations everywhere..Is this a minor bug in the system, or do I do something wrong? Thanks, Alex   

My own plugin application is working fine from  inside a Previewer component in the Windows and WebGUI and also in the Universal GUI when the application in opened in the browser on the server that hosts IIS. But when I start the application from another PC the previewer remains empty. What can be the reason?  The plugin application is running from the same IIS instance as Indicium and UniversalIIS: The previewer should show https://test.xxxxx.nl/smartextenderWhat can be the problem and how can it be solved? 

We want to be able to check if an IAM application is active. We could sent an API request to Indicium to select the ACTIVE indicator from the GUI_APPL table for the GUI_APPL_ALIAS. But I was wondering if there is an easier and better way.  

In our use case, we have a history table which shows the value in grid as below:In order to get the valid from and valid to time as local but not UTC, the domain has been updated with time zone as Local from Show as stored.After this update, the data is not returning all the columns:Could someone help with this scenario?

Since the introduction of temporal tables, code history tables are gone. But when we make changes in templates, we sometimes like to simply see the complete code history, also changes made in previous project versions (/ branches).I don't think code the Code Review tab doesn't work that easy. Or do we miss something? 

Hi,In our application, the user selects a row and in the detail tab of that row there are multiple items. When all these items have been completed, the row in the main screen disappears from the view. This leads to issues, as the following error pops up: "Request error: The object cannot be found. You may not have sufficient permissions or the object may have been deleted." Or in Dutch: “Fout in de aanvraag. Het object is niet gevonden. U heeft mogelijk geen rechten of het object bestaat niet meer.”I tried resolving this by putting the task in a process flow which closes the document when there are no more items, but the error pops up anyway. How can I resolve this? 

Hi for a external application we would like to update records using the ODATA API. but we’ve noticed that updating foreign keys returns a `403 Forbidden`, but mutating the normal columns update fine.We’ve tried this using a PATCH/POST request and a STAGED record, both fail in the end. curiously the STAGED record only adds the non-key values to the STAGED record even when u try to pot a key in, it does not accept it.We currently work around this using a subroutine, but would be alot better if we could just mutate the record directly instead of writing subroutines for every table we need. Using a patch:Using a POST requestUsing a staged record, adding the key values in the initial post request results in only 1 column being added instead of 5 

hi,We have added a data conversion for a new, mandatory column in a table. The default value is an expression, getting the value from another table “settings”.The problem is, that this table “settings” also has some changes in this update, and the tabel is also rebuild during the update. So at the time the value should be calculated, the table setting is renamed __setting__ and the new table is empty. So no value is found and the update fails.Is it possible to have some sort of sequence in rebuilding the tables? Or how can I solve this issue?  

Hi all,  Is it possible to change filter form label to "Search on item#"?

The delete functionality does not seem to work on multiple rows at once, it only deletes one. Is there a setting I’m missing to make it applicable to all selected rows?

Hi, I need to process a large number of files in a folder, one by one. The files are in a folder on the local machines of the users. At the start of the process I do not know the name of the folder, and I do not know the names of the files. The application is using the Windows GUI. In a process flow I first ask the user to select the folder. This goes well. Then I need to find the names of the files. I would like to use the List Folder connector, but that is only supported in the Universal UI. And we are on Windows. - Because the files are on the local machine of the user, using SQL Server to get the file names also is not an option. Placing the files on a server instead of local machines also is not an option. How do I create an equivalent of the List Folder process action that will work for my application?  

Dear all,Has anyone done a move of the Web GUI scheduler Extender to the Universal GUI ?Can you provide instructions on how to move over from one to the other ?Is it seemless or we need to re-implement it ?Thank you

Hi all, I'm helping a customer migrating from Windows GUI on 2018.x to Universal on 2022+They are super happy with the looks of the new platform, but are held back by their reports in Crystal Reports. I am compiling a list of alternatives for them with their pros and cons. We have access to at least eight options in the SF, but documentation seems lacking on which options are (explicitly) compatible with Universal/Indicium. Of Devexpress and Inet Reports I know that they can import Crystal Reports report definitions, which is of benefit of course. Are there easy migration paths for the other reporting options? Which are supported in Universal/Indicium? Thanks for your thoughts and experiences! 

We are playing with the Power BI OData Service Document endpoint that is supported since Indicium 2022.2.17 and tried to get Suggestion 3 from this blog working (adding table name and select / filter criteria after the application.svc in the OData URL). We are able to load the https://my_server/indicium/iam/iam/application.svc endpoint We are able to load the endpoint example as stated in the below image (from the blog) We are not able to load the application.svc endpoint including similar Table name and select or filter criteria and instead get an 404 error. Is this functionality not supported by Thinkwise, or is the syntax supposed to be different?

 Is there more information available on how to integrate custom pages into the Universal GUI. Especially how the context sensitivity works and authorization..  how is authorization passed through as the contextual parameters? Custom components make use of the HTML preview component. All API features offered by Indicium can be used by these HTML pages. The HTML itself can be made context sensitive, for instance by using information from the current row. All available features of the Thinkwise platform are inherited. Any best practices here, extra info.  

A long title for a fast problem ;-) When I log in using the universal gui and I use a wrong password there is an error displayed saying the password is wrong. But, the message disappears after 0.5 seconds because ( I assume) the page is refreshed.  The Devtools seem to suggest this is because it is redirected to the return URL, which is basically the same as refreshing the current url: Is there something I can do about this?

I know this issue has been adressed by Thinkwise after an idea on the community. However, I can't seem to find anything in the documentation on how to change the translation of a button on the universal login screen. This is my problem: How do I solve it? 

Hi All,We have upgraded to the latest version and that went ok. Our automated deployment however, is off. Before, after all merges where done, we copied the latest version to a new version. So for example from 1.125.06 to 1.26. Set this as ‘production’ - set the previous version to 1.125 and the 020-upgrade script came out great. We then keep track of the executed scripts in _schemaversions, so we know if the script is executed on the db or not.  Yesterday I found out that this is no longer working ok. Lot of Db issues, and as stated here that it might ruin the Db. Well, it does.  In model Overview, I have a Branch ‘Main’ (prev. trunk) and several model versions. My build tool Calls the ‘deployment package task’. But all upgrades scripts are based on the version since the upgrade. So now in my repo I have three version; Version 004; 020 upgrade script “print 'Upgrade from MAIN (2023-02-07 16:21:11.24) to MAIN (2023-02-09 15:48:52.72)”Version 005; 020 upgrade script “print 'Upgrade from