Questions & Conversations

What is the Validation Object Type:SF Validation Object typeFor the Subject → Default → Sort and Filter? I can’t seem to figure out where to find more informatie on this (if there is any). I’d also like to know what the duplicate values mean in the Validation Object Type list.rgds Ricky

Instead of showing the database time, we want the GUI to show the time ‘at timezone’. Is there an easy way to handle this in the Software Factory? Maybe the GUI could handle the datetime at timezone, if we could set the timezone for the database and the timezone for the application (runtime configuration?).     

For example, consider a table purchase_order with a lookup to an address table.The link is made to the PK field of the address table.In the purchase order screen, I want to be able to show fields of the address as separate fields.I know it is possible to work with expression fields, but multiple lookup queries to the same table is not desirable.Concatenate address fields is also not what I want. I really want to be able to display the address fields as separate (read-only) fields in the purchase order table.Ideally, the main table 'purchase_order' will get t1 as an alias and the address table t2 as an alias, etc ..Is there a trick to get this done yet?  

I forgot how to change the application title which is shown during startup, and cannot find the solution in the documentation.  Can anyone tell me? 

I have a table task that is part of an process flow. This task must be hidden because only the process flow must be able to execute this task. When i uncheck the ‘Show task’ setting for the table task the process flow stops working.Is there a good reason why this behaves like this?

Hi,I’ve got a question about a validation message.Since the upgrade to version 2020.1 a validation message appeared which I don’t know how to interpret or solve. The validation says: ‘The cardinality of the look-up is invalid’ It has to do with the appearance of new columns in the look-up chain. I have a table called object_part_service_task, which I want to limit to entries within the table object_component_service_task, so I created a look-up with the key containing system_company_id, object_component_id and service_task_id. The column service_task_id is the look-up column. The table object_component_service_task is limited to entries within the table object_class_service_task and has a look-up relationship with the key: system_company_id, object_type_id, object_class_group_id, object_class_id and service_task_id. This last table has a relationship with the table service_task, which is the table that contains all the service_tasks’ The relationship here is with system_company_id and

Is there a way to assign a zoom window to a double click on a field in a grid?  I have a list of orders and invoices, and I would like to have a zoom window or new tab opened when they double-click on the invoice-number for example. To see the invoice, details and costs.  As an alternative to a list of detail-tabs. 

Hey all,I have a view with 3 prefilters. Is it possible to create a layout proc or ctx proc to toggle the filters on/off?  [1][2][3]If prefilter [1] is active, I want [2] and [3] to be hidden. I do this with ctx procs for print buttons and tasks, but for prefilters I can't get it running. Overlooking something or is this not possible?  Thanks! 

Hello there, I have created a subroutine/stored procedure to have the AD groups automatically synchronized using an SQL Agent job. Initially this job starts up fine (every evening at 20:00), but after some time the job fails with the message below: Executed as user: {service account}. <msg id="not_authorized_usr_admin"></msg> [SQLSTATE 42000] (Error 50000).  The step failed. If I then manually kick off the stored procedure, the job will function correctly again for some time. Below the stored procedure which is used: declare sync_ad_groups cursor fast_forward for select usr_grp_id, active_directory_grp_name from iam.dbo.usr_grp where 1 = 1 and usr_grp_type = 1 open sync_ad_groups fetch next from sync_ad_groups into @usr_grp_id, @active_directory_grp_name while @@fetch_status <> -1 begin if @@fetch_status <> -2 begin exec iam.dbo.task_import_active_directory_grp @usr_grp_id =

Are process flows executed in mobile? I've created a simple proces flow that would help mobile users a lot when filling in a checklist… After update progress to the next row… That's all.But it seams the processflow isn't callled at all (in the mobile viewer; I'm still in the test fase).Am I missing something here or are process flows not executed in mobile?

It seems impossible to import rows to the column defintion in TSF because of mandatory fields.    

I have the web gui on an Azure App Service. But I notice the “Logs” folder isn't created, and if it exists the files aren't placed there. I use this ini settings: Server = server.database.windows.netDatabase = iam-databaseRuntimeConfiguration = RDBMS = SQLSERVERMetasource = IAMLanguage = engAuthentication = rdbmsExecutionmode = developerCSVLogging = TrueLogToFile = Yes When I copy the GUI folder with the same ini to a local IIS application it does create the folder and a Debug.log on start-up. Do I have to do a bit more on Azure, or am I looking at a bug?

Is it possible in the control 'progress bar’, to don't show the 0% if the value of the column is NULL? I would like to show the progress bar, however when the value is NULL, there should not be a progress bar. When the value 0-100 is used, it should be shown.

This topic is kind of a follow up on this topic:https://community.thinkwisesoftware.com/development-13/open-a-screen-first-time-and-ignore-it-the-next-time-1251 Because our application is a bit overwhelming the first time you start it, or the first time you’ll use features / subjects in the application, we want to help the user. We’ve found a tool called “Inline manual”. A video about what it does can be seen here: https://inlinemanual.com/product-demo/. In short you can “walkthrough” a user, show tooltips to help the user etcetera. Easily explain some actions step by step what to do. Simple things how the look-ups work, how you can add records etcetera. First time users really need some help, and that could be perfectly done by such tool. This could be an enormous improvement in “User onboarding”. Please note we only use the Web GUI, and are tempting to use the universal GUI as soon as it is feature complete for us. As we’ve tried to see if it’s interesting for us we’ve encountere

In IAM it is possible to configure a task to be executed when starting the application. I've tested this and it works fine. It is mandatory to also enter a name for the Startobject, but whatever is entered here, it's all excepted… But I’m thinking of a way to not always execute the task, depending on circumstances or other settings.. A way to get this done might be creating a processflow instead of a task to get this done… This is also an option in the combobox, but I'm not able to select a processflow here… So, what is the use of selecting Proces here if it is not a procesflow in the application?? Or is Proces something else than a processflow in this case?  

I’ve just upgraded to SF 2020.2 and noticed I cannot download / edit the reports:If I click the button (in red) and save the file, it results in a empty file. I did use the task ‘Upload images and reports to database’ according to the manual.I’ve checked the table ‘report’. The column ‘file_spec_data’ does contain some binary data I see, but when downloading it remains empty. How can I edit DevExpress reports?

When pressing enter while adding/editting data in a list, you will automatically go to the next editable field.  However, when pressing enter while editing the last record in the list, you will go to the next editable field in the last line. Our user thinks that is confusing behaviour. The user thinks he is making a mistake and his changes aren't saved.Is there an alternative for this?

We’ve created a system flow that sends e-mails via a ‘queue’ table. We capture the SMTP status code in a process variabele and act according to the response. The SMTP status code will be updated in the queue table.   When testing we try to set-up a recipient with an incorrect e-mail address. The response we expect is status code ‘-4’ (Unsuccessful (one or more addressees could not be reached)) but the result is ‘0’ (Succeeded)   Our task then marks the e-mail as ‘sent’ because SMTP status code 0 is returned. However Outlook itself response with a ‘Delivery has failed’.   Why does the SMTP connector return 0 and not -4?

In the Software Factory (2020.1) I cannot remove a Platform under Project overview > Platforms. It keeps referring to ‘Excluded menus’. But where can I find ‘Excluded menus’? I cannot find it in the Full model and have no clue where to look. (What is an Excluded menu actually?) The DELETE statement conflicted with the REFERENCE constraint "ref_platform_platform_excluded_menu". The conflict occurred in database "SOFTWARE_FACTORY", table "dbo.platform_excluded_menu".  

Hi all, I have a finance overview grid, with three group label. General Cost Revenue Is it possible to have the group label border extend through the grid?  This would greatly improve on the usability.   

Hi,  Is there any solution for the following problem. I have a lot of fields that need to be edited (addresses, money, etc) and that needs be printed. This works quite well, but the client would love to have a wysiwyg-sort of editor.  So, ideally I want to have my text-fields on the left, and a live pdf preview on the right.   Any chance this can be done? Much appreciated!    

Hi,  I’ve a scenario with a sales order with a sender company with related location and receiver company with related location. What is the best approach to make lookups for the both locations? For sender location, it should filter the available locations on the sender company and for the receiver location, it should filter on the receiver company. Both sender and receiver are retrieved from company table and location from the related company_location table. Can I use same lookup or should I create different ones?  I have this scenario for more tables in the application. Thanks in advance.   HJ van Dalfsen

Because of an earlier issue (https://community.thinkwisesoftware.com/deployment-12/what-is-causing-the-clear-panel-message-in-the-panel-informatie-1030), I installed the latest web GUI (2020.1.14). Unfortunately that caused another problem. I am getting the following error: Deze taak kon niet worden uitgevoerd omdat er een component mist. Raadpleeg uw systeembeheerder voor advies. Well, I could ask my system administrator, but I don't think he will be able to help me with this, so I am asking you guys for help. The situation is that there are a few tasks that are being executed managed by a process flow. The first one is a SP and the second one is a task that executes TSFReportMailer. I think the problem is with the second task. Is this a known bug? What can we do about it?

When I create a Deployment Package I notice a difference between the upgrade methods “Smart” and “Full”, also described here: https://docs.thinkwisesoftware.com/docs/sf/creation.html#3-generate-source-code. We often have small changes, so using the upgrade method ‘smart’ is preferred, because a ‘full’ update is quite heavy and can take a while. But when choosing for ‘smart’, the script ‘020_Upgrade.sql’ isn't (always) created. I have this situation for example when I only change a query in a view (no model changes). Why isn't there a 020_Upgrade.sql containing an update of sf_product_info table generated when having only some minor changes?

When the user opens the (desktop) application for the first time, our application might be a bit overwhelming. That's why we want some 'tutorial' or landing page where the software is explained. This could be a web page with some videos embedded in it. This is a bit like downloading a new app on your phone where the important parts are highlighted in a 'scroller view' (each dot is a page) or there is a highlight on certain button or action. The user should keep seeing this window, until he clicks somewhere saying "Don't show again". I did read this post that looks a bit similar: https://community.thinkwisesoftware.com/development-13/how-do-i-set-a-table-as-a-start-object-or-landing-page-when-ever-a-user-logs-in-889 By following the steps described on the link above we could add a menu item with 'first start' and set that as a start object for each user. Problem is that it will start each time, where it's quite difficult for a beginner user to disable this the next time: You have to