Questions & Conversations

How can I authorize a role column based? In the Software Factory you assign rights on a table.Read rights on the table "employee”  In the column rights you can set or the fields are visible in the GUI. This doesn't change the user right to consult the data from the column directly on the database. Column employee_status acces type "Hidden”  The user still can run the query in the SQL database and select for example the colum employee_status. The permission should be denied for executing this action. Select statement in SSMS  

There is a http request in my workflow. But before sending the http request, I want to compose a process variable with a json format.I tried this with tasks and functionality, but it's not working. (I checked this in the process flow monitor).Is there a way to modify a process variable in the process flow, so I can use it further in the process flow?

We have a task which re-calculates an invoice based on new dates the user can input.this sometimes results in a record that no longer should be shown under the filters active on the screen.we would like to immediately hide these records when the task concludes. is this possible, and if so how would I go about making it happen?

We currently only use the Web GUI on which we apply a maximum of 1 concurrent users per account, to prevent account sharing. This works great, except that we actually planning on developing an application on top of the rest API of Indicium.What can happen is the following:The user is logged in in the Web GUI. We have developed a plug-in for another piece of software to generate an export file. This export file can be exported in the plug-in and uploaded again in the Web GUI. But instead of all those manual actions of exporting, uploading (several clicks), we want to allow the user to directly upload that export file.This is already possible using the Indicium OData API, so that's achieved. Problem is that when you are logged in in the Web GUI client, you will get a http 403 error in the Indicium plug-in on each call when you’re also logged in in the Web GUI, due to the concurrent access restriction. Off course this is by design I guess, but prevents us from add some really valuable ext

We require a change of the translations of the “Forgot Password” link in the Universal Login page as well as the subsequent screen objects in Indicium Universal as they do not really correspond to our liking.Question:How do we go about changing these translations of the screen objects to what we want ?

We have setup the SMTP on our Azure Acceptance env with all the required information, however we fail to send an email from our Azure AD user using the O365 smtp. O365 configuration:SMTP Host: smtp.office365.comSMTP Port: 587SSL Protocol: OFFTLS Protocol: ONIndicium configuration with SSL ON: "Email": {            "TwoFactorEmailMessageService": "TSFSmtpMessageService",            "SmtpServer": "smtp.office365.com",            "SmtpPort": 587,            "UseSSL": true,            "SmtpEnableSsl": "Yes",            "SmtpUsername": "notificationsuat@hartmannship.onmicrosoft.com",            "SmtpPassword": "*******",            "SmtpFrom": "notificationsuat@hartmannship.onmicrosoft.com",              "SmtpFromDisplayName": "UAT Notifications",            "DefaultPasswordResetTemplate": {                  "FromEmail": "notificationsuat@hartmannship.onmicrosoft.com",                  "FromDisplay": "UAT Reset Password",                  "Title": "Password reset token",                  "B

How can i connect to an API from Thinkwise? I build an CLR assembly in Visual Studio to send requests to an API.In SQL Management Studio is it possible to create an stored procedure that's linked to an CLR assembly. Then is it possible to execute the assembly.In Thinkwise I created a subroutine to add the CLR assembly. (This works fine). But how can I execute this CLR assembly by using functionality or subroutines? Or is this not the way to send requests to an external API?

I have created a pair of new tables in our model. they have have appeared in the gui but not quite in the desired place.the tab [administratie_meetinstrument] should be heremeaning under monitoring & meting which itself is under the tab 'inrichting’how could I move the tabs there?[administratie_meetinstrument_schaal] should remain as a subtab to [administratie_meetinstrument] but i am assuming that wil happen automatically. is this a correct assumption?

I'm trying to add data to IAM 2020.2 via an external program*. I try to do this via Indicium. What I can do with the Windows / Web GUI, I can't do with Indicium. I've managed to find out that the following error happens:dbug: Indicium.Controllers.TableController[0]     Cannot commit the resource for entity 'gui_appl'. The layout procedure has made the property 'mobile_proxy_address' mandatory, but no value was supplied.This happens when I do a post call (with PostMan i.e.) to https://localhost:5001/iam/iam/gui_applwith the following content:{   "project_id": "my_project",   "project_vrs_id": "1.00",   "active": "true",   "db_name": "my_database",   "order_no": 10,   "server_id": 2,   "max_concurrent_sessions_per_account": 1,   "claim_timeout": 1,   "gui_appl_alias": "my_database"}It only happens when the application platform "Mobile" is enabled. According to the log message the field mobile_proxy_address is missing. So I've tried to add it, with "", null and '127.0.0.1' as va

Will our form filters be available in the Universal GUI?  

Since 2014 we started with our standard Thinkwise application JP-Bouwmanagement for the construction industry as a Windows application. Every customer is using the same version of the application.Last year we created a web server (Microsoft Windows Server 2016 Standard, x64, quad-core, 32 GB) to host our application for customers who wanted to switch from Windows to Web. SQL Server 2017 runs on a separate server (Microsoft Windows Server 2016 Standard, x64, quad-core, 16 GB).We are now using one installation of the Thinkwise Web GUI. Each customer website in IIS points to the same Web GUI folder. Of course each website has its own Application Pool User for permissions.Performance is okay, but it could be better. Currently about 25 customers are using the Web GUI to user our application. Each customer is using their own database.Is this setup on IIS best practice? Or is it better to create a Web GUI folder per customer?Can anyone advise us on how we can improve performance?

In our application we have a table bijlage that is linked to different subjects. This table contains a column bijlage in which the filename (including full path) is being stored.Because inserting a new file is a lot of clicks, I would like to use drag & drop. I already saw the blog about inserting records with drag and drop, but I was not sure if this was applicable for files.Do you have an example of how to implement this with files?We are still using TSF 2018.3. Is this even possible with this version?

I want to add a column to the include columns of a generated index from a reference. I could create a new index, but then I would have index on column A and index on column A with include column B. Since having too many indexes is not optimal for SQL server I want the existing reference index to have the include column. How do you correctly modify an existing index created by a reference? Is there a way to do this in the sf without resorting on the dynamic model?

Is it possible for a customer to create it's own formula based on the data of a grid? Kind of like an Excel Formula?

Does anyone have experience with displaying external websites within a Thinkwise application (WebGUI), using the document previewer?I am trying to display a sharepoint page in this way within the application, but so far without no success. It looks like a cross domain problem.I wonder whether the solution should be found in Thinkwise or is it a setting in Sharepoint?

Hi all,I have an overview of Shipments. Shipments move items (e.g containers).  An item is connected to a shipment.  In my Shipment table (the start of my app) I want to use the filter for searching on Delayed/Active/etc.  Shipments. This works fine. But I also want to search on Items and Packages. So, i want my filter to go through the table 'item’ and show the info. Is there any way this is possible? This is set up as followes;  

In the detail form we want to change the order if 2 fields depending on a certain value of a field in a row. Is this possible?Example:Field 1 has value "A”In detail form you seeField 1Field 2Field 3 Field 1 has value "B”In detail form you seeField 1Field 3Field 2 I was thinking about a solution using extra fields that are turned on or off via a layout procedure, but maybe there is a way via a functionality to just order the fields on runtime.Thank you

I trying to create a unit test for a task where the user can input a xml file from an external source. I'm facing the issue that those files are always larger than the input field length, even if i try to minimize the xml as much as possible (unit_test_input_parmtr_overview.input_value = 1000).Is there a work around for this? 

I have updated an Universal GUI environment from 1.3.1 to 1.4.0. I have been logged in before (in 1.3.1), so a pop-up like above shows up*.Thing is here, that Universal doesn't say so much for our end users: What is it? And what is updated? They will ask. To place this in perspective: We’re an ISV: We ship the software to multiple customers having no knowledge about the Thinkwise platform and terms like Universal GUI. For them it's just a website, or a GUI. What does a ISV customer expect when clicking Update now? Updating the complete application? What's changed?I think this is not clear for our end users and only raises questions, which I want preferably to avoid. Is it possible to ignore this message? Or is the message editable, so it makes more sense? To be honest we don't want to bother our end user with GUI updates (which should be done automatically). The only updates we do want to bother them with, are the end product updates. Because that's probably something they're actually

This is an Archived topic.GoalReplace all existing file links in an end product without manually writing an update script for every table. This can be used for migrating file systems or DTAP-deployment.SolutionI wrote a script that replaces all file links of domains with control ‘File link’ and ‘File upload’. The script gathers the tables that it can update from IAM and builds an update script.Use CTRL+SHIFT+M to fill the following parameters: 

Hi all,I have a screentype with a big search on top. However, after searching, I go into editing found record, I do not it anymore. Is it possible to set a different screentype for the Edit-mode ? Or turn it off (hide it) in some other way. Searching:  Editing:  

I would like to start testing the new universal GUI on Azure. Is there any documentation available how to setup all the bits needed to do this?

There is an option to add custom code to the Upgrade code group to do for example an insert into a table. However, how do I use this when using a branch? for example if I have a table with 2 rows and during development I want to add row number 3.  trunk version 1        2 rows exist   branch version 1  2 rows exist   branch version 2  3 rows should exist    trunk version 2        3 rows should exist Branch version 2 is merged back to the trunk to create trunk v2 and trunk version 2 will be used to do the upgrade from trunk version 1 to 2. The actual insert is developed in branch version 2. Now I have two options: option 1: If I use after upgrade always then the code is in the upgrade script every release untill i delete it  manually. option 2 :If I use after upgrade from branch 1 to branch 2 then insert part gets lost in the trunk version 2.  How do I do this correctly? If I have to do it manually in trunk version 2 then it beats the purpose of the upgrade script part.  

How can I import the Insights demo into my Software Factory? I have a Thinkwise_insights zip containing iam.bak, Insights.bak and Insights_IAM_PROD.bak. Of course I can import them in SQL SMS.Thank you in advance!

Using TSFReportMailer is already a very nice feature in Thinkwise, however, we would like to know the status of a message:has it been sent not sent (perhaps reason / error report) message still in queue on mail serverIs it possible to obtain this information, and, if so, how and/or where (preferrably with example) thank you,Paul