Thinkwise Platform

Hi all,Who hasn't experienced this? You're testing your SQL code, only to discover that you're getting more results than expected. In some cases, accidentally using the same alias within the same join- or where clause can lead to this scenario. For example, “where t1.customer_id = t1.customer_id”. This effectively creates a condition like “1 = 1”, which is always true.In this small blog, I'll guide you through detecting this situation throughout your branch's codebase. To effectively follow this blog, you'll need access to a code editor that has built-in support for regular expressions. If anyone knows a more efficient way to achieve the same results, please share it in the comments. Hopefully this helps!Software FactoryGenerate the code files using the Software Factory:Start up your Software Factory. Switch to the desired model and branch, for which you want to check identical aliases, by starting the task Models > Switch branch. Go to the screen Deployment > Creation. Generate

For a CLR procedure it is possible to register an DLL assembly, so both can be deployed with the Software Factory.However, this will fail when the assembly is not signed. You can bypass that by adding the assembly to the trusted assemblies, using sp_add_trusted_assembly. Is there a formal way to also incorporate this during deployment?For now, I simply insert a script in the dll-assembly code that calls sp_add_trusted_assembly. if not exists ( select 1 from sys.trusted_assemblies ta where ta.hash = 0x11986168BBC9874F203A9A7F2935E621F4437A4B668E816EC57372C69E92221B4044E996868A5EE4D75A038532EB3B10D1C367EDD87B67FFA608B77F8FDF8A8A ) exec sp_add_trusted_assembly 0x11986168BBC9874F203A9A7F2935E621F4437A4B668E816EC57372C69E92221B4044E996868A5EE4D75A038532EB3B10D1C367EDD87B67FFA608B77F8FDF8A8A, N'for_your_eyes_only'go/* Create assembly for_your_eyes_only */create assembly "for_your_eyes_only"from 'c:\our_assemblies\for_your_eyes_only.dll'with permis

Hi, I have a table account_authorization. This has a pk of tenant_id and account_authorization_id. When I want to stage/patch/commit a request through indicium, it throws a 400 bad request. I try: …/account_authorization(1,1)/stage_editI don’t think I can expand this through the tenant_table, since that is not supported for staging if i’m correct. In Short; How can I patch this table? Blommetje  

How can I see in Universal that a screen is limiting its result by the “max. no. of records” when applicable?Some screen we have set a limit for performance reasons, but I cannot seem to find when a screen is limiting my result or that is falls right in the range.

How can I change the resulting filename of a report after it has been called?I have tried to use the “Export path” property of the report, but this seems to not affect the result in the Universal GUI. In de Windows GUI I can see this field and it does change the filename.We would like to have the name generated by the selected record they are creating a report for instead of the translation of the report.

It appears that you cannot drop a grid line on top of a card-list item that hasn't got the focus.. Hovering over the intended card list item doesn't activate the card. In stead it's added to the one with the existing focus. Is this a bug or still under development?Situation:Card list with a grid as details that consists of planned activities. The idea is to drag a planned item and drop onto another agenda (card). When you drag the grid line to the card list the component gets activated, but never the card. 

How do I make use of the Report actions in Universal? When I add a parameter with the property “Action”, I do get the dropdown available in the Windows GUI, but in Universal it does not appear.In want to give user the opportunity to choose their export preference as “Print preview” now defaulted to exporting PDF. There is no option for them to choose for example Excel, Word.

The documentation says that filters are nog supported for HTML/Multiline fields. (See https://docs.thinkwisesoftware.com/docs/sf/subjects_data#filter-conditions)What is the reason for this? What other options do we have?Is this on the roadmap?I assume adding a hidden single line expression field that contains a copy of the HTML data is not the right way?  

At this moment we like to activate column grand totals en set field widths.Can someone give a complete overview of which cube features are or are not already available in the Universal GUI? 

Hi, Recently we have added two reports in our app. These work ok, no other reports. However, since we added them, our deployment breaks. Executing Database Server script 'MODEL_SYNC.sql' - sync_role_tab_variant_reportError; Cannot insert the value NULL into column 'tab_variant_id', table 'CENTER_ERP_IAM.dbo.role_tab_variant_report'; column does not allow nulls. UPDATE fails.We use both reports on 1 table, we do not have report variants nor table variants in play here . I have applied the rights - several times and checked the settings. Do not see anything weird with it. When I comment out the code from the model_sync.sql, all seems good. Any thoughts on how this can be fixed? What could be the cause of it? Thanks!  Blommetje 

1.For some reason I cannot change the with for the columns from a Pivot.I have tried several values in the ‘Field width’ settings of the ‘cube view fields’ bat that has no effect. and it's not possible to change the with in the GUI itself (by dragging) either.(we are on the latest versions:Patforrm  2023.3 UniversalGUI : 2023.3.12.0.0, Indicium: 2023.3.12.12.I need to block the first (green) columns, when scrolling to the right. in a normal grid this works pretty easy, but I can't find out how to do that in a pivot. 

When I try to log in using the Authorization Code Flow with PKCE, I expect to be able to disable the client_secret, since we are using a SPA and do not want to expose it in the frontend. However, even with PKCE enabled, a client_secret still seems to be required, as shown in the following error message: "Client secret is required for authorization_code, but no client secret is configured."Is it possible to configure the Indicium authorization server to not require a client_secret for public clients using PKCE?

Despite checking the following fields on the cube view I created:Screenshot of cube settingsI am unable to show the row totals in a pivot grid. Both the row total & row grand total are not working at the moment. Is this a known issue or am I doing something wrong with the settings?Next to checking the 2 boxes, I experimented with adding a “Total” for the cube view field (of type “Data”) I want to be summarized with no success so far. It seems that adding a column total is working.I just upgraded Universal to the newest version (2023.3.13).

We have a web page (Power Page) where we a new visitor can register and become a new user.What we have in mind is to submit the user data to IAM using PowerAutomate and the Indicium API. However there is not much information (or incomplete) available in the documentation nor the community.How can we create a user in IAM using an Indicium API call (if possible)? 

Is it possible to change the name of the item in an open document to match the name of the table in combination with the lookup? As depicted in the screenshot below, we have multiple open documents, but it is not clear which document is the correct one. 

Hi , I am getting below error , its not the issue with reference as stated in This is is only coming in the acceptance environment.The same set of data used in developement environment works well.Can you please let me know what I am missing?  

When we receive a json containing data and the task that processes the data fails (incorrect foreign key for example) the response json is always returned with status code 200 OK.Can I change that?I see it is an output parameter but in the documentation isn't clear about if it is editable.

How do I control how wide the task fields are going to be?The window seems to open a fixed size, partially depending on the “no. of columns in form” setting, but I’d like the window to be wider as certain fields require more room to show/enter the values. Having tried “Field width (px)” and “Label widh (px)” in various combinations and with even large numbers, they seem to have no effect.Current version of GUI: 2023.3.13.0.0

Related topic: Row totalsHi there,We are currently investigating the possibility to use pivot tables in our Universal application (we have the latest Universal release). Our end-users think the following functionalities would be beneficial:Showing row totals (see related topic, I cannot get this working while column totals are working) Lock the dimensions which you choose to be rows (just like locking columns in a grid to the left) Formatting the display values. For example, show currency fields with a euro-sign. Conditional formatting. There seems to be a setting for this. but it does not change anything in Universal? Adjust the column width (by default they are pretty wide and it would be nice if it would be adjustable just like grid columns)Maybe some of these features are already present, that’s why I posted this as a question. If not, it may be an idea?

Hi, We have an app deployed at the client, where "nothing” has changed. However, something did break. According to the client they restored the data Db due to a problem but left the IAM Db untouched. After this restore, whatever we try , we cannot grant access to any user. We all can access IAM, but not the app. I've have copied the Db to my testing server and tried a lot. Deployed a new model. Made a new app. Removed all users groups. Deactivated and reactivated all modules. Reset users.. Did a schema compare to our UAT Db. Didn't show a thing.  In the Tenants overview - In the Current Access, i see. Users = x  Users groups = x  Granted Module = 0 (!) Granted Apps = 0 (!)When comparing with the LAB environment, all settings are the same. Any pointers on where to look? I would love to know why this ''suddenly’ stopped working and we can't fix it. Thanks! Blommetje

We have installed the platform Release 2024.1. After that, we can not start the Windows GUI with the SF as metasource. In previous versions it worked fine, showing all active runtime configuration apps in the the sidebar. This is the error: Stack trace: at Thinkwise.Shared.ObjectModel.SPResultTableReader.throwIfInvalid(Column column) at Thinkwise.Shared.ObjectModel.SPResultTableReader.GetStringInternal(Column column) at Thinkwise.Shared.ObjectModel.SPResultTableReader.GetString(Column column) at Thinkwise.Shared.ObjectModel.SPResultTable.get_gui_project_vrs.ReadCurrentApplication(SPResultTableReader reader, TSFApplication application, TSFSession session, String effectiveUserName, DBConnectionInfo connectionInfo, Boolean isFirstApplication) at Thinkwise.Shared.ObjectModel.SPResultTable.get_gui_project_vrs.ReadAll(SPResultTableReader reader, TSFList`1 applications, TSFSession session, String effectiveUserName, DBConnectionInfo defaultConnectionInfo, String originalLogin) at T

Is the “Resize columns” option also making its return to Universal? Or have I overlooked something?Manual resizing is available, but many users are used to the “Resize columns”.

At the moment, we show prefilters in the prefilter bar. The prefilters only show an icon, and no text. Unfortunately, it can be pretty hard to find an icon that perfectly reflects what the prefilter does. Therefore, a text/title can sometimes help. Luckily, this can be found in the overflow menu. Is it possible to influence each prefilter to define whether we want it to be displayed in the prefilter bar or the overflow menu?  

I have seen this topic, but that does not solve what I want.We have a TW application, running at several customer sites.One of the main forms is a view presenting a list of records.I want the possibility to add a default prefilter for an IAM user group. This prefilter will not be predefined in SF because the prefilter could be different per customer.  So this is a consultancy solution. There is IAM, Authorization, User groups, Group preferences, Default prefilters; but here I can only select a default prefilter as created in SF. I need to be able to create a prefilter in IAM, based on a column value.I find something that looks like what I'm searching for, but this is per user and making it ‘default’ does not seem to work. This is in: IAM, Authorization, Users, User preferences, Prefilters. Here I can define a custom prefilter using the ‘prefilter columns’ tab. Only I can't get it to default activate after loading the application. It can be manually activated though, using the ribbon.I

We like to access the IAM application within the Universal GUI.The user has already ‘Main Administrator’ rights. In the User Profile menu, the option ‘Switch to IAM metasource’ is not visible. I couldn't find anything about it in the documentation either. https://docs.thinkwisesoftware.com/docs/user/universal#profile-menu