Replies posted by Robert Jan de Nie

137 Replies

Kasper Reijnders
Kasper ReijndersPartner
posted in Questions & Conversations

Payments in Thinkwise

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

2
Kasper Reijnders
1 year 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
9 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
4 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

3942
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
9 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
E
Moderator
Erwin EkkelModerator

Give a warning when manually deploying a view if triggers existOpen

Why not just re-apply the instead of triggers as well? Hey, while at it, just deploy the whole package for the table (view) you have re-createdcreate or alter view apply instead of triggers apply layout procedure apply default procedure apply context procedureThis way, even if you have added or removed a field, the rest of the application keeps working or gives a specific error (i.e. you removed a column that is being used in the default).

4
Mark Jongeling
Administrator
3 years ago
E
Moderator
Erwin EkkelModerator

Task option: only one running task at a timeDeclined

@Erwin Ekkel I disagree. The application / code / procedure should be able to have multiple running instances. If this is causing problems, this should be resolved programatically. How would applications with multiple users work? You, as a user, need to guess if one of your 1,000 colleagues is running the same task?I think if you have a situation like this, you should use some kind of queueing mechanism instead and have a single background thread (systemflow?) handle running the actual logic.

7
E
Moderator
3 years ago
E
Moderator
Erwin EkkelModerator

Optional alternative translation object for duplicate entriesOn the backlog

Just wanted to post this idea as well. For columns for example, you could have a checkbox: use_alt_translation. This would create an entry in the translations, something like tablename.columname, that you can translate differently for a specific table.

7
M
Sidekick
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings