Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Dennis Beeren

22 Replies

Newest first

Oldest first

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

No. of fields locked and grid group labels

It appears that this bug still has not been solved in 2021.3.1. Where can I see the status of this bugfix?

Dennis BeerenVanguard

asked in Questions & Conversations

How to display percentage in the UI (when value in DB is in decimals)?

Apparently I haven't been clear enough in my initial question. Sorry for that.I am looking for a way to show percentages in the UI (e.g. 50) while the database holds the fractional value (e.g. 0.5): User enters: 60 → Database value becomes 0.6 Database holds 0.6 → UI displays 60An expression field will not do the trick, since the user has to be able to enter a value too.I already thought of making a view and the using an instead of trigger to update the entered values, but that feels like a far-fetched solution.Any other possible solutions are welcome.

Dennis BeerenVanguard

asked in Questions & Conversations

Drawback of using unique index on column

Thanks for these details! And the prompt answer .

Dennis BeerenVanguard

asked in Questions & Conversations

Exclude column of data type xml from update trigger

Hi Jasper,That’s even better. Thanks! What about:What is the purpose of the ‘Trigger for update’ attribute in the subject? Or should I open a new post for that?

Dennis BeerenVanguard

asked in Questions & Conversations

Exclude column of data type xml from update trigger

I've found a solution to exclude xml columns from the update triggers:One question remains @Jasper:What is the purpose of the ‘Trigger for update’ attribute in the subject (see below)?

Dennis BeerenVanguard

asked in Questions & Conversations

Exclude column of data type xml from update trigger

Dear Jasper,Thanks for your reply and for the additional tip about ‘no lock’ hints (relics from my predecessor) along the way!I've found the code to add the check for domain/data type. I wonder if there is a column of c (see highlighted code) that I can use for checking the domain/ data type the same way that there is a check for ‘’calculated_field_type’?I know that I can use something like this (see below), but I hope that there is a better way.:SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'table name' AND COLUMN_NAME = 'column name'

Dennis BeerenVanguard

asked in Questions & Conversations

What is the advantage of attached database design?

Dear Vincent,Your replies and clear examples shed a different light on the design for me. Thanks for effort to give me some background information on these matters.Best regards,Dennis.

Dennis BeerenVanguard

asked in Questions & Conversations

Where to configure available printers for my project?

Hi Casper, I'll remember this for the next time I need it. I am now using an external function for the print job. One of the parameters is the printer location. See attachment. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/0171f780-a3fc-44e9-a9cb-4e1b23f60cdf.png[/img] In the heat of the moment one cannot wait days for answers to some basic questions. I searched the documentation first and couldn't find anything about the printers and then before my initial post I contacted your support by phone and they asked me to create a post. And when I did, I got told to click on the magnifying glass... Anyway, I am glad to have this information now. Thanks for your answer! Regards, Dennis.

Dennis BeerenVanguard

asked in Questions & Conversations

Sequence in Process Flow

Hi Jasper, No I didn't try you solution. Thanks for the tip about the Process Flow Monitor though! I chose a completely different design for my process flow. I included a task to execute an external c# function that prints and deletes the reports after the print job. Regards, Dennis.

Dennis BeerenVanguard

asked in Questions & Conversations

Where to configure available printers for my project?

Duh... I know this obviously! When I do this, I get a list of printers that are probably somehow/sometime added by my predecessor(s). My question is how to add a network printer to this list. I cannot find anything about this in your documentation.

Dennis BeerenVanguard

asked in Questions & Conversations

Is possible to pick a coordinate on a map component and save it into a column?

Dennis BeerenVanguard

asked in Questions & Conversations

Is possible to pick a coordinate on a map component and save it into a column?

Thanks for your reply! I read the topic about dragging the marker to another location. That could be a workaround for us. Displaying the map with a default marker in the center of the country and then have the user drag it to the desired location and save that new location to the database. Where/how do I activate/get the Google maps extention?

Dennis BeerenVanguard

asked in Questions & Conversations

How to control 'status code' result from a process action

Thanks for pointing me in the right direction. Again amazed about all the features of the SF :relaxed:

Dennis BeerenVanguard

asked in Questions & Conversations

How to control 'status code' result from a process action

Hello Vincent, Thanks for your swift reply. Could you please explain to me how I have to: "bind this output parameter to a process variable and [u]use a process procedure to choose the next process step based on the value of this variable."[/u] I understand the part of binding the output parameter to a process variable. But how do I force the flow to a specific direction? Since I only can choose between 'Always', 'Successful' and 'Not successful'. We're on 2017.1. See below the flow involved. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/6a679426-690c-4c1a-896d-aac6c25258f4.png[/img]

Dennis BeerenVanguard

asked in Questions & Conversations

Two (or more) reports in a process flow on multiple records

I found out that my process flow is working as expected. Even on variants. The problem occurs when the process flow is fired from a nested tab page. Then the records from another tab page are used in the 'go to next row'. I am going to contact your helpdesk for this. Thanks for your help!

Dennis BeerenVanguard

asked in Questions & Conversations

Two (or more) reports in a process flow on multiple records

Dear Erik, I just found out that when I use the flow on the original subject (not being a variant) it works like a charm! Now I have to do some additional research first, since when I use it on a variant, the next row action is not working as expected. I first going to see how this variant is configured and then I get back to this post. Thanks so far...

Dennis BeerenVanguard

asked in Questions & Conversations

Two (or more) reports in a process flow on multiple records

We use GUI 2018.2.19.0.

Dennis BeerenVanguard

asked in Questions & Conversations

Two (or more) reports in a process flow on multiple records

[u]In addition to my post above:[/u] It looks like the report deactivates the collection of record and as a result of that there is no collection of records anymore to get the next row from. If I am right then I need a way to get the focus back on the original record of the original record set, before selecting the next row. When I place the 'go to next row' action immediately after the 'go to first row' action I get the report of the second row of the collection.

Dennis BeerenVanguard

asked in Questions & Conversations

Two (or more) reports in a process flow on multiple records

Hello Erik, Thanks for your reply. It makes sense to use your approach. That is why I tried it. Unfortunately something is still not working as expected. Please be so kind to look at my process flow (attached to this post) and tell me what I am doing wrong here (I am on 2017.1). What I notice is that 'go to next row' isn't returning a row and never continues on the successful path. I tried to activate the grid before the 'next row' step, but that's not working either. I checked and 'go to first row' returns the first row, so that is working as expected. Regards, Dennis.[img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/673f1865-1144-4b30-8ad6-b5b058c77d6d.png[/img]

Dennis BeerenVanguard

asked in Questions & Conversations

Error caused by display_expression

Thanks! Adding t1 to the calculated field query did the trick!

Dennis BeerenVanguard

asked in Questions & Conversations

Create custom color palette

[quote=Jasper]It is not possible to create your own color palette, but you can set the default color palette of the cube view to one of the other 29 palettes available. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/4b4bb885-0dca-40d8-9af9-2b271217a4b9.png[/img][/quote] I know that I can choose one of the 29 available palettes, but correct me if I am wrong, all available palettes use only four base colors and as you can see in my example it is relatively hard to see instantly if the green color in my chart is '04' or '08'. No big deal, but more base colors could solve this issue to my opinion. That's why I asked.

Dennis BeerenVanguard

asked in Questions & Conversations

Add a line base on a query to the graph of a cube

Hi Anne, Thanks for your reply. Idea has been posted!

Badges

Sanne Buitelaarhas earned the badge Geek
André Heijmerikshas earned the badge Preparator
Yarahas earned the badge Geek
Robbert van Tongerenhas earned the badge Firestarter
HJ van Dalfsenhas earned the badge Transcriber

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK