Solved

Hello, I have a Task which is desired for adding a certain Item. The settings looks like this: The issue I face is that my layout display a certain amount of columns based on the data that was chosed on the modal pop up. For example if I chose a type of X, then I would have a certain amount of fields shown on the screen. If I swap from X to Y, then less fields would be shown on the screen.For the instance, the layout holds and displays good when the type displays mostly all of the fields on the screen but if I chose an item that has a few or bearly none fields to be displayed, then the modal will be automatically resized to have just 1 column. This is where I encounter the problem, because if I switch back to X, then I will have just 1 column in the modal, instead of 3 as it was originally.Example:Step1 - Initial layout Stept 2 - Changed the row type to something that display less fields Step 3 - Chose back the initial type. The layout does not have 3 columns again. What should I do in

In the release notes 2023.3.12, the HTML and Multiline in Grid controls were mentioned.For my understanding, is it now also possible to have multiline HTML in a grid field?And achieve something like this?  

I am creating an api link and need to upload an image as BASE64 code to add it in the GraphQl string. However, I only have the reference to the disk of the image in the database. How can I convert such an image to BASE64 code using TSQL?

Is it possible to control the amount of columns the filter form will grow to? I would like to set it to one column on a specific screen.

Hello! Is there any way we can resize the task tiles? We want to make them smaller. 

Hi, When we do an export (immediately) from our grid the column order in Excel is based on the table column order. However, in the subject, the order is different. Is it correct that the export uses the table column order, and not the subject order? And if so, can this be modified?We have a table and a variant with a different grid order.. so the table column order is not ideal. Thanks! Blommetje

After changing the application logo, the old logo remains on the start screen of iPhones, even after deleting the shortcut from the start screen and remove the website history of the application from the storage.  Only users new users see the new logo when they save the application to the start screenAny idea’s how to solve this?

In our application we use a list-bar menu.To allow users to use the maximum space on their screen we want the menu to be (auto-)closed by default.The user can do this himself by clicking on "Auto hide". The menu will then be automatically hidden/shown.We have found that this can be set in IAM by making an entry in the user preferences at [Global] and leaving the checkbox for menu empty. The disadvantage is that this must be set for each user (possibly with a script). Not exactly an elegant solution.Is it possible to set this at application level in IAM?

Is it possible to hide the header that shows the column names of a table? In this case I’d only like to show the data:I expect the answer to be no since I couldn’t find the option under Screen Types.

Hello,Starting a task with a double-click in a grid cell is a very nice possibility. In lists we have read-only columns containing icons that say something about the status of the line. Consider possible errors found (in degrees) or whether there are linked documents or notes present.We have created tasks that allow a user to launch floating screens to get an explanation of the error or call up documents or notes. With the new double-click in grid cell capability we can in principle eliminate many tasks from the standard taskbar, making the screens simpler in the users' experience. However, all grid lists are in auto-edit by default and then double-clicking in uneditable cells does not seem to start the tasks. Are we overlooking something or is double-click still not supported in this situation? 

Im trying to hide the task icons inside the actions bar of a grid, however I can only hide the whole action and not just the tasks itself. Does anyone know how I can achieve keeping the actionbar without tasks inside it?Added a screenshot for reference. 

The Action bar control in the screen type can be used to control its position instead of having it always full width of the screen (component) and being on top. This is a great feature!The Task bar component seems to overrule the accessibility of the task in the action bar by default, but when the screen type also has the component “Action bar” it just duplicates. Will this be changed eventually to also overrule its location when the “Action bar” component is used?I have read that Filter bar and similar components will get the same rules as the Task bar currently does, so I would expect the same for those as well, when it has been implemented.Alternativerly:As of version 2023.3.13 of the Universal GUI there has been added a functionality to give a JSON to position the components order, so a “Hide” option would also work as I see it. So it would add,“hide”: [  “Tasks”,  “Prefilters”]Making it so the separate components will show them where they are positioned.

We get validation error messages for default Thinkwise validations that are actually deprecated:(It also throws an error while navigating to related object)How can we prevent that deprecated validations are ignored during validation?

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.

In the Web GUI when you choose “Export immediately”, it only exports the visible columns. When I use this same option in the Universal GUI, it uses all columns of the table/view.How can I enable the same functionality, as we do not want users to see the hidden data?

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?