Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Roy van Uffelen

95 Replies

Newest first

Oldest first

Roy van UffelenCaptain

New upgrade step drop tablesMerged

@René W Problems that most often occur, have to do with mandatory fields that get a (unique) default value, that is dependent on a new function that still isn't available op the database. Most often this occur when deploying to (a copy of) the customer database when multiple projects are combined into one deployment package.

Roy van UffelenCaptain

asked in Questions & Conversations

Dynamic display value for lookup

Hi Mark,Can I use in an expression field information from outside of the lookup table? As I assume that the lookup table has the display value column that will be an expression field, but the customer information is from outside of this lookup field.Do I reference the "calling” table t0, with t0.customer_id being the reference to customer and in this way be able to cross this with t1.product_id? And the alias being available (or not) through something like:SELECT x.alias FROM customer_product x WHERE x.customer_id = t0.customer_id AND x.product_id = t1.product_id

Roy van UffelenCaptain

asked in Questions & Conversations

How to browse for filename with path, without actually uploading the data?

Could this storage location also be sent to a location that can be reached by the sql server? So be used to move it from one location (from where it's been uploaded), to another location from where the sql server can access it?

Roy van UffelenCaptain

asked in Questions & Conversations

How to browse for filename with path, without actually uploading the data?

Good to know that this is an option for the Windows GUI.Unfortunately, this particular client is using the Web GUI. Do you consider this a bug of the Web GUI, and is this currently being fixed?

Roy van UffelenCaptain

asked in Questions & Conversations

How to browse for filename with path, without actually uploading the data?

Hi Mark,I tried setting a domain on File link, but the domain then still required a Storage location to in_database. For me this was an indication that it would still require for a column to have a storage column.So is this in_database Storage location obsolete, or does it still store in the database?

Erwin EkkelModerator

New ugrade step drop tablesClosed

Find this important, so created a new idea to get this going again. So put your votes up, so that it will be implemented this time.

Roy van UffelenCaptain

asked in Questions & Conversations

include filename when importing file

Hi Mark,Unfortunately not, since the csv-file is generated externally and can contain a lot of rows. For smaller csv-files and ones that we generate ourselves this would be an option.We already must make one change, as the last row contains a character that the default Thinkwise import can't handle: Any ideas around that would also be helpful.

Roy van UffelenCaptain

asked in Questions & Conversations

Different column translation on variant

Thanks Erwin (and Mark),Both options are not ideal, but am sure will achieve the desired result.What do you think is the chance that putting in an idea would actually be implemented?

Roy van UffelenCaptain

asked in Questions & Conversations

Custom message on delete

This means that an instead-of-trigger can only work with view (and maybe snapshot), but not with a normal table?The confirmation message on a task seems like a message with a fixed text. Maybe instead I could use a read-only parameter of which the value will be determined by a default expression. Can I use the t1 or other parameters within this expression?But probably better to use a task that will start a process flow. There you can first determine which kind of message will be displayed and how to react to that input. And then continue with normal message and delete

Roy van UffelenCaptain

asked in Questions & Conversations

Custom message on delete

Extra idea.Is it possible to use an instead-of-trigger and be able to send an error message from there?

Roy van UffelenCaptain

asked in Questions & Conversations

Custom message on delete

I was afraid of that. But added my vote to this wish.Hope it will be implemented soon.

Roy van UffelenCaptain

asked in Questions & Conversations

Custom message on delete

Thanks Mark,Is it possible to attach this task to the standard delete-action (the red X)?

Roy van UffelenCaptain

asked in Questions & Conversations

Combined filter details settings

Roy van UffelenCaptain

asked in Questions & Conversations

Combined filter details settings

I tried DisableFilterOnDetails on used Runtime configuration, but details are still coming.Have restarted the application and SF, but the Details-dropdown is still shown. Working in 2021.1 and WINDOWS GUI 2021.1.13.0.What am I doing wrong?

Roy van UffelenCaptain

asked in Questions & Conversations

Combined filter details settings

Hi Mark,Indeed changing the name from Details to TableName.Good to know we can disable it at Runtime Configuration. I guess that here the same options can be entered that are already shown in IAM.I guess that I will have to create some Ideas in order to make this more configurable ;-)

Roy van UffelenCaptain

Add conflicts prefilter to Merging>ActionsClosed

Hi Mark & Jeroen,I think this question was one of my first merges, and at the time there were no conflicts in that particular merge. Now I know that if there are conflicts there is also a conflicts tab.A prefilter or conditional layout on the actions would be nice.

Roy van UffelenCaptain

Change order of columns for table task parametersCompleted

I noticed that on Subject>Links>Drag-drop>Drag-drop parameters the order is still the old way. To bring this in line with table-tasks, you may want to switch these also:

posted in Questions & Conversations

Make your logging data available in the GUI

Hi Patrick,We (Kevin and I) also discovered that in the past hour.The following actions were needed:Create the two domains: datetime_all_use (datetime2) and conditional_layout_code (varchar(200)); Create two screen types: logging and logging_detail. It appears that these are in fact the same. This could easily be a grid-only screen type. Just be aware that prefilters are copied from the parent-table The reference between parent-table and history-view needs to be created manually. It may be possible to automatically generate this as well. Strange thing is that after generating the definitions, the reference seems to have disappeared. At the same time, drawing it manually produces an error, saying that this reference already exists. Conditional layout is based on grid_order_no. In my model two columns had the same value, so after changing any of these columns, this resulted in two columns that had its background color changed; Sort-order of the history is currently ascending, meaning tha

posted in Questions & Conversations

Make your logging data available in the GUI

We're getting closer. Currently we've come to the following messages:

posted in Questions & Conversations

Make your logging data available in the GUI

Hi Kevin,Good point … unfortunately after changing this screentype, I still get the MERGE error.After adding five lines for project_id and version and running it on SSMS, I got the following messages:

Roy van UffelenCaptain

Conditional layout for detail tabsClosed

Hi Mark,Not really what I'm looking for. This coloring is on document level. The coloring I'm looking for is on detail level.You can almost see it as some sort of badge on detail tabs, but then with coloring. Maybe a combination can give some kind of conditional layout, but then for coloring the detail-tabs.

Roy van UffelenCaptain

Dealing with templates within code reviewCompleted

These changes help a little. Since they are only focussed on the control procedures. Probably the same could be extended towards templates.However I get the impression that you can still not see which templates are changed. Having a conditional layout to highlight these changed templates would be really benefitial.Also having some highlight on control procedures and templates that are used in program objects linked to changed tables could be helpful. Think about what happens when adding a calculated column. No deployment is necessary to the database, but the linked program objects have extra parameters. These have to be generated again. Seeing this, of even having a redeploy program object-task would be helpful.

Roy van UffelenCaptain

Select color and font from list of selected itemsOpen

Concrete example would be the use of background coloring on conditional layouts. In case of validation you always want the same background color in any place the validation fails.Currently you have to select the exact shade of red you want. If you were presented with a list of colors (possibly with a usage-name) then you can simply select that specific color.Also when you want to change the color, you only have to do this on this one central spot, instead of on all the different locations.

posted in Questions & Conversations

Make your logging data available in the GUI

Great idea.Unfortunately I get the following error while executing on SF2021.1Followed by:Any idea what I should do differently?PS I tried it twice with @screen_type_id as NULL and as master_detail.

Roy van UffelenCaptain

asked in Questions & Conversations

Export to excel through task or process flow

Idea gepost.But other ideas to achieve the same effect are welcome.

1
2
3
4

Page 1 / 4

Badges

Alban_Thas earned the badge Deployer
ssitalhas earned the badge Preparator
Sanne Buitelaarhas earned the badge Geek
André Heijmerikshas earned the badge Preparator
Yarahas earned the badge Geek

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