Thinkwise Platform

Questions, discussions, news and updates regarding the Thinkwise Platform.

2514 Topics

H
Sidekick
HJ van DalfsenSidekick
asked in Questions & Conversations

Views creation Generation order and priority

Hi, I've defined a view vw_tour_resource. Some columns of this view I would reuse in another view vw_tour_driver.When testing the query itself for the view vw_tour_driver, then in works fine. But when creating a new version, then I get an error I think the root cause of this is that the view vw_tour_driver is created first before the (existing) view vw_tour_resource as it is alphabetically earlier.I tried to influence it with Generation order no and Priority, but that seems not working. Tried with giving higher or lower priority, higher or lower Generation order no, but that seems not helping.How to fix this issue?  

2
H
Sidekick
3 years ago
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations

Export to excel through task or process flow

Is there a way to create an Excel-file with multiple worksheets?Preferrably I would like to have a task for writing to each worksheet and connect them in a process flow with the write file in the end to create the actual Excel file.How do I do this?

2
R
Captain
3 years ago
P
Vanguard
PatrickW
asked in Questions & Conversations

Indicium - change interval pending system flow

Hi,I have upgraded our environment to 2021.1. This is the first version with (mandatory) Indicium for us.In SQL Server Profiler I see that there is a query running every second that checks if there is a pending system flow: SELECT * FROM i_core_pending_system_flow WHERE date_time BETWEEN @after_date AND @before_date;At this moment we do not use (automatic) system flows, so my question is if it possible to change or disable this ‘every second’-interval?Thnx.Patrick

2
P
Vanguard
3 years ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

Refresh process action universal

In the feature matrix it is stated that the refresh process action does work. However when I update a detail (with a task, which triggers the process flow) and I do a refresh of the master object table, that seems not to work. Is this possible yet. Also the auto refresh function does not have effect (yet) in the Universal GUI. I'm afraid my conclusion at the moment is that users need to refresh themselves all the time? 

2
Mark Jongeling
Administrator
3 years ago
Ricky
Hero
RickyHero
asked in Questions & Conversations

Maximum url and querystring length

Hi,What is the maximum querystring/url length supported by indicium that actually will be parsed? Is this the same as the maxQueryString/maxUrl that can be set as a config setting in the requestlimits?: Request Limits <requestLimits> | Microsoft Docsrgds Ricky

2
Ricky
Hero
3 years ago
R
Superhero
René WSuperhero
asked in Questions & Conversations

Stage task commit failed. Error: action_not_allowed

I have task in the Universal GUI which gives me the following error.I’ve checked the Chrome logs (HTTP 403 error) and the Indicium logs (empty) but I have absolutely no clue what is going wrong. What is happening here? I'm using Universal GUI 2021.1.13 and Indicium Universal 2021.1.16.

2
R
Superhero
3 years ago
R
Superhero
René WSuperhero
posted in Questions & Conversations

The specified CGI application encountered an error and the server terminated the process - HTTP Error 502.5

This morning when I tried to reach out an application using the OpenID provider, Indicium 2021.1.16 - hosted on Azure - suddenly crashed. The first message I received was:The specified CGI application encountered an error and the server terminated the process.I refreshed the browser and then I got the following error:HTTP Error 502.5 - ANCM Out-Of-Process Startup FailureCommon solutions to this issue:The application process failed to startThe application process started but then stoppedThe application process started but failed to listen on the configured portTroubleshooting steps:Check the system event log for error messagesEnable logging the application process' stdout messagesAttach a debugger to the application process and inspectFor more information visit: https://go.microsoft.com/fwlink/?LinkID=808681Then I refreshed again and it worked again.In the logs I can only find the following lines which probably have to do something with it:2021-03-09T08:25:54.2547150+00:00  [FTL] Unable

2
R
Superhero
3 years ago
S
Apprentice
Stefan BosmanApprentice
posted in Questions & Conversations

Wait in process flow or fill task parameter in another task from process variable

We have the following situation. We have 3 tables, activity, activity_item and item. We first make an activity with some extra needed info, after that we want to multiselect some items (filtered on some conditions) to the activity.So after selecting the items there is a task to assign those items to the activity_item table. At that moment the activity_id from activity table is not available in the task, which I want to fill. I tried a process flow, but I do not think there is an option after opening the document and filter to wait for selection of the items. See screenshot belowThe first task will be opened form the Activity table after you have selected an activityIn that task you select the option how you want to filter the items.The Item table will be opened and filtered according the first task.In this situation the flow continues to the next task where activity_id is filled. But that step should be done after selecting items form the item tableIs there a way to wait until items ar

2
S
Apprentice
3 years ago
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations

Temporal columns

Is there a way to have an editable column on a form that will not be stored in the database, but is available as parameter within (at least) default procedures?I want to use these for checkboxes and other fields to enable the possibility for user to override (or overwrite) default values, but also to get back to them.

2
R
Captain
3 years ago
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations

How can I use a expression field with a query to a column with binary data for the preview component?

How can I use a expression field with a query to a column with binary data for the preview component? I've add an expression field with the following select query:select CONVERT(VARBINARY(5000),file_upload)from project_order_documentwhere project_document_id = 213 The column contains the binary data of a .pdf file but the previewer shows the text "No filepath is given”.The domain has datatype VARBINARY_MAX without user interface control. If I try to change it into "File link” it changed automatically to "File upload".  

2
Mark Jongeling
Administrator
3 years ago
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations

Different translations for same link table (koppeltabel)

Between two tables I have a link table for creating an nxm relation.This link table is a detail of the two original tabels, but has a different translation for both.For instance let's say we have a table owner and a table property. An owner can own multiple properties and a property can have multiple owners, so two references are added.The detail of owner must be translated to Properties, while the same detail of property should be translated to Owners.How do I achieve this in TSF?

2
R
Captain
3 years ago
Equito
EquitoPartner
posted in Questions & Conversations

Release notes Sprint 37 - Februari 23

Does anyone know who can find this: Release notes Sprint 37 - Februari 23

2
Equito
3 years ago
A
Sidekick
Amel RamulicSidekick
asked in Questions & Conversations

Subject drag-drop interaction

We are missing a drag-drop interaction on our latest project version. On the production version the interaction is still there. How can we add it back in the latest version? The production version: Our latest version where it is missing: 

2
A
Sidekick
3 years ago
Bas
Vanguard
BasVanguard
asked in Questions & Conversations

How can I schedule the report mailer?

In a recent meeting a client told us about her morning routine. A quite cumbersome exercise logging into their thinkwise application to verify if there are any records with certain error states. Only to log out when none are found.We suggested it would be a lot better to send her and some other staff a daily report containing records with error states (and some other goodies to show the success of the system). We would like to send them this report each workday morning at 6:45 using the report mailer.We know how to schedule process flows within the app. But how do we get the application to send out a report (task with gui code) while triggering this from a schedules flow?

2
Mark Jongeling
Administrator
3 years ago
E
Sidekick
Edwin van de PeppelSidekick
asked in Questions & Conversations

OpenID connection – Indicium CSP error

Hi,I’m evaluating the use of the OpenId option for user authentication in a non-thinkwise app, so that the users can use the same credentials in both the thinkwise app and the non- thinkwise app. I’ve configured the application in the OpenId section of IAM, setup the correct redirects in the client application.When the user connects to the website, the user is redirected to the login of the indicium application.After login the user should be redirected to the original application. However, we are not redirected. We stay on the /connect/authorize/callback?client_id= page of indicium.I suspect that this is related due to the CSP settings on this page. Possible related to the mismatch in the content-security-policy and x-content-security-policy headers.This happens in Firefox/Chrome and Edge.However, when I disable the CSP check in the browser, the redirect works, and the user is redirected successfully to the original webapp.This is tested against the 2021.1.17 version of indicium.I’ve g

2
E
Sidekick
3 years ago
R
Superhero
René WSuperhero
asked in Questions & Conversations

Missing translation 'unable_to_claim_application'

In the Universal GUI the following message is possible:This happens when there is a concurrent user limit set and reached. The user is in this case logged in in the web gui and the universal gui.However, I cannot find the string unable_to_claim_application in the SF. Is it missing, or am I missing it? 

2
Mark Jongeling
Administrator
2 years ago
M
Sidekick
MariekeSidekick
asked in Questions & Conversations

How do I check the answer of a message with message options?

I do have a control procedure with a call to tsf_send_message. How can I check what button is clicked in the message?

2
M
Sidekick
3 years ago
A
Sidekick
Amel RamulicSidekick
asked in Questions & Conversations

Report print problem

We have a report rpt_ribben_laadschema where we have set a printer to “Wanssum_lade_2” but the printer is still using the default printer instead of “Wanssum_lade_2”. Is there a way of changing that even though it is set to “Wanssum_lade_2”?  

2
Mark Jongeling
Administrator
2 years ago
Blommetje
BlommetjePartner
asked in Questions & Conversations

Different translation for grid/form for Elements

Hi, I've have some domains with elements, for example;paypal creditcard  prepaid afterpayI would like to display to full word (creditcard) in the form (combo box), but a shortened translation in the grid (CC). Is this possible? I know we can set form/grid translations for column names and such, but Elements I can't find.  In the extend of this, can I do this for table lookups? I have  reference from 'invoice’ to 'payment types’, and for Grid i show the column 'shortcode’, and in the form I show the column 'full name’. This way, I can achieve the same if I switch from Elements to a table.  Anyone?  Alex   

2
Blommetje
3 years ago
A
Captain
Andre te RaaCaptain
asked in Questions & Conversations

What are the criteria to make an URL (domain control) a link in the grid?

I'm looking for a way to open a file and a folder with the same domain control. When I use a ‘file link’ or a ‘folder link’ I have to use 2 separate columns.If I use ‘URL’ with ‘file://’ it works in the form, but it is not shown as a link in the grid. Why not? 

2
Mark Jongeling
Administrator
2 years ago
pauloportu
Apprentice
pauloportuApprentice
asked in Questions & Conversations

Screen type: Tiles + references via detail group (TabbedDetailTabPage) is a no go?

We have a situation where we use tiles for the main grid's references. Then, we want to have a separate section (which is a view) on the same page where a selected record from the main grid will show related record from our view (in grid below - a TabbedDetalTabPage): we do that by creating a Detail group (P in our example below). To show the main grid at the top (which is a variant) + tiles (checked show detail tabs in variant), there is no problem. If we use the main grid (variant) + TabbedDetailTabPage (ref. to view), the connected detail group (‘P’ in our illiustration below) it works fine. However, if we want to show all, main grid (variant) + tiles + TabbedDetailTabPage (ref. to view), the tiles do not show, we get same as with 2. Questions:is what we want here, possible at all? what are we missing, or perhaps, our approach might be wrong?  Thank you  

2
pauloportu
Apprentice
3 years ago
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
asked in Questions & Conversations

Disable column label in tree based on grouped columns

Is there a way to disable the column label in a tree that is based upon grouped columns?For some reason the GUI automatically displays the label of the field which it is grouped by. But this is often not something you would like it to display. So I was wondering if I can disable this label?  

2
Arjan Sollie
Thinkwise blogger
3 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Formlist show only one row. Why?

I am try to configure a FormList for question list as detail, it only shows 1 row, while it should whow 10.What am I doing wrong?Any special settings required for this to let it work?     

2
Mark Jongeling
Administrator
3 years ago
S
Apprentice
Stefan BosmanApprentice
asked in Questions & Conversations

Set a default grid row height (in theme)

I want to set a default grid row height for all tables in a project.I found an option to set it for every table separately under the settings tab of Subjects  But is there somewhere an option to set a default for all tables/views?I tried to find it in Themes, but maybe I overlooked it? 

2
S
Apprentice
3 years ago
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations

Setting default for generating source code

Is there a way to set defaults for generating source code?Currently I always check the write options, but it would be nice if there was a way to set these defaults. And I was wondering if this is already a feature of the SF.

2
R
Captain
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings