Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Renée Evertzen

85 Replies

Newest first

Oldest first

Jaycee_CVanguard

asked in Questions & Conversations

Is it possible to multiselect values in a task parameter?

Hey Jaycee,As far as I know the short answer to your question is no. You can create workarounds such as implementing a view with checkboxes to mark which values you want to use, and then execute a task based on the selected value(s), or allowing the user to fill a long string that you then subsequently split in the task code. But our GUI does not offer the functionality of having a multi-select-input.Maybe someone else knows something I don't know yet 😅

timApprentice

asked in Questions & Conversations

CTE in DevExpress report designer

Hey Tim,I'm not sure if I understand your question for the full 100%… but I believe that this error notification is a security measure taken by DevExpress to prevent SQL injections: https://supportcenter.devexpress.com/ticket/details/bc3280/default-validation-for-custom-sql-queries-allows-only-select-statementsI also noticed by executing a short search that it is possible to disable this specific validation: https://supportcenter.devexpress.com/ticket/details/t395653/a-custom-sql-query-should-contain-only-select-statements-when-moving-from-15-1-4-to-15Is it an option to move the CTE to the underlying view that is called upon by the DevExpress report and use the CTE to compile the required data, that you can then call upon from the DevExpress report? Personally I prefer this option because it also simplifies the possible future maintenance on the report.

Mark LeunissenSidekick

asked in Questions & Conversations

Import excel update existing rows

Hey Mark,As far as I know the option Update existing rows is not something that can be predetermined with a setting in the Software Factory. It is automatically selected when adding is not an available CRUD action on the table that you're trying to import into, but updating is allowedIf adding is also an option on the table you're trying to import into, you would have to specify whether you want to add new rows or update existing rows, which makes it impossible to select the option to update existing rows by default.Does this answer your question?Kind regards,Renée

H. LukassenSidekick

asked in Questions & Conversations

Outlook mailadres via parameter and not mine default emailadres

Hey,Sorry for the late reply, this topic went under my radar for a few weeks.I think you need to change the value of your e_mail parameter to the ribbenvloeren@geleen-beton.nl. As that is the email address that you want to be sending the email from. This can then still be changed, since your parameter is editable. If you wish you can also determine which value this should have through use of a default, for example.Does that help?

H. LukassenSidekick

asked in Questions & Conversations

Default field width printer

Hello,Matthijs’ answer is almost correct. In this case you would have to change the field width of your report parameter instead of your task parameter. The finicky thing is that the first four parameters are GUI parameters and thus cannot be modified form-setup wise. However, you can adjust the width of the order id, which in turn should enlarge the width of the other four parameters as well.Hope this answers your question! 😄

MatteoSangiorgiPartner

asked in Questions & Conversations

Resource scheduler - delete appointment

Hey Matteo,Could you maybe share a screenshot of the full GUI so that we can get a better picture of what you're trying to achieve?Currently I would tend to answer that you should be able to just use the regular delete button or you can maybe assign a task that will allow you to do this, but it's hard to tell without knowing the full picture of your situation.

Alex KerschkampCaptain

asked in Questions & Conversations

How to use IAM user details within application itself

Hey,In my case the field usr_id holds my actual username, the same username that is assigned to my user at the database/server level. So in the case of Thinkwise employees this is something like thinkwisedomain\myname.Could you maybe share a screenshot of what your IAM user looks like at the database level? If you don't want to share sensitive data, you can also just create a dummy user and show what that looks like. Maybe that will help me to better understand what you mean 😅But in any case, if you want to create automatic linking between IAM users and the driver table in your end product you can try to build your own interface between IAM and your end product. However you would still need something recognizable at both levels to base the interface on, i.e. to create the link between both applications. This can also be the first name and the surname if that works for you guys, but I can't judge that.

Alex KerschkampCaptain

asked in Questions & Conversations

How to use IAM user details within application itself

Hey Alex,The value that is returned by tsf_user() should be the same value as the user's User id in IAM. So if you would add the value of this User id to the driver table, this would allow you to filter the data selection based on the user that is currently logged in. This can be achieved by using the tsf_user() in your prefilter query, for example.Does this help?

Mark LeunissenSidekick

Excel export does not contain group labelsCompleted

Hi Mark,As far as I know group headers are never included in the export to Excel. I will convert this topic into an idea for you so we may take it into consideration for implementation in the future.

Dennis van LeeuwenHero

asked in Questions & Conversations

How to fill a task parameter based on a cube field?

Hey Dennis,The reason for this is mostly what is already written in the Consequence value of the validation: “Because the cube does not have all PK fields as cube fields, the task or report parameters cannot be correctly filled". Since the task is connected to the cube itself it is required to know the full PK in order to select from the underlying view that the cube is based on, thus making it possible to pass on the correct parameter(s) to the task. When you leave one or more of the PK values out from the cube, it will not be possible for the GUI to select the appropriate record because the full PK is not known.I hope this explanation clarifies things a bit, and it’s good to see that the validation helped you find the issue and resolve it! That means that our validations are doing what they are supposed to do 😄If you have any suggestions on how we could possibly improve the text of the validation to make things a bit more clear for the developers using the Software Factory, please l

Dennis van LeeuwenHero

asked in Questions & Conversations

How to fill a task parameter based on a cube field?

Hey Dennis,Could be me but it seems like the invoice_id in your cube is empty? If it is empty in the cubei tself it will also be empty in the task pop-up. But I can't say with 100% certainty because your task pop-up overlaps the cube values a little bit.Perhaps a silly question but have you checked whether the view is actually returning a value for the invoice_id? 😅

H. LukassenSidekick

asked in Questions & Conversations

Outlook mailadres via parameter and not mine default emailadres

Hello,Just making sure but are you sure that the value of the reply_to is actually used when sending the email? I'm not sure what kind of mailer you are using, which makes it a little hard to answer this question. Maybe you can share a couple more screenshots of how you have setup the mailer itself etc.?

Tejo van de BorCaptain

asked in Questions & Conversations

disable drag drop in context

Hey Tejo,If the context disables the tasks that are used for the drag-drop functionality, the drag-drop itself will also automatically not be possible. You don't need to write a separate context procedure or setup different settings for this specifically.Does this answer your question?

Tejo van de BorCaptain

asked in Questions & Conversations

Show project version

Hey Tejo,The only method through which this can currently be achieved is by putting the project version in the translation of your application in IAM. That way it will be visible to the user in the top bar of the application. When there are multiple applications it will also be visible in the application list in the bottom left corner.Would this help?Also as a bit of a heads-up: from the 2023.1 version project versions will cease to exist. If you haven't read the blog on this topic just yet, you can find it here:

UshaWarrior

asked in Questions & Conversations

Open next tab with the process flow

Hi Usha,Database wise I would advise to include the employee_detail_id column in the PK of personal_detail in general. Unless a personal_detail can also exist outside the context of the employee_detail record, then that is not an option.I do believe your process flow looks okay though. The input/output parameters you have provided should not be necessary, when you add a new row the GUI should automatically ‘jump’ to the newly added record and then activate the detail in the context of that record. So you might want to try removing these input/output parameters from the process actions and see if that helps.@Usha : Just to be sure, did you refresh your model/rebooted your application after editing the process flow and then tried again? Because this is required after you modify a process flow, since the GUI needs to reload the model's objects 😄

UshaWarrior

asked in Questions & Conversations

Open next tab with the process flow

Hello Usha,Your process flow doesn't work because the GUI does not know what you're trying to navigate to, since the only two process actions in your process flow are the Add rows.Try adding an additional process action between Add row employee_detail and Add row personal_detail called Activate detail. This requires you to specify which detail tab you want to navigate to and which reference you're using to get there, which in this case would be your reference between employee_detail and personal_detail.Hope this helps! 😄

Tejo van de BorCaptain

asked in Questions & Conversations

Use generated columns in default sort

Hey Tejo,While it is true that any generated column cannot manually be included in the columns used for sorting, it is theoretically possible to modify the dynamic control procedure to include these columns in the sorting order of the table, depending on how this functionality was implemented in your project. Unfortunately this is something that I cannot determine based on your post alone. If this is also not an option you can considering adding a hidden expression field to the table that selects the trace value and use that for sorting instead.Hope this helps!

FreddyThinkwise Local Partner Brasil

Limit auto refresh to subject only without referencesOpen

Hey Freddy,I'm pretty sure no option exists for this yet. You can only disable the auto refresh on the table itself, or on the tables that are details of another table. However, if the main table is refreshed, all details that are visible in the GUI will be refreshed as well.Maybe it's an option to not show the detail with the drawing immediately, but only after the user actually selects the tab page? This would be similar to the Columns tab page within Tables or Prefilters within Subjects, for example.Otherwise you can create an idea for this and we can look into implementing this in the future 😄

FreddyThinkwise Local Partner Brasil

Detect the use of mass import/update through GUI in flow.Closed

Hey Freddy,As far as I know there is no easy fix for this.Perhaps you could consider moving the functionality from the trigger to a task, which could then be scheduled? By scheduling it, the automatic calculation can then be executed periodically instead of every time a record is inserted, which would fix the problem. The only downside being that the calculation is not executed immediately, but might be slightly delayed.

sujitSidekick

asked in Questions & Conversations

Can we Use Where condition/clause inside an Expression for a particular Column of a Table, If Yes Please Let me know with example?

My apologies, I accidentally marked Erwin's answer as the best answer, thus solving the topic 😓. @sujit : Feel free to ignore this and continue the discussion if Erwin's answer is not sufficient to solve your question !

MaartenVanguard

asked in Questions & Conversations

tsf_send_message shows the default message after the custom message

@Maarten : If you are editing in grid and that field is the last to fill in, then using TAB to leave the last field will automatically trigger the row to be saved as well as triggering the default. Not the most fancy of solutions, but maybe you could swap the last column with the second last column?

MaartenVanguard

asked in Questions & Conversations

tsf_send_message shows the default message after the custom message

Hey Maarten,It looks like an attempt has been made to save the record with one or more mandatory fields being empty. In your second screenshot it looks like the default has emptied the value of ‘Besteld’.I expect that this is what is causing the second message to pop up, because this is a default GUI message that alerts you to mandatory values not being present.There are some options possible but I would personally recommend using a combination of a default and a layout. Use the default to throw the message, use the layout to prevent the user from saving the record if the provided value does not comply to the present requirements.Hope this helps 😄

ElenaTodirenchiVanguard

asked in Questions & Conversations

Look-up task parameter

Hello Elena,Within the task menu a tab page exists that allows you to set up the task parameter look up values called Task look-ups. If you use the + icon just below Settings it allows you to select the table that you want to base the look-up and which specific columns are required. Within the form you can then detail how you want the look-up to respond, such as a combo as you’ve mentioned. Hopefully this helps. If not, feel free to inquire further ! 😄

Marvin AlibahadoerRookie

asked in Questions & Conversations

hide task button on form only

Hi Marvin,As far as I know this isn't possible (if someone else thinks otherwise, please correct me 😅). You could raise an idea for this to see if more people would like to have this feature. Perhaps we can then implement it in the future!

a.schoonderbeekApprentice

asked in Questions & Conversations

Create report with dynamic file name

Hello,It should be possible to use the report properties for this. The property you'd want to use for your example is the Export path property. Try the following steps:Set up an additional report parameter with any name you want. Select the Export path option in the Property field of the report parameter. Create a default, or update an existing default if one exists by including the new parameter and setting this with the name and the extension that you want to provide the file with.If the report is set up with a print preview as the default report action, this new parameter will be hidden in the report pop-up. However in the case of an export to PDF an additional parameter will show up that presents the file name that it will receive when exported.More information can be found here: https://docs.thinkwisesoftware.com/docs/sf/reports#report-parameters Hopefully this helps! 😄

1
2
3
4

Page 3 / 4

Badges

Robert Wijn 2has earned the badge Adapter
Guido Bijlhas earned the badge Adapter
Dave Bieleveld Starcodehas earned the badge Critical Thinker
Theo Neeskenshas earned the badge Critical Thinker
Niels Koophas 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 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