Replies posted by Erwin Ekkel

632 Replies

K.Bakkenes
Captain
K.BakkenesCaptain
asked in Questions & Conversations

Changing the order of instead of trigger procedures when executing source code

Why would you update the view and not just insert into the base tables? Apparently your view relation_address_view consists of multiple tables. Instead of inserting into the view, insert into the base tables in separate insert statements.

5
E
Moderator
4 years ago
K.Bakkenes
Captain
K.BakkenesCaptain
asked in Questions & Conversations

Changing the order of instead of trigger procedures when executing source code

Then create a subroutine with the logic from the IOT of relation_address_view. You can then add this subroutine in both the IOT of person_look_up and in relation_address_view. This will have the same effect but will remove the need to insert into the view.

5
E
Moderator
4 years ago
K.Bakkenes
Captain
K.BakkenesCaptain
asked in Questions & Conversations

Changing the order of instead of trigger procedures when executing source code

I think you just answered your own question. [i]It's also possible to create a procedure with multiple templates and assign the necessary template to each view.[/i]

5
E
Moderator
4 years ago
E
Moderator
Erwin EkkelModerator

Multiple open projects and how to handle themCompleted

This helps when checking something with an older version of the project/branch. This does however still leave the risk of changing something in the trunk, a different project or a different (active) branch.

20
Mark Jongeling
Administrator
1 year ago
Tom van Druten
Warrior
Tom van DrutenWarrior

Possibility to link a task to a table multiple timesMerged

If it's the same task but with different settings could you not just add a popup to the task with a couple of check boxes? And then fill the parameters based on those settings. This would negate the necessity for having the same task multiple times.

5
Jasper
Administrator
4 years ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

Bad performance on inserting. 2nd insert is way faster

For performance bottle necks the Profiler is a very helpful tool, but be careful to use this with a production system since the profiler takes up a lot of resources. Run the profiler with the 'Tuning' template. In case the tuning template is not available in the events selection tab check the tick box show all events. Then in the stored procedures section check SP: StmtCompleted. Doing this you will get each individual statement with its duration and the number of reads/writes. This will give you a clear indication of where your bottleneck lies.

4
Robert Jan de Nie
Thinkwise blogger
4 years ago
E
Moderator
Erwin EkkelModerator
asked in Questions & Conversations

Information panel reload makes all tasks disappear from the tasks bar

tried with GUI 2019.1.14.0 same problem. I will report this as a bug then.

3
E
Moderator
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager

Vertical list (Screen type)On the backlog

Totally agree. You could probably achieve this by creating a view with a pivot. However, a pivot is not the best option with performance in mind.

8
Mark Jongeling
Administrator
3 months ago
E
Moderator
Erwin EkkelModerator
asked in Questions & Conversations

Is it possible to change the icon when running the application against SF

Hi Jasper, This is exactly what I was looking for! Thank you very much. Works like a charm.

2
E
Moderator
4 years ago
E
Moderator
Erwin EkkelModerator

Deactivate Execute merge session when there are unresolved merge conflictsDeclined

It does show a proper message upon execution. But it just seemed odd that you could execute a task that you are not actually allowed to execute.

3
Jasper
Administrator
4 years ago
R
Hero
RolandHero

Set organization size in SFClosed

Hello Kevin, edit: never mind, it works. Somehow, I was expecting this feature to also set all currently "to review" code automatically to done. Since I was also looking for this feature I've tried this in 2019.1.15. However, i still get the validation messages on control procedure in development. Should I create a bug for this, or am I doing something wrong?

5
Jasper
Administrator
4 years ago
E
Moderator
Erwin EkkelModerator

Optional alternative translation object for duplicate entriesOn the backlog

Two Real life Examples: example 1: On an inventory transactions screen you can change the current stock level. The transaction unit of measurement is not necessarily the same as the stock keeping unit of measurement (example the stock keeping unit is gram but the transaction unit is kilogram). To store the information for this there are 2 columns, transaction quantity and inventory quantity. The problem with the naming is that inventory quantity suggest this column is giving you information about the total amount of inventory. In reality it is the transaction quantity corrected against the stock keeping unit of measurement. During development the name inventory_quantity probably made sense, however now it does not. And then you are left with the only feasible option: to make a new expression column just to rename this one column. Renaming the column and changing every trigger, stored procedure, view, task, parameter etc. is not a feasible option. example 2: on a pick list scr

7
M
Sidekick
1 year ago
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger

Maintain project version destinationCompleted

I created a similar wish for this. Jasper commented that the files will be stored in the application in future versions. Making this wish redundant in the near future. [url=https://community.thinkwisesoftware.com/ideas-18/otap-for-file-locations-472]https://community.thinkwisesoftware.com/ideas-18/otap-for-file-locations-472[/url]

7
Jeroen van den Belt
Administrator
4 years ago
E
Moderator
Erwin EkkelModerator

Remove reference from model tickbox active by defaultDeclined

Hi Mark,If they are unnecessary then why are they there? You can hide the references using the references tab so there is no need to use delete for this. Also using the references tab is much faster and can be done in 2 clicks instead of 3. I agree that changing functionality will confuse people already accustomed to working with SF. But i think to new users it would make more sense if delete actually deletes the reference, instead of hide it. 

2
E
Moderator
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
asked in Questions & Conversations

Best practice for inserting large amounts of rows into one table

There is no easy answer to this question. Because like with most things SQL related it depends on a lot of factors. Make sure you don’t have too many indexes and statistics on the table ‘Product’. Rule of thumb: max 5. Like Vincent said, you do not want too many triggers and constraints on this table. Is all imported data new? Or could there be updates/deletes or rows ignored (since they already exist? If so, don't use the merge statement but use individual insert/update/delete statements (all set based of course). If possible use select into instead of insert into for the global temp table. Also consider creating a (clustered) index on the global temp table based on your clustered index of the Product table. 

10
Anne Buit
Community Manager
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
asked in Questions & Conversations

Best practice for inserting large amounts of rows into one table

@Mark Jongeling What are the differences in the primary key columns in the global temp table? Is it just the data types or do you need to concatenate columns in the temp table to create the columns from the product table? If so it is best to fix these issues when you fill the global temp table with data. Then you can create an index and insert the data.     

10
Anne Buit
Community Manager
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
asked in Questions & Conversations

Best practice for inserting large amounts of rows into one table

@Mark Jongeling based on what you mentioned, the temp table is probably your best bet. But try to do a select into for the new temp table, instead of insert. I think it's best to give this a try with some mock data and compare the execution plans and run time. You mainly want your primary key columns to be correct in the temp table. 

10
Anne Buit
Community Manager
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
asked in Questions & Conversations

Best practice for inserting large amounts of rows into one table

Consider changing the recovery model of the database to BULK LOGGED during the data import operation. This will reduce the IO of the log file a lot. The article Vincent mentioned follows up on it a bit later as well. @Anne Buit I assume this is only advised when the current recovery model is set to full model. 

10
Anne Buit
Community Manager
4 years ago
Jop ter Horst
Vanguard
Jop ter HorstVanguard

Process flow code functionality visible in designerMerged

@Jop ter Horst I had the same idea a few weeks back: https://community.thinkwisesoftware.com/ideas-18/make-added-functionality-visible-in-the-process-flow-design-screen-787 so of course you get my vote. 

2
Jop ter Horst
Vanguard
4 years ago
J
Rookie
JordyBaasRookie

Using the functionality weaver for expression fieldsDeclined

I strongly disagree with step 3 if you mean this should create an actual SQL function (table or scalar):  "For every program object of type EXPRESSION a function is generated." not only will the function slow down your SQL query it will also mess up the execution plan. I think it would be better to translate the function to a sub select or a join (cte or regular join). 

3
Jasper
Administrator
4 years ago
Jop ter Horst
Vanguard
Jop ter HorstVanguard

Project version incrementCompleted

Why not just make the default 0.01? Most projects I have seen use 0.01 incrementals. 

6
Jeroen van den Belt
Administrator
2 years ago
Kevin Horst
Thinkwise blogger
Kevin HorstThinkwise blogger

'Create project version' could be more user friendlyCompleted

What is the function of this task? The version is automatically created when creating a project. And once v1 of a project is build you only want to copy the version. I would opt for removing this button, unless someone can explain when you would use this task? 

6
Jeroen van den Belt
Administrator
4 years ago
E
Moderator
Erwin EkkelModerator

Create new Domains on the DB without generating the entire projectClosed

Hi Frank, This helps a lot. Thank you very much.  Erwin

3
Jeroen van den Belt
Administrator
3 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Combined Filter Conditions

This is either a bug or a wish. The filter condition is only applied to the filter (right mouse button: filter) and not to the combined filter. 

4
Harm Horstman
Superhero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Combined Filter Conditions

The manual states: The Advanced option affects the expansion of the search/filter screens.  This implies that the filter condition is not used for the Combined filter. So please make a wish for this. 

4
Harm Horstman
Superhero
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings