Replies posted by Robbert van Tongeren

71 Replies

Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger

Easier way to add tags to objectsCompleted

I have voted (again).

9
Robert Jan de Nie
Thinkwise blogger
5 years ago
Jop ter Horst
Vanguard
Jop ter HorstVanguard

Combine prefilter and tasksClosed

[quote=Jop ter Horst] [quote=Jasper]It certainly is an original idea! Any suggestions on how to indicate to the user that it is possible to drag rows on the prefilter (or the other way around)? And what to do if the prefilter contains ambiguous conditions, for example [i]price > 100[/i] or [i]status in (1, 2, 3)[/i] ? Maybe it would be better to have some sort of drop areas or tiles onto which you can drag rows to execute a task.[/quote]Maybe make it possible to assign a task control procedure to a prefilter. It would be up to the SF developer to make it intuitive to use. If a prefilter is simple (status = 1), it could just execute the task, and when it is ambiguous (price >100, status in (1,2,3)) it could be solved by showing some task parameters I figure. I'm still thinking about how to UI/UX-wise make clear that a prefilter is a task too. But you could leave that up to the developer. It would be nice though to be able to change background colors seperately between ribbon i

9
Jeroen van den Belt
Administrator
3 years ago
R
Apprentice
Rémon BalApprentice
asked in Questions & Conversations

Is it possible to update a record via linked server with a mobile app?

Does the application pool user (the one that controls indicium) have rights to the linked server?

9
R
Apprentice
5 years ago
R
Apprentice
Rémon BalApprentice
asked in Questions & Conversations

Is it possible to update a record via linked server with a mobile app?

When the linked server in a default is not working you can always work with a extra table where you insert the barcodes and let a job on the background handle the communication to the linked server. This will also help when the linked server is being slow for some reason and makes the scanning for the user faster. Did you check the authorisation on the linked server?

9
R
Apprentice
5 years ago
htimmermans
Captain
htimmermansCaptain

Filter on dateTime fields using "between" when no time is entered.Completed

On which version of the GUI and SF are you working? I have a 2018.3.18 GUI version on a 2018.3 SF, and what you describe is exactly how it works in my situation. Example: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/5ae81c15-534f-4612-bcb2-a7ba5fc5f4ab.png[/img] With result: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/078b2405-048c-4e50-a04d-9417538ba288.png[/img] Query looks likes: ((t1.[update_date_time] >= convert(date, '2018-11-12', 120) and t1.[update_date_time] < convert(date, '2018-11-13', 120)))

5
Roel
Moderator
4 years ago
htimmermans
Captain
htimmermansCaptain

Filter on dateTime fields using "between" when no time is entered.Completed

I didn't see it was a DB2 specific problem, I think this should be a TCP ticket indeed as for SQL it seems to work like it should.

5
Roel
Moderator
4 years ago
K.Bakkenes
Captain
K.BakkenesCaptain
asked in Questions & Conversations

Assemblies for deployment

1 option is that once the assembly is created on the development server, you can script the assembly into a script via management studio: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/66e7b501-a0b4-4b94-ada2-15b0b70c62d6.png[/img] This will result in a script like: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/3fbee2a6-9796-4c54-bc67-b3b36ea74fb0.png[/img] (You can also make a drop and create script) This script you can put in the upgrade code group: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/12aebefe-8c12-4483-89d3-eacd5c5ddfc2.png[/img] This way, the script will execute on every environment you roll out. a 2nd option is when you do want to move the DLL file across, is to create a subroutine with the type DLL assembly, then in the options you can set the name and path for the DLL and the SF will create scripts to create the assemblies. Hope this helps.

2
K.Bakkenes
Captain
5 years ago
Eric Franken
Vanguard
Eric FrankenVanguard
asked in Questions & Conversations

Parameter papersource when using the reporting service

Hi Eric, The latest version of the Reporting service does exactly this, you can download the newest version (3.20) from TCP. From the changelog: "Added support for specifying which paper source/tray to use on a printer through an optional printer_tray column in the rpt_get_reports procedure."

6
T
Moderator
4 years ago
Eric Franken
Vanguard
Eric FrankenVanguard
asked in Questions & Conversations

Parameter papersource when using the reporting service

The manual is being worked on. A short explanation: Add a column 'printer_tray' to the result set of the procedure: 'rpt_get_reports'. [user=53]Tim Waalewijn[/user] is working on the manual, when its ready we will post a link on here.

6
T
Moderator
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager

Opening menu/tile items by a shortkeyOpen

As an addition, if you assign a short key to a task, and add this in the menu, the shortcut will be ignored, it would be great if this work as well.

1
Robbert van Tongeren
Thinkwise blogger
4 years ago
E
Sidekick
Edwin SaanSidekick

Read and write pre-filter settingsClosed

Have you looked into the possibility of using process flows?

2
Anne Buit
Community Manager
4 years ago
D
Vanguard
Dennis BeerenVanguard
asked in Questions & Conversations

Error caused by display_expression

It seems to me that the expression in "display_expression_2" is not correct, it seems to be unable to find the column "jaar". Also the expression in "display_expression_1" is empty, (This could also be the problem to the error, try adding a value here ('test' for example), or delete the column when its not needed anymore.) If you want to debug the calculated field query in "display_expression_2" you can do something like: select ( --Paste here the query from the calculated field query from the "display_expression_2" ) as display_expression_2 ,t1.* from [table] t1 --Where table is the table where the expression field is defined in the SF. To answer you question, dependent is automatically filled by the SF when referencing a column in the table, with the t1. prefix. (t1. referencing to the "current table" in the expression field.) Hope this helps.

2
D
Vanguard
4 years ago
htimmermans
Captain
htimmermansCaptain

Possibility to make domain elements "Inactive"Completed

As a work around you could write a default procedure which empties out the field (domain with elements) when the user select a value which is not longer active (You can even use a table to determine which element is no longer active.). When you empty out you can also create a popup message explaining that this value is no longer active to help the user.

14
Jeroen van den Belt
Administrator
2 years ago
Raj Rozendaal
Sidekick
Raj RozendaalSidekick
asked in Questions & Conversations

Automatically download files in a task

[quote=Tom van Druten] [quote=Erik Brink]Please try to pass it through to a Task of type "Windows command". For more information: https://office.thinkwisesoftware.com/docs/docs/sf/tasks.html#windows-command[/quote]So in fact you're running a CMD by running it? Does it run on the local user? I think I'm looking for this in a case I have! I tried using the move file connector in process flows, but this has some restrictions, because it looks like it doesn't run on the local user.[/quote] Yes, I believe you are running a CMD command, also this is from the local user. (Which is why it's only working on the windows GUI and not the web / Mobile.)

8
Erik Brink
Moderator
4 years ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

Rename Template task failed because of related 'program object item parameters'

[quote=Tom van Druten]I'll talk with my team about this... we should really upgrade to 2018.3 Thanks![/quote] 2019.1 you mean. :sunglasses:

4
Tom van Druten
Warrior
4 years ago
Robbert van Tongeren
Thinkwise blogger
Robbert van TongerenThinkwise blogger

Copy IAM groups from another IAM (2019.1)Open

This is a tricky one. If the customer is setting up the groups then we would rather see it in IAM. In our case, the customer is setting it up.

2
Robbert van Tongeren
Thinkwise blogger
4 years ago
K.Bakkenes
Captain
K.BakkenesCaptain
asked in Questions & Conversations

GUI aborts a transaction when a tsf_send_message is shown

What are the settings of the message within the SF? (Which severity?)

4
K.Bakkenes
Captain
4 years ago
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations

Error: screen type could not be save

The problem might also be that you need to select a detail group for your detail page, this is a dropdown field. When the field is empty you can add detail groups in the tabpage "detail groups" [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/e1f16bd5-d538-4e27-a18a-dce0a01427fe.jpg[/img]

4
Mark Jongeling
Administrator
4 years ago
Moller Toma
Captain
Moller TomaCaptain
posted in News & Blogs

Thinkwise release event 2020.1

Please share the recording…. Via the link “Watch the live steam here!“ you can watch the recording.

5
R
Rookie
4 years ago
E
Moderator
Erwin EkkelModerator

Automatic data conversion on rename of columnClosed

I just realize I had the same problem.For me the problem occurred when I created a new project version and did not generate the definitions.When I created the project version and renamed a column, then generated the definition it did not create a correct record in the data conversion.But when I created a new project version and then generate the definition before renaming the column it seemed to work.Could you verify this?

10
Robert Jan de Nie
Thinkwise blogger
1 year ago
D
Moderator
Diana KuipersModerator
published in News & Blogs

Improved data security with unauthorized columnsBlog

Looking forward to this!Question: Hoe is the execution of the default / layout and context procedure being handled when a column is unauthorized?

1634
Anne Buit
Community Manager
3 years ago
P
Captain
Peter KruisCaptain
posted in Questions & Conversations

tsf_send_message in Indicium Mobile App in task stops default

Hi Peter, Can you give some more of the default code?

4
P
Captain
3 years ago
P
Captain
Peter KruisCaptain
posted in Questions & Conversations

tsf_send_message in Indicium Mobile App in task stops default

I don't see anything in the default procedure which would cause this issue.I do recommend to use the parameters in the send_message to only send the information which is not used for translations, this is easier to maintain the translations of the messages, the “hardcoded” way, which you are using now, you are unable to translate this. See the documentation for more info: https://docs.thinkwisesoftware.com/docs/sf/messages.html#parameter-string For the error you are experiencing: It could be a mobile GUI issue.You could check this by looking in the devtools network tab and see if the default procedure is giving a 200 OK and giving back the expected values. Could you verify this?

4
P
Captain
3 years ago
Jasper
Administrator
JasperAdministrator
published in Questions & Conversations

Multirow task execution

I have created a dynamic control_procedure which automatically generates a @xml_table for each task that has a parameter which is the same as the property_value of MultiselectParameterID.The goal of this procedure is that we don't have to retrieve the XML manually for all the XML variables and we have the same xml_table for each task procedure, also when we add a new parameter to the table task, this will be added automatically. This way you can use the table @xml_table in the template code for the task, instead of reading out the XML parameter every time you need some data.Code for the template:declare @xml_table table ( [comma][task_parmtr_id] [dom_id])insert into @xml_table ( [comma][task_parmtr_id])select [comma]row.value('./[task_parmtr_id][1]', '[dom_id]')from @[xml_variable].nodes('/rows/row') as c(row)Code for the control_procedure (Assignment "SQL”, code group "TASKS”):--Definition of the MultiSelectParameterIDdeclare @extended_property_id extended_property_id = 'Mul

228336
A
Captain
29 days ago
D
Moderator
Diana KuipersModerator

Release notes Universal GUI (2021.2.14)Release notes

ALT+F1! &lt;3

4411
Robbert van Tongeren
Thinkwise blogger
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings