Replies posted by Robert Jan de Nie

140 Replies

Jop ter Horst
Vanguard
Jop ter HorstVanguard

CRUD proceduresCompleted

Updated idea statusNext release→Completed Whoohoo!!

21
Robert Jan de Nie
Thinkwise blogger
1 year ago
E
Moderator
Erwin EkkelModerator

Automatic data conversion on rename of columnClosed

Is this still an issue? Sometimes I have this issue. Can’t really pinpoint when.  When you do not generate the definition after going to a new project version, the Software Factory fails to add Data conversion data when renaming objects. So, to avoid this, please generate definitions after creating a new project version. Why does a user have to do this, if it is a given that this needs to happen, why not just schedule one in the background? Well, from the 2022.2, it will 😉 At the end of the copy project version task, a Generate Definition will be automatically scheduled. I love it when I propose something and you guys have already thought of it. <3

10
Robert Jan de Nie
Thinkwise blogger
1 year ago
E
Moderator
Erwin EkkelModerator

Automatic data conversion on rename of columnClosed

Is this still an issue? Sometimes I have this issue. Can’t really pinpoint when.  When you do not generate the definition after going to a new project version, the Software Factory fails to add Data conversion data when renaming objects. So, to avoid this, please generate definitions after creating a new project version. Why does a user have to do this, if it is a given that this needs to happen, why not just schedule one in the background?

10
Robert Jan de Nie
Thinkwise blogger
1 year ago
Kasper Reijnders
Kasper ReijndersPartner
posted in Questions & Conversations

Payments in Thinkwise

Hey Kasper, cool solution! What payment provider did you use?

2
Kasper Reijnders
2 years ago
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations

Universal GUI performance

What is the reason that this query needs a recompile option passed via an extended property? It seems to me that this will be very hard to figure out where / when to apply this.

16
Freddy
2 years ago
G
Apprentice
g.c.d.vanderschootApprentice
asked in Questions & Conversations

Check constraint comparing values from multiple rows

Technically I think you could implement that in a constraint using a function. Downside however is that this is not properly supported by the Software Factory. It will lead to this function not being able to be modified without dropping the table / constraint that is being used.What I’d do is implement this in a trigger. The update-trigger could look something like this:if exists (select * from inserted i join deleted d on d.vessel_pk = i.vessel_pk where d.end_date is null --check if there is a situation where there was no end-date and i.end_date is not null --and this end-date has been updated to a non-empty value and not exists (select * --where there are currently no non-end-dated vessels left of that perticular vessel_id from vessel v where v.vessel_id = i.vessel_id and v.end_date is null

2
G
Apprentice
2 years ago
Freddy
FreddyThinkwise Local Partner Brasil

Upgrade rollbackOn the backlog

Yes! Yes! This!I agree with Freddy here, I think it is trivial to reverse the backup based on the information that is available.Steps could look something like this:Detect error Remove altered tables Undo renaming of the modified tables Revert removal of constraints (based on previous version) Revert removal of indices (based on previous version)

8
Jeroen van den Belt
Administrator
10 months ago
E
Moderator
Erwin EkkelModerator

Multiple open projects and how to handle themCompleted

The following idea has been merged into this idea: All the votes have been transferred into this idea. I think this idea has grown a beard…

20
Mark Jongeling
Administrator
1 year ago
Robert Jan de Nie
Thinkwise blogger
Robert Jan de NieThinkwise blogger

Show more information during 'Generate source code' stepCompleted

Yeah, something like that. Just so you get a little more feedback instead of waiting around for like 5 to 10 minutes (depending on project and server sizing).Could just be a ‘wall of text’ scrolling by instead of something more complicated.

9
Jeroen van den Belt
Administrator
1 year ago
Eric Franken
Vanguard
Eric FrankenVanguard

Hint conditional layoutOpen

I really like this idea as well, you can perhaps provide some kind of legend to tell the user what specific colours mean. For now, @Eric Franken you could fake a feature like this using a small detail view with some static SQL showing each colour and the meaning of that colour next to the tab/screen somewhere.

6
Mark Jongeling
Administrator
1 year ago
Theo Neeskens
Sidekick
Theo NeeskensSidekick

Option to hide a Detail tab where no data is present.Open

I agree with Jasper on this one. We have got a logic concept that will hide/disable tabs.You can also consider using badges in order to let the user know if there are any records present in a specific tab.

8
Freddy
5 months ago
Jeroen van den Belt
Administrator
Jeroen van den BeltAdministrator

Provide the result column of a function with an identity valueOpen

I should upvote then…

2
Robert Jan de Nie
Thinkwise blogger
2 years ago
Quido
Rookie
QuidoRookie
published in News & Blogs

Deployment with DockerBlog

Docker run command for indicium should be something like:docker run -d -p 5000:5000 --name indicium indicium:latestNot universal:latest, that is a different image :)Also, I seem to need to put the Dockerfile into /indicium, not /indicium/app.But I got it running :D

4012
Jasper
Administrator
2 years ago
Robert Jan de Nie
Thinkwise blogger
Robert Jan de NieThinkwise blogger

Automatically create unique index for lookup columnOpen

I got you one better! Why cant we specify per lookup (with a simple checkbox) if that lookup should be unique. If so, the SF will create an index for us. This would give you more control and you wont have to specify an index for each lookup that needs to be unique (most of them).

7
Mark Jongeling
Administrator
2 years ago
Robert Jan de Nie
Thinkwise blogger
Robert Jan de NieThinkwise blogger

Automatically create unique index for lookup columnOpen

Too bad I can't edit my comment, so here we go…Your situation, using a calculated column as a lookup could be resolved/work in the same way. Try this example:--create a table with a computed columncreate table cities (id int primary key ,name varchar(100) ,postal_code varchar(100) ,name_postal_code as name + ' ' + postal_code --computed column based on name and postal code )--create unique index based on the computed columncreate unique index cities_unique_lookup on cities (name_postal_code)go--insert a valueinsert into cities (id ,name ,postal_code ) values (1 ,'apeldoorn' ,'1234ab' )--insert second value, this one should fail since name_postal_code must be unique insert into cities (id ,name ,postal_code ) values (2 ,'apeldoorn' ,'1234ab' )go--cleanupd

7
Mark Jongeling
Administrator
2 years ago
Robert Jan de Nie
Thinkwise blogger
Robert Jan de NieThinkwise blogger

Automatically create unique index for lookup columnOpen

I agree with your comment, @J. de Lange. It should definitely based on a setting per lookup. The default behaviour should be true (maybe a project setting). For existing projects however, this setting should definitely be turned off and make it a developers decision if it is to be turned on.

7
Mark Jongeling
Administrator
2 years ago
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger

Disable mutation data from within lookup popupsOpen

Could still be an easy project(-version) setting instead of a dynamic model thing.

6
Mark Jongeling
Administrator
2 years ago
S
Apprentice
SuleymanApprentice

Blocking of dates on date picker (calendar)Open

Awesome idea! Implementation wise, I'd like to be able to drive the ‘allowed dates’ via a query (table valued function maybe?) so you can customise the logic used to select these dates.

4
Peter Verwijs
Moderator
1 year ago
Frank Wijnhout
Thinkwise blogger
Frank Wijnhout
posted in Questions & Conversations

Make your logging data available in the GUI

@Dennis van Leeuwen, @Frank Wijnhout I have updated this version to work with 2021.2 version of the SF. I have sent this to Frank separately so he can review/update the current version.Furthermore I have added and changed some stuff as well:Made lookups work (based on current data) Show all columns in the grid (not based on tab-setting) Optionally show the log as a detail tab Removed hard-coded dependencies and added some checks to make life easierAlso added it as an attachment to this post.Enjoy!

16
P
Vanguard
1 year ago
Robert Jan de Nie
Thinkwise blogger
Robert Jan de NieThinkwise blogger

Insert your own code into CATCH part of 'atomic transaction'Completed

This should be an easy fix. Just leave some numbers available to put code after create procedure part and before the ‘end-procedure’ part. Comon.

10
Jeroen van den Belt
Administrator
2 years ago
R
Captain
Roy van UffelenCaptain

New upgrade step drop tablesMerged

I agree with this idea, especially in the early stages of development or on development environments in general. What I usually end up doing is opening the upgrade script, hit ctrl-f to search for ‘drop table’ and cut everything after that into a new window/file. Then I execute the upgrade minus the drops and if (if, mostly it is fine) something goes wrong, I can still resolve the issue without resorting to a database restore.This is especially useful when an external DBA needs to do the actual restore of the database rather than you being able to do it yourself.

6
Jeroen van den Belt
Administrator
10 months ago
E
Moderator
Erwin EkkelModerator

Add do not check validations tickbox to synchronizationDeclined

Strongly disagree. Validations are there for a reason. They should be ran, especially when synchronising them to IAM. I think keeping the escape option where it is is fine, this way you are forced to at least view the validation-errors as you have to go trough the screens.If there are validations that are not valid, I think you should report those, so they can be removed or revised.

3
Jeroen van den Belt
Administrator
2 years ago
R
Superhero
René WSuperhero

Disable parameters / columns by default for concepts (layouts, contexts, defaults)Open

Why not automate it? Based on the code-templates it could be figured out what parameters are required to be passed to the default/layout/context procedure. This way you don’t have to worry about it and you also don’t have too many values passed trough to the procedure.Heck, if you write some smart regex you can probably do this already via dynamic model.

9
A
Superhero
2 years ago
Jaap van Beusekom
Vanguard
Jaap van BeusekomVanguard
asked in Questions & Conversations

Code search field, the magic trick?

Nice magic trick, but I think it is broken, the way it works now. This is merely a workaround. It is not really solved.

8
Mark Jongeling
Administrator
2 years ago
E
Moderator
Erwin EkkelModerator

Give a warning when manually deploying a view if triggers existOpen

Agreed.

4
Mark Jongeling
Administrator
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings