Replies posted by Daan Heemskerk

19 Replies

D
Sidekick
Daan HeemskerkSidekick

Allow the context procedure to overrule the SF settings.Needs feedback

I think that having both a hidden or visible state, and a default state could become confusing.If I say hidden, in for example the database layer, I mean hidden, but when it is a key, the key is still included in the export, while for me “hidden” means that ever showing it to a user is a bug. So, it is already confusing. In this case, as example, the platform should not show the key, and remark in the validation that import was disabled for the lack of a key.For me this concept means that somethings stays hidden, until a positive confirmation of the control procedure. It means that the interface will never show it, until the procedure says, yes do.I don’t know how to implement it in the current logic of your platform. But creating the possibility to program by enabling, instead of disabling, could be a huge improvement in different scenarios. 

8
Mark Jongeling
Administrator
21 days ago
D
Sidekick
Daan HeemskerkSidekick

Allow the context procedure to overrule the SF settings.Needs feedback

This is possibly a difference in thinking is between my thinking, and the Thinkwise “way”.As a developer I don’t want to “stop and hide”, but to “allow and give through”. My users can have the break, I have the gas pedal, and you build the engine.  

8
Mark Jongeling
Administrator
21 days ago
D
Sidekick
Daan HeemskerkSidekick

Multiple keys to select from detail in relationshipNeeds feedback

It seems like a solution.But what I don’t get is how this could “Influence” a prefilter. As far as I know or have seen, prefilters are static. The only route I see (based on what I know) is by creating a temporary table and that would give a lot of problems. ( People doing different queries in different tabs, etc. ).I would like to know how people made this connection in the software factory. I don’t want to program the possible categories in the prefilter, as they can be changed by users.As I kind of mentioned before I see a workaround, but that would require the page to create a new record ( invisible to the user ), and have this formlist, as detail, set settings based on the id of this record. This work around would also make other screen compositions possible. But, as I rater don’t have workarounds, or “inventions” in our application, it would be great if you could tell me how this has been done in the SF.

6
Mark Jongeling
Administrator
20 days ago
D
Sidekick
Daan HeemskerkSidekick

A little improvement of the tsf_user() functionUnder review

And this optimisation made that I also changed something else in the functionality.I made sure that the views behaved the way they should behave based on my identity when I used them from SSMS.If I run tsf_user while I’m logged in as “daan”, I get a guid. I changed the logic a little, so that the view I created returns “daan”. It is also possible to simulate other users while executing queries in SSMS. My slightly altered implementation makes debugging easier, and makes that fields like “updated_by”, show my name instead of a guid.

7
Mark Jongeling
Administrator
20 days ago
D
Sidekick
Daan HeemskerkSidekick

A little improvement of the tsf_user() functionUnder review

We are using Azure. There where a lot of unoptimized Queries, so I spend a lot of time looking at the execution plans. I noticed that the function sometimes entered up at a location where the function was executed for every row, while that was not needed. We have a medium big fact table, and about 90% of the users can only see 1% of the table. In our scenario, it makes a huge difference where SQL Server places the user rights in the execution plan. Even a further unoptimized query rus quit good, if you are able to dismiss 99% of the records at the start.The way things where build, using the tsf_user function, the optimizer from Azure did not understand this. When I changed it to a view, the optimizer did. 

7
Mark Jongeling
Administrator
20 days ago
D
Sidekick
Daan HeemskerkSidekick

Allow the context procedure to overrule the SF settings.Needs feedback

I disagree with this; “And if you use a Context procedure to show the details when they are relevant, it will be the same to hide these same details if the are not relevant. ”A car has a gas pedal and a break, I don’t think that you would like to drive in a car with only a break, and only a gas pedal on the highway would also be a bad idea. The way it is now, the platform only has a break. When I started we had code like this in our application;If option=1: hide b,c,d,e,f   -- 1 means aif option=2: hide a,c,d,e,f   -- 2 means bThat was completely unreadable, cleaned up for readability this became much shorter and more readable ( I shortened it here, in reality with the tabs / fields on different lines, the new version was 20 lines instead of 100, here the new version is a little bit longer then the old);hide a,b,c,d,e,fdeclare option_a INT = 1declare option_b INT = 2if option = option_a: show aif option = option_b: show bBut this solution still has one problem; when the loading of the

8
Mark Jongeling
Administrator
21 days ago
D
Sidekick
Daan HeemskerkSidekick

Multiple keys to select from detail in relationshipNeeds feedback

Thank you for the idea with the checkboxes.I have created a functionality like this before, outside Thinkwise, and it might actually be (almost) possible to duplicate this inside Thinkwise, but I’m afraid that it is not completely possible.The only “big” problem I see is that I can’t change the fields and the checkboxes on the parent screen dynamically, while they do. What I want is an interface like the interface on Tweakers. When the user adds a category, the category becomes a checkbox. It could actually be possible, and it could look better then in this idea, but it should not require the intervention of a developer to change the parent screen. 

6
Mark Jongeling
Administrator
20 days ago
D
Sidekick
Daan HeemskerkSidekick

A little improvement of the tsf_user() functionUnder review

And, sorry, I just checked and the function is already schema bound …  so that does not help.  But in the queries I checked a view still gave a much faster result then a function, it seems that SQL server is not good at optimizing UDF’s. 

7
Mark Jongeling
Administrator
20 days ago
D
Sidekick
Daan HeemskerkSidekick

A little improvement of the tsf_user() functionUnder review

And a small improvement to this platform would be to allow users to edit their last post, as I just spelled GUI instead of GUID. :-) 

7
Mark Jongeling
Administrator
20 days ago
tiago
Vanguard
tiagoVanguard
asked in Questions & Conversations

Next and previous buttons in detail

Ow 😥, I was really hoping for a keyboard solution (which should be possible in the new version, but just a limited set of keys). It is actually a difference between modern web based applications and old “dos screen like” applications…. some things have become less efficient. In our interface people enter values in an EAV table, which can be different for different people. At this moment they have to do a mouse click for each value with possibly a comment. I’m looking for ways to optimize that ... 

7
D
Sidekick
1 month ago
tiago
Vanguard
tiagoVanguard
asked in Questions & Conversations

Next and previous buttons in detail

Hi Mark,To comment on one thing, you said “I do think an arrow button could be a welcome addition for easily navigating between details”. That is not going to work as the arrow button is already used in the multiline text controls. The tab button is also not going to work as it should be used to navigate between the controls on one page.I think that the only solution, which is clear to users, would be page up / page down. 

7
D
Sidekick
1 month ago
D
Sidekick
Daan HeemskerkSidekick

Regenerate table and functionalities from Tables screenMerged

Yes, it overlaps, and it is of course something to think about in terms of how to implement it.I timed it and an smart upgrade, with the creation step takes 2 minutes, 15 seconds. I always make a mistake somewhere, especially when a template is used at multiple locations, or the field pops up as a filter for the user while I don’t want it. That makes that this 2:15 often becomes 5 to 10 minutes ( to add one field ).I was thinking about ways to shorten this, and anything that would make it possible to skip the creation step, and only deploy what is needed, would save time. You are right … in many cases auto generation won’t work, but an error with a clear list of what to fix would still save time. 

5
Mark Jongeling
Administrator
1 month ago
tiago
Vanguard
tiagoVanguard
asked in Questions & Conversations

Next and previous buttons in detail

But we would actually want to have the same…

7
D
Sidekick
1 month ago
tiago
Vanguard
tiagoVanguard
asked in Questions & Conversations

Next and previous buttons in detail

We wanted the same and a part has been build by a Thinkwise consultant, according to the idea of Mark Jongeling, but it is still more or less impossible to assign useful keys. The last is not a fault of Thinkwise, web browsers tend to capture keys for their own purpose, and that can make it difficult to use a key combination the user understands, and works in all browsers.

7
D
Sidekick
1 month ago
D
Sidekick
Daan HeemskerkSidekick

Declarative Layout logicOpen

I was just thinking… it actually could also cover a lot of user input cases, “If you click yes another input box shows” could be handled easily.  In our case that is not the most important thing. We want to be able to show or hide controls based on a field type.

5
Anne Buit
Community Manager
10 months ago
D
Sidekick
Daan HeemskerkSidekick

Declarative Layout logicOpen

You can rename this if you want.I think that being able to do common tasks client side could reduce the dependence of context and layout procedures, and with that a lag on the screen of the users.( at this moment our interface looks slow while the data fetch is fast enough; what happens is that there are a lot of layout and context procedure round trips,. This round trips fetch the record again based on the key. We query for the “Questions we want to ask”, so there is no real key before we have an answer, with the result that the same query is repeated for every round trip to the server ).We have users with bad internet connections, so, being able to minimize the round trips is quit important for me.This is one main idea; this way it is possible to send all data needed to make the decision to the user interface with the initial record. It doesn’t cover layout changes based on user input, but it does cover all layout changes based on the environment, and it would also work in offline mo

5
Anne Buit
Community Manager
10 months ago
D
Sidekick
Daan HeemskerkSidekick

Add, don't show if empty option, to tabs in the screen layouts.Merged

Yes, we could merge it. But I see more reasons to do so than in the other post.The main thing is that this could be decided client side based on offline data. At this moment we have a context procedure to hide tabs on which users don’t have to enter data, and that is a round trip to the server, plus additional logic, which is depended on the names of the references. and the expertise's of the user.It would be nice to just not show tabs without questions. This way we only have to maintain the questions at an more abstract level and don’t have to edit the code when something changes.

6
Anne Buit
Community Manager
10 months ago
J. de Lange
Captain
J. de LangeCaptain

Merge a branch to another branchNext release

I’m new, and just tested this. You are right… and I’m sorry that I can’t upvote this to a bug.Use case; the lead developer is planning a big database upgrade, and splits MAIN. The team decides to do smaller bug fixes/updates. In the overworking hours, the lead developer wants to merge the TEAM branch back into his LEAD branch, solve the conflicts, and merge the result into the TEAM branch, to be save he also remerges the MAIN branch into his branch, and that all to update MAIN to his LEAD branch in the next weekend.If you can’t do this you end in a lockdown situation; you can’t merge as you would create merge conflicts for others to solve, and that is not allowed. 

13
Anne Buit
Community Manager
1 month ago
D
Sidekick
Daan HeemskerkSidekick

Add, don't show if empty option, to tabs in the screen layouts.Merged

I don’t see how I can edit this after posting, so a little addition;Usage in case 1; there are 2 different record types with different data to enter. You create 2 views and subjects for those 2 record types. Depending on the record type you show data in one of the views, and the interface only shows the subject with data.Example; “a legal entity” can be both a human and a company. Both have a different form but share the same table. The user adds a “a legal entity” and selects company. Next the rest of the form appears, with a switch between the “company” and the “person” view. 

6
Anne Buit
Community Manager
10 months ago

Badges

Show all badges
Terms & ConditionsCookie settings