Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by J. de Lange

39 Replies

Newest first

Oldest first

J. de LangeCaptain

Use 'open lookup' as a start action for a process flowUnder review

Hi @J. de Lange, Opening a look-up can occur in multiple states, such as in Edit mode and Non-edit model. But also if the field with the look-up has a value or not, that also impacts the look-up after as the look-up will filter on the input value. Would it be a better solution if you could enforce a prefilter on the dropdown recordset which is not enforced when opening the look-up popup? That way you could limit the recordset in the dropdown to your liking but keep the entire/bigger recordset when opening the look-up. Like in your example, the dropdown would be limited to branches that are within the My branches prefilter set, and when opening the look-up, this prefilter is not active therefore showing all branches of the model. This would definitely solve most of our current use cases and would be a very welcome addition.I do feel that somehow linking this to process flows would allow for even more options which rely on already existing features in the SF. It would also avoid adding

J. de LangeCaptain

asked in Questions & Conversations

Why is my task parameter default input read only in the SF?

Hi, This happens when the Use defaults checkbox is unchecked for the table in Tasks > Settings > Form: Performance. Default Logic snippetThe state does not impact anything if Use defaults is unchecked. Use defaults is checked:

HarryACaptain

Use other hotkeys for Add & Delete records (ctrl+ / ctrl -)Open

I feel the problem isn’t so much that it’s impossible to zoom using hotkeys in the Universal GUI, but rather that a popular and standardized hotkey combination is used for something completely different in the Universal GUI.

BlommetjePartner

asked in Questions & Conversations

'Function' takes forever

We experience this as well (though since well before the last version)

Harm HorstmanSuperhero

asked in Questions & Conversations

Maps overlay

For future reference: If you want an overlay that looks like the ‘Truck-free zone’ in the docks, you can use data mappings instead of an overlay and create a polygon data mapping and feed it with waypoints through a view or table: Make sure that the map component uses a view or table that contains columns with coordinates in JSON for example:{ "CoordSets": [ [ { "Lon": "6.932740", "Lat": "53.329700" }, { "Lon": "6.932740", "Lat": "51.329700" }, { "Lon": "8.932740", "Lat": "51.329700" }, { "Lon": "8.932740", "Lat": "53.329700" }, ] ]}and each row should contain a definition of the type of entity you want to display on the maps. You can make a domain with elements for this and select the element you would like to display on each row.The two columns (coordinate and

Harm HorstmanSuperhero

asked in Questions & Conversations

Maps overlay

The overlays work much the same way the base layer works. You need to find (or create) a tile source which takes /{z}/{x}/{y} in the url. Z being the zoom level for which you can define a min and max zoom level in the software factory.Here is an example of a configured overlay: Is this enough information or is there a specific problem you try to solve?

Jeroen van den BeltAdministrator

published in Questions & Conversations

Survey closed, see topic for results: using the Model content (Full model) screen

How often do you use “Model content”? Maybe once every two weeks Which screen(s) in “Model content” do you use the most? Columns, prefilters, process variables, templates What actions do you perform here in particular? To search and compare objects without having to go back and forth through detail tabs Would you be able to perform the same actions in the regular SF screens? If so, what is the reason you still use the “Model content” screens? I don’t think displaying these without their context is preferable in the regular screens

Allard LakerveldSidekick

asked in Questions & Conversations

Detailscreen of row that is removed

If I understand this correctly, you may be closing the document with a process flow after you’ve closed all items. In which case the error is still displayed. You may be able to solve this by closing the document before closing the item by closing the item later in a decision/system task in your process flow in stead of closing it as part of task add_work_item_to_carrier

Arie VSuperhero

Determine if next Process Action should be executed immediatelyPlanned

The merging of actions stops when a process action has an output variable mapping - this would be able to affect subsequent action input and as such cannot be merged. The process action with the output variable mapping will be the last merged process action. The merging of actions stops when there is process logic - this may both affect action input and which steps are executed. The process action with process logic enabled will be the last merged process action. We have implemented custom flow monitoring for all of our process flows. To log actions and the current state of process variables we use dynamically assigned process logic. It seems we would have to rework this to make this merging of actions possible even though this monitoring process logic never changes which steps are taken.Would this merging of process actions still work if we only assigned our monitoring to the last merged process action? If so, we can change our dynamic code to only assign the monitoring to these la

Balazs SzederRookie

asked in Questions & Conversations

Can't seem to validate this error.

It does appear to be an error in the validation itself. The database values are of type tinyint and range from 0 – 10. Element ‘void_space’ here has db_value 10 which when ordered as an integer should be sorted to the bottom. The validation however sorts on the software factory column elemnt.db_value which is of type varchar(25). The value ‘10’ gets sorted before ‘2’ since these are strings and get sorted as such.A cast to tinyint like shown below solves the problem. Perhaps this validation should cast the elemnt.db_value to the Data type defined by the user in the SF: We’ll approve the validation for now since there doesn’t seem to be any problem with the domain.

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Suggestions to consult API during filling out a form.

That is not possible yet, but feel free to create an Idea. Starting short process flows or something similar after updating a column in a form or pop-up would be a nice concept to have I think. I believe this idea already exists and would solve this problem:

J. de LangeCaptain

asked in Questions & Conversations

with inline = on - iTVF subroutine causing errors

After some testing, TVF’s with the is_inlineable property set to 1 appear to be inlined automatically.For anyone else who wants to inline a TVF:TVF’s defined using the SF with the Return table value set will always fail the requirements and won’t be inlined.Instead leave the return table empty and don’t set the Inline option:In the template don’t insert values into a table variable, instead return a set immediately: Check if your TVF is inlineable by using:select o.*from sys.sql_modules owhere exists( select 1 from sys.objects x where x.object_id = o.object_id and x.name = <your TVF name>)if is_inlined is set to 1 it should be inlined automatically by SQL server (2019 and up)It works like a dream now.

J. de LangeCaptain

asked in Questions & Conversations

with inline = on - iTVF subroutine causing errors

I think with inline = on is not available to TVF, only to Scalar UDF, so table-valued functions cannot be inlineable using this statement. This might be it. It seems the option isn’t available. There are loads of blog posts mentioning that it is possible to inline TVF’s but none of them use this option. I’ll check if it’s possible to inline a TVF without using the option.

J. de LangeCaptain

asked in Questions & Conversations

with inline = on - iTVF subroutine causing errors

I can’t get this to work. Manually altering the create function query made it possible to create a table valued function that seems to meet the requirements. if exists (select 1 from sysobjects where name = 'get_calculation_component_overview' and (type = 'FN' or type = 'TF' or type = 'IF')) drop function "get_calculation_component_overview"gocreate function "get_calculation_component_overview"( @calculation_id bigint )returns table--with inline = onas return select * from calculation_component cc where cc.calculation_id = @calculation_idgois_inlineable is now set to 1:If I try to set the with inline = on option it still throws the “invalid option was specified” error...

J. de LangeCaptain

asked in Questions & Conversations

with inline = on - iTVF subroutine causing errors

It’s an empty template only containing return;After executing it on the database without with inline = on and checking the inlineable compatibility with select o.*from sys.sql_modules owhere exists( select 1 from sys.objects x where x.object_id = o.object_id and x.name like '%get_calculation%')I can see that is_inlineable is set to 0. Which would indicate that the function doesn’t meet the requirements. I wonder what requirement and empty function doesn’t meet though. Adding a tiny template which inserts a row into the table variable which gets returned doesn’t change it either.I’ll check if there are any other requirements I do not meet with this function.

J. de LangeCaptain

asked in Questions & Conversations

with inline = on - iTVF subroutine causing errors

Hi, Could this be the problem?: https://dba.stackexchange.com/questions/264596/subscription-initialization-throws-error-the-option-inline-on-is-not-valid-fo There may be an issue surrounding this inside SQL2019 at some point. I hope the thread above can help out. This thread mainly seems to address an old issue that caused the with inline = on to be added to incompatible table valued functions and this was supposedly fixed in with the QL 2019 CU6 update. We’re at CU8. I want the with inline = on option. I specifically set it using the subroutine options in the SF. The problem is that this always results in an error.The thread does contain a single comment mentioning a problem with CU9 but googling this problem doesn’t give any useful results. Has there been any success creating inline table valued functions? And is this option in the SF the way to go about creating them?

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Suggestions to consult API during filling out a form.

We have been considering the same functionality as well. The easiest way to implement something like this would be to start a process flow after committing the form of a task, use a http connector to make the API call and then either commit the data to tables or, in case of invalid data, show a message and activate the task again to let a user fix their values.This isn’t quite what you seem to ask for though. If you want immediate validation of data while the user is still in the form (without saving the data first) or want to auto complete for example an address while the user is filling a form, it gets a lot more complicated.One way of theoretically doing this would be to add a default procedure to a form which inserts data that needs to be checked to a table as soon as a user leaves the field. A scheduled system flow should check this table regularly (scheduled every few seconds) and make an API call to validate the data whenever there is a new row with data that hasn’t been checked

Robbert van TongerenThinkwise blogger

published in News & Blogs

JSON examplesTutorial

Cheers! You just saved me an entire chapter for the API integrations manual I was writing.

J. de LangeCaptain

asked in Questions & Conversations

How to set the size of a circle in the map component?

Just for future reference: what does the number set for radius represent? Pixels? Meters? Degrees longitude?

J. de LangeCaptain

asked in Questions & Conversations

Change detection @col parameter not filled.

Hi Mark,It’s a component tab page only having a Form. Apologies for the confusion.

J. de LangeCaptain

asked in Questions & Conversations

Maps component data mapping

What about the show data mapping boolean? It doesn’t appear to be doing anything right now.

Erwin EkkelModerator

Process flow as action to connect process flowsCompleted

I don’t see the sub low process action in the TSF. Am I missing something or did this get postponed?

J. de LangeCaptain

asked in Questions & Conversations

Merge a branch to another branch

Hi, Version 2021.2 does have the option to create branches from branches. You can only merge a branch to a branch or truck that the branch was branched off from. Example: Trunk > Branch >Branch_Branch >Branch_branch_branch You can merge Branch_branch_branch into Branch_Branch, then into Branch, then into Trunk. Using this diagram as another example: Branching and merging: docs While it is possible to merge Feature branch 1 into the trunk (or the other way around), it is not possible to merge Feature branch 1 into Feature branch 2 nor Sub feature branch because Feature branch 1 was not created from those branches. Hope this helps! Thank you for the swift reply. We’ll have to rethink the way we handle branches a bit. Hi, Well I'm interested what your branching strategy is going to be. Please let us know. We have some, I think, similar difficulties: The thing is we are used to the possibilities of Gi

J. de LangeCaptain

asked in Questions & Conversations

Merge a branch to another branch

Hi, Version 2021.2 does have the option to create branches from branches. You can only merge a branch to a branch or truck that the branch was branched off from. Example: Trunk > Branch >Branch_Branch >Branch_branch_branch You can merge Branch_branch_branch into Branch_Branch, then into Branch, then into Trunk. Using this diagram as another example: Branching and merging: docsWhile it is possible to merge Feature branch 1 into the trunk (or the other way around), it is not possible to merge Feature branch 1 into Feature branch 2 nor Sub feature branch because Feature branch 1 was not created from those branches. Hope this helps! Thank you for the swift reply. We’ll have to rethink the way we handle branches a bit.

Alban_TCaptain

asked in Questions & Conversations

prefilters per role

To add to my colleague’s comments: we actually use a single pre-filter query to filter records based on the combination of a specific User Group assigned to the Current User and the Company of that User, both retrieved from IAM tables/views indeed. Probably that Company field (or another field on the usr View from IAM) could be used for the Warehouse location. I presume the same kind of pre-filter could be used on the Lookup field. In this solution no Variants are needed. @J. de Lange I am referring to the Broker User Group on the Contracts table, perhaps you can share some code. Prefilter:/* Give users access to legal accounts of the company they belong to*/( select u.company_name /*the company name the user belongs to*/ from iam_usr u where u.usr_name = dbo.tsf_user() ) = ( select a.official_company_name /*The company name this legal account belongs to*/ from account a where a.account_id = t1.broker_account_id)Where the iam_usr view uses the following

1
2

Page 1 / 2

Badges

Sanne Buitelaarhas earned the badge Geek
André Heijmerikshas earned the badge Preparator
Yarahas earned the badge Geek
Robbert van Tongerenhas earned the badge Firestarter
HJ van Dalfsenhas earned the badge Transcriber

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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

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