Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Daan Heemskerk

24 Replies

Newest first

Oldest first

Daan HeemskerkSidekick

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

I just looked up the previous post I mentioned and it is open under “Declarative Layout logic”. Here it is not about the context procedure but about the layout procedure.So, to come back to your “Business rule engine” side idea, that could also apply to layout logic. And the simplest implementation would be to make the visibility of something in the context, or a field on the form, depend on the value of another field.That way it would become possible to write a view in which the visibility is defined in fields hidden for the user, but still available for the user interface to decide what to show or not. A “small” problem (actually the biggest) would be the lazy loading of the interface; at this moment it is not possible to show something that hasn’t be shown before, when offline. So, the business rules concept would require to load the whole user interface layout at once … which might actually improve speed big time ( I was thinking about posting this as an idea, but I don’t think tha

Daan HeemskerkSidekick

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

Yes,Business rule engine-----------------------------The business rule engine was actually something I mentioned before somewhere else.The good thing about that concept would be that it could work client side, and would allow for offline usage. But the cases this engine could handle would still be limited. In a lot of cases, providing context settings, in the main dataset, would actually work.More general------------------------I think that your idea might actually not ask for a lot of adjustments. ( Possibly a lot in the code but not in the user interface ). And I believe that your idea as described above aligns with my idea. The main problem I see in our application now is that it often happens that the user interface shows everything in case of a network timeout and hides it a second later, which makes everything look unreliable. I believe that the option you mention might actually almost be there; Maybe it is already there but it doesn’t add the parameters to the context procedure

Daan HeemskerkSidekick

Maintenance modeNeeds feedback

When we do an update and the update, for example recreates the fact table, the update can take a long time.We do send a mailing to the users to warn them that they should not use the application during this time.It might be better to have a way to lock the users out completely. At this moment I could organize in Azure that users get redirected, but as Universal can still be open in the browsers of users, there is still a risk that users get in a confusing situation.The ideal scenario would be to have a setting in IAM, which makes that the user gets an “this site is under maintenance” message in the interface, and is prevented from entering data.

Daan HeemskerkSidekick

Multiple keys to select from detail in relationshipNeeds feedback

I mean, the record Id is in the url here, but not in our application, and I think that this is a difference between the web interface and the universal interface.

Daan HeemskerkSidekick

Multiple keys to select from detail in relationshipNeeds feedback

Yes, Thank you,I understand the solution like this. There is one small bug; if the user opens the application in 2 browser tabs and makes different selections they interfere. I was breaking my mind over a way to work around this little problem.I think that the solution would be to create a new unique key in the selection table each time the selection changes, and this would only work completely if Thinkwise would keep the current record id in the url and navigate to it during a refresh. ( It would also allow for url sharing of a selection ).I just noticed that opening this url in another browser redirects to the same topic.How do I do this?

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.

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.

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.

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.

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.

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

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.

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.

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. :-)

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 ...

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.

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.

tiagoVanguard

asked in Questions & Conversations

Next and previous buttons in detail

But we would actually want to have the same…

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.

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.

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

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.

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.

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.

Badges

Daan Heemskerkhas earned the badge Geek
NickJanssenhas earned the badge Critical Thinker
Roelhas earned the badge Hero
Martijn_Reedehas earned the badge Geek
Dennis Kallanseehas earned the badge Geek

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your email address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK