Ask a question or have a conversation about the Thinkwise Platform
Recently active
I made a process flow with (only) a message with options so I can define the actions depending on the user’s response.How does this process flow start? I presumed I could just use the message in my code and trigger the process flow with that but it doesn’t work.I want to use it in a default procedure in which I want to send a warning before deleting a row in another table. In this warning I ask ‘ are you sure?’ . When the answer is no, the process stops.It seems I cannot define a starting point in the process flow. When I use the message now, I don’t get the options in it.It has to be simple isn’t it…...if you know what to do 🙂?
Hi all,I currently have the following set-up, which is just not working great. It's slow, complex, and it needs a kick every day to get going. The current set-up. Task on 'origin’-table does an insert on the rpt_queue (table). Thinkwise reporting service picks this up, generates the PDF and places this in an output-folder NOTE: the .rdl file is not withing SF, but from a repo (so an outside party can create the rdl files!) Our home-made Service polls the output-folder. If a file is found, it is uploaded to our Azure File storage. It's final location is given back to the rpt_queue and 'origin’ table, so the file_previewer can display the file. Upside = it's what I needDownside = it's slow and never works well What I now want to try is this; Create the PDF through a task (with the .rdl from the repo) Save the directly to Azure file storage Get the final uri from the file and show in the File PreviewerAnd - this all must be faster than ..say… 10 seconds max? First of all, i'm not s
For example, consider a table purchase_order with a lookup to an address table.The link is made to the PK field of the address table.In the purchase order screen, I want to be able to show fields of the address as separate fields.I know it is possible to work with expression fields, but multiple lookup queries to the same table is not desirable.Concatenate address fields is also not what I want. I really want to be able to display the address fields as separate (read-only) fields in the purchase order table.Ideally, the main table 'purchase_order' will get t1 as an alias and the address table t2 as an alias, etc ..Is there a trick to get this done yet?
We have an internal API which consumes data from our Thinkwise application through Indicium. Up until recently we had been using Indicium Basic, however recently we have started our upgrade to Universal. For authenticating users with Indicium through the API, in Basic we used the URL indicium/(sf|iam)/<app_id>/$logout, to which we would send a basic authentication header supplied by the client calling the API. However, in Universal this endpoint does not seem to exist anymore. Is there a similar endpoint in Universal which allows us to authenticate users through a basic auth header? Other ways of authenticating users are of course also welcome, but some form of username/password authentication is preferred.Thanks in advance!
We are pointing with a (generated) deeplink in e-mails to our customers and suppliers. These pointers refer to our good old WebGUI portal.I really love the universal GUI and I would like to generate these deeplinks to Universal for a faster acceptation of Universal (and close the old WebGui portal)Is deep linking already possible in Universal or planned?
Hi,I've made a barcode scanner view where i scan a barcode and it inputs the text behind the barcode.Is it possible that when i scan another barcode it automatically changes field “Barcode” with the new text? It needs to have the same effect as selecting the barcode text and scanning the new barcode. Is it something i can edit in Thinkwise or is it a seperate query that i need to write? Barcode after scanning. Scanning a new barcode doesn't have any effect on changing the Barcode field (i need to select the field and the value in it to make a change)
I'm trying to configure an Azure App Service that uses the OpenID possibility of IAM to authenticate users. The app service is a website with static content and should be protected using an OpenID Connect provider:https://docs.microsoft.com/en-us/azure/app-service/configure-authentication-provider-openid-connectI’ve tried to set this up, but I struggle with both the configuration in Azure and in IAM.When I use the example document from Microsoft documentation (below) from Apple ID it does redirect me to the Apple ID login page, on which I assume should work when correctly set up;{ "platform": { "enabled": true }, "globalValidation": { "redirectToProvider": "apple", "unauthenticatedClientAction": "RedirectToLoginPage" }, "identityProviders": { "openIdConnectProviders": { "apple": { "registration": { "clientId": "com.contoso.example.client", "clientCredential": {
How do I turn this off? I have a view that calculates real-time timings, however I notice that because of lookups the view gets queried once for itself but then also for every lookup. There are many performance issues with this:Why the OR statements and not the actual pre-filter, they tend to be less performant than the exists clause in the pre-filter. Why all lookups are based on the base-table with a left join? Why not directly lookup on the lookup table?This setup is really killing me. Any advice here on how to optimize this situation? declare @handle int;exec sp_prepexec @handle output, N'@p0 int, @p1 int, @p2 int, @p3 int, @p4 int, @p5 int, @p6 int, @p7 int, @p8 int', N'SELECT t1.[process_id], t1.[process_task_id], t1.[tenant_id], t2.[description] AS [lookup_636502171]FROM [process_task_view] t1LEFT OUTER JOIN [tenant_definition_status] t2 ON t1.[tenant_id] = t2.[tenant_id] AND t1.[process_status_id] = t2.[domain_status_id]WHERE (t1.tenant_id = convert(int,SESSION_CONTEXT(N'tenant
I am trying to connect with a 3rd party API (Visma API based on Swagger) and for some reason I can't seem to get an output from the HTTP connector. For testing purposes I insert the connector output into a text file but the file remains empty. This is the debug error message in the application after triggering the process flow: code:Unexpected character encountered while parsing value: A. Path '', line 0, position 0. This suggests the connector output is empty which would explain why the file remains empty. If my assumption is correct then I don't understand why this happens. I have created the correct API call in the Insomnia application first and I get the expected json result: (Don't worry about data sensitivity because the data comes from a test account.) All the API call needs is a URL and these 5 headers (including a token). In SF I've set the parameters as follows: With 5 headers as a single value containing 5 lines being: code:Accept: application/jsonAccept-
This topic is kind of a follow up on this topic:https://community.thinkwisesoftware.com/development-13/open-a-screen-first-time-and-ignore-it-the-next-time-1251 Because our application is a bit overwhelming the first time you start it, or the first time you’ll use features / subjects in the application, we want to help the user. We’ve found a tool called “Inline manual”. A video about what it does can be seen here: https://inlinemanual.com/product-demo/. In short you can “walkthrough” a user, show tooltips to help the user etcetera. Easily explain some actions step by step what to do. Simple things how the look-ups work, how you can add records etcetera. First time users really need some help, and that could be perfectly done by such tool. This could be an enormous improvement in “User onboarding”. Please note we only use the Web GUI, and are tempting to use the universal GUI as soon as it is feature complete for us. As we’ve tried to see if it’s interesting for us we’ve encountere
Hi all, we have automated the build of a TW end product using indicium and the start_deployment_package task. This all works just fine, and now we want to automate the update_data_migration_source_version task as well.When the deployment package generation is successful, we want to mark this version as the start point of the data migration for the next version.This way, we should have new migration start point for when we start the new version, and eliminate the possible migrations errors that may occur when the developers forget to mark the version correctly as the next start point. Our build tool knows the correct model_vrs_id for the generated build, as this is read from indicium by selecting the correct value based upon the model_id, branch_id and model_vrs_description. we then post this to the indicium server url: iam/sf/update_data_migration_source_versionwith the following payload: This call results in a 403 - Forbidden. Using the same values in the task available in SF, is all
Hello,We have the same problem as described in Max file upload vs Max request body size - Azure Application Gateway | Thinkwise Community (thinkwisesoftware.com)The topic is closed (I cannot comment anymore), but the suggested solution was never verified. We tried the solution and unfortunately it does not work.I created a ticket in TCP (#10290) and I saw the ticket got updated to status “On the backlog”.Can you provide more information on how to proceed?Best regards,Nick Janssen
On the one hand you can use a triggers control procedure for performing extra actions. On the other hand you can also accomplish this by using process flows.I'm curious to find out reasons for using one over the other. Are the Trigger-procedures old functionality that will be deprecated soon? Or are Trigger-procedures the way to go?When do you use one over the other and why?
In a grid screen of a table. I have different tasks to start, depending on the type of record that is selected. So multi-row is not wanted here. Is there a possibility to set the screen of this table or variant to single-row selection?
We consider using TSF_dotNET.exe instead of TSF_CS.exe from a network share for starting the Windows GUI in a terminal server setup. This way we want to avoid the growth of the App Data folder. Are there any disadvantages to this idea?
I am trying to use the http-connector to connect to a website/webshop (http://webshop.coffeefresh.nl). The http connector is returning error code -1. When I do the same request to http://bol.com for instance I receive status code 0 / http 200 OK. I can reach the URL without any problems using a browser or insomnia. Just not with the http connector. What can be the cause of the -1 error code, or, where do I look for the problem?
We are converting a current Crystal Reports report into DevExpress Report Designer. However, in CR I was using a standard formula if PageNumber <> 1 then formula = true to show our company logo only on the main page and a smaller logo on the remaining pages.Supress company logo on pages unequal to 1For the PageHeader in DevExpress, the Print on can be applied where "Not with Report Header" can be selected. However, this does not apply to the large company logo because it is in the ReportHeader. Here I would like to use a similar formula to suppress it for page numbering unequal to 1.On the Internet I came across that a formula PageCount() = [SpecificPageNumber] should exist, however, it does not seem to be available in the downloaded DevExpress variant of TCP.PageCount() = [SpecifiekPaginaNummer]What is the best solution for in DevExpress?
I want to upload a contract for a employee. The file should be stored in a employee folder on the file server. The domain assigned of the file-upload column contains a predefined network path. This path should be variable depending on the employee name. For example: I upload a contract for the employee "NVP\d.vanleeuwen". The uploaded file should be stored in the following file path: \\fileserver\file_upload\Employee\d.vanleeuwen\contract.pdf In this case the path must be created as follows: \\fileserver\file_upload\Employee\@variable_employee_name\@uploaded_file I've created a domain with control_id "File upload" and a file_storage_id who is linked to a storage location on our file-server (For example: \\fileserver\file_upload\Employee\). I've already tried to write and executed the following code for the insert_trigger of the employee_contract table. Unfortunately this doesn't work because it changes the path but does not move the file. code:-- parameters declarendeclare @us
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
We have made an subroutine and mark this as an API (OData). This subroutine works fine when you use no parameters. When we profile with sql server the call is done but the parameter is null. We use the http call in the example but not sure this is correct.HTTP callhttp://web04/indicium/iam/100/fnc_getUserEmail?param_usr_id='itpartner\ronald'Metadata <Function Name="fnc_getUserEmail"> <Parameter Name="param_usr_id" Type="Edm.String"/> <ReturnType Type="CENTER.subroutineScalarResult" Nullable="false"/></Function>
How come I get a 500 error? I want to install Indicium Universal, because I want to use the process flow scheduler functionality. How is the configuration different from the installation of the 'old' Indicium? How do I know that the correct version of .NET Core Windows Hosting Runtime is running?
I like to work out a scenario of reading user data from an Office365 account. Like upcoming agenda events or outstanding tasks.Is there any step-by-step explanation available of a working example, using the Oauth 2.0 connector?
Since I installed a new Windows GUI (2023.3) en Universal GUI (2023.2) version last weekend (27/1/2024) some users of the UGUI are complaining that they need to login again after a while of not-working. The users are truckdrivers who deliver goods who need there tablets every now and then when they arrive at the customer to let them sign their packing slip. Before this weekend the UGUI-application did not show this behaviour and it disturbs the drivers because of the time it takes to login again.Did something change and if so is there a timer (now) in Indicium or a extended property I have to code ?
Recently we’ve upgraded our Test- and Staging environments in Azure to Indicium 2023.1.15 and Universal GUI 2023.1.15.1 and enabled the Extended Property RefreshOnDocumentSwitch = Yes as described in the release notes of Universal GUI 2023.1.15Release Notes Universal GUI 2023.1.15 | Refresh on revisiting a page or tabHowever, we don't see any refreshed data when a user revisits the opened document in the menu.Are we missing something? Any help would be appreciated. PS: We have disabled ‘Show Open Documents’ in the software factory, so we don't show the open documents in the menu.
I’ve imported my application on IAM, but after log into my application, i get the error:
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.