Replies posted by Robert Jan de Nie

139 Replies

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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
Mark Jongeling
Administrator
Mark JongelingCommunity manager

Provide code example when creating an Expression, Calculated or Calculation (Function) columnCompleted

Great idea! I always get the proxy function wrong! 

8
Jeroen van den Belt
Administrator
7 months ago
Robbert van Tongeren
Thinkwise blogger
Robbert van TongerenThinkwise blogger
published in News & Blogs

JSON examplesTutorial

Another useful function when assembling json is STRING_ESCAPE, this way you can clean up your input when assembling json, for example when you want to pass HTML strings into your json array.Like so:select eo.email_subject as subject ,STRING_ESCAPE(eo.email_body,'json') as body from email_object eofor json auto 

5956
Frank Wijnhout
Thinkwise blogger
8 months ago
Freddy
FreddyThinkwise Local Partner Brasil

Upgrade rollbackOn the backlog

@Mark Jongeling is there an e.t.a. on this one? 

8
Jeroen van den Belt
Administrator
10 months ago
Freddy
FreddyThinkwise Local Partner Brasil

Upgrade rollbackOn the backlog

Great, let me know if you need any input. Happy to help.

8
Jeroen van den Belt
Administrator
10 months ago
E
Sidekick
Edwin SaanSidekick
posted in Questions & Conversations

QR code payment link on invoice

Hi Edwin,I think the most important part is to follow the API-reference documents to the letter.Keep in mind that the user can at any step leave the payment process (close their browser). So not only send a user to the payment provider’s page to do their payment but also validate if the payment has been made successfully.Dependent on the payment method (ideal/credit card/bank transfer) it can take a while for the actual payment to be completed. In those cases the payment provider will report back an ‘ok-message’ stating the payment process has been completed successfully. This does not have to mean the money will actually arrive. For example the user could have hit their credit card limit and the payment has been cancelled.This means you have to implement several processes in order to completely process the payment.User payment process: user is able to pay trough the payment provider service Payment process completed: follow up process after a successful (preliminary) payment Payment p

3
Robert Jan de Nie
Thinkwise blogger
1 year ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

What happened with the Full Model screen?

Jeroens question… Yes, it would be really annoying. Primary reason is that model content/full model is the best way to figure out the data model driving the Software Factory.Furthermore it helps when you made a mistake. For example you’ve added a column in the wrong table, closed the data modeler and need to find the column you’ve just added. You can just open the columns tab, sort by date added and hit delete. To conclude, there are weeks in a row I don’t access model content but in some cases it is useful. I can imagine if it makes it harder to support the processes from this screen (using process flows for example in the regular screens) you could make model content read-only. 

4
Robert Jan de Nie
Thinkwise blogger
1 year ago
Blommetje
BlommetjePartner
asked in Questions & Conversations

Show superscript in grid

Could it be an exotic font you are using that the local user does not have installed?

2
Jeroen van den Belt
Administrator
10 months ago
E
Moderator
Erwin EkkelModerator
asked in Questions & Conversations

How to make an IAM user db_owner

I'm sure there is ways around granting db_owner in order to run external scripts. Especially anything coming from the ‘outside world’, should be running with minimal privileges.

3
E
Moderator
11 months ago
Anne Buit
Community Manager
Anne BuitCommunity Manager
published in News & Blogs

Switching from SSMS to Azure Data Studio - Tips & TricksBlog

A scary thought, @Anne Buit, making a switch from a tool we are all so familiar with. But I think switching to Azure Data Studio is a safe bet. It seems all new developments take place in VS Code and Azure Data Studio, so it makes sense to take the plunge.Personally I really like how Azure Data Studio handles JSON, instead of returning (a part of) the JSON string when creating JSON, Azure Data Studio does all the markup and syntax highlighting for you. Also you get the full output instead of just a part of it.JSON output 

238010
M
Sidekick
3 months ago
Anne Buit
Community Manager
Anne BuitCommunity Manager
published in News & Blogs

Switching from SSMS to Azure Data Studio - Tips & TricksBlog

If you're searching for a way to auto-format your SQL-code according to the Thinkwise guidelines, there's an extension called ‘Redgate SQL prompt’ in which you can paste a ‘.formattingstyle’ file (JSON) that contains the formatting to your liking.    Does Redgate also work with Azure Data Studio?

238010
M
Sidekick
3 months ago

Badges

Show all badges
Terms & ConditionsCookie settings