Questions & Conversations

Goal Sometime you need to extract only the file name (or maybe extention) from a file path. Solution declare @file_path varchar(500) = '\\server_name\folder_name\folder_name_2\file_1.txt';select right(@file_path, charindex(char(92), reverse(@file_path)) - 1)  

First off: I'm hoping it's OK that questions are asked about Universal, especially since it is an essential part of our current development. We've set all our project versions to Inactive (except the current branch), but nonetheless all our project versions show up in the left bar of Universal. Our current project has a larger number of Inactive project versions, so the list gets very long.

Hi,   What options are there for triggering alert for the end users, perhaps based on groups?  I have an app with several user groups, and I want them to have two things;  an in-app overview page of all items due. (for example, invoice that need to be paid, or orders that need to be closed).  I want them to receive an email every morning at 0700 with all these items. I can’t find anything in SF of the documentation.  I thought of making an Table Variant and filter on the date field. (if invoice_due_date = tomorrow..) but I wonder if this is the best.    Any thoughts on this?    Kind regards, Alex     

I personally like the group label option for a grid, however when you start a group label and there are hidden columns the last visible column never is included in the group. The only way to solve this is to unhide all columns, and hide them in the Grid-layout and make sure they are not within a grid-group.  Would be great if this problem could be solved. 

Is it fair to say that the @cursor_to_col_id parameter in a default control procedure is not working in Universal?

Can processes be executed in Universal? It seems not to work at this time.

We're currently testing our project in Universal. We've seen that tasks from the menu work in the current interface, but are not starting from Universal. When we click them we get the following error:  

I have nothing against drags, but drag rows are not my thing. Is it already possible to disable this on a per-user basis in the runtime configuration, or UP? If so, I must have overlooked it in the documentation. Otherwise I would applaud exposing this feature in an upcoming SF release!   -edit- For me it would suffice to be able to disable the behaviour of default drag/drop; just tick it in the context menu in the same way as I have to do for ‘editable grid' to enable it.

Currently we're testing our application on the universal. The issue we're having is that the themes we apply in the SF aren’t shown there.   We’re using the RC2.1.0 GUI version with platform version 2020.1   Note: the themes are applied if we use the web gui.

In a resource scheduler (extender) I want to delete an existing appointment, see image below (red box). When I use the standard functionality (DEL) the selected resource is deleted, but not the appointment. Does anyone know how to delete an appointment in the extender (resource scheduler)?

We like to show our own Application-/Company name as title instead of 'Thinkwise Software Factory’, before login. How can this be done?      

  Is it possible to exclude columns when exporting data? I already marked these columns as Hidden but you can still select them if you want.    Example for excluding Hidden fields  The order seems to be taken from the order in Subjects > Components > Grid. I know that you can modify the column sequence before executing the export when you choose for the option "Advanced option” and drag and drop the chosen field. But I want a default ordering of columns for export deviating from the order in the grid.   How to modify the "Standard order” 

In a resource scheduler (extender) I would like to display an image in the grid of the resource to make it even more visually clear. I have tried multiple file formats (.bmp, .jpeg, .png, .jfif), but as in the image below (red box) only the file name is shown (the images are well displayed in a screen type grid or form). Does anyone know if this is possible in the extender (resource scheduler) and how this can be accomplished?

How can this feature be swiched on? Currently this table remains empty.

When I switch between data sets, or data values in the Software Factory (2020.1.16) I notice this is sometimes very slow (approx. 10 seconds), depending on the amount of columns in the table. The debugger screen doesn't show any heavy query's (all below < 10ms). I do notice a high CPU usage on the SF exe. Is there any way to speed this up?

In a resource scheduler (extender) you can display a tooltip on an appointment, see image below (red box). The tooltip is called by the extender from a column with a hard copy of, in my example, all fields of the appoinment. Since this field changes with every change of an appointment, the default does not seem like a good place to me. It seems to me that you want to generate this field once just before you save the data. Does anyone know the right place for this action?

Anyone knows why you cannot return messages to the GUI panel using a cursor? I have a procedure that processes stock counts, and when there is an issue these are determined and returned as messages to the GUI panel using a cursor.  The problem is I see the warnings in the debug screen but not the actual panel in de the GUI. Bug?    

Sorry for not finding this topic if it has been answered before, search left me empty-handed. To relax restrictions on a variant as compared to the subject, I want to replace the occurrences of the subject by a new variant ‘default’ relax restrictions on the subject create the new variant 'unconfirmed_order_line’ (as an example) What is the preferred method of screening my model for occurrences of the current base subject, to replace links where it is targeted with the new ‘default’ variant? The problem I face is that references at data model level do not allow me to define user interface properties such as detail variant, and user interface screens only expose links to details, not to parents. Targeted searches using menus/reachable objects only allow shortest path, not all paths to a subject (and in my case, find the path via the default menu, not even the main detail occurrence because that takes another node and is not the shortest path. Is there a lazy way to reach my goal

Hi, I have a table with several fields. One of them being a number that is sometimes generated, sometimes entered manually.  So next to this field I would like to have a button (with some code behind it..) that says ‘generate number’. However, I can’t find it or am looking in the wrong direction.  Things tried; made a combo-field. When selected manual; it does nothing. When selected ‘generate’ it generates the number. (works OK-ish, but wrong design) Made a Task with a button, but this appears in the top left corner (next to Print icon). Will probably work, but wrong location   Anyone can point me in the right direction on this?   Much appreciated!    Alex    

I want to show a text field with 4 or 5 lines high, but without the Magnifier next to it. There is no relation on this field.  Where can I turn this off? Or, how can I make a text field larger without using the domain control type 'Multiline’   Much appreciated!    Alex 

I was wondering, when and why would you call tsf_send_assertion_msg 1? Because when you omit it, nothing happens, which is ok I think. When using an assertion query I'd probably only would use the 0 variant, to indicate an error. https://docs.thinkwisesoftware.com/docs/sf/unit_test.html#docsNav

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalSometimes you have a prefilter which you also would like to have on other tables in your application. For example, a user only has access to customers from a specific region. Now when he opens the outgoing invoices table, he should only see the outgoing invoices of the customers of that specific region. In fact, in every screen with some kind of customer data, you want to restrict the access to that data, based on that region.This solution automatically generates prefilters throughout the application.SolutionThis solution consists of code for Dynamic Model which generates prefilters based on a prefilter which is locked. With the tag AUTHORIZATION_PREFILTERS_NOT_INHERITED you can exclude prefilters, target tables or references from this mechanism.Example:Let's say you have the following code as prefilter on customer:exists (select 1 from region r where r.region_id = t1.r

I'm trying to verify if the Universal GUI is working in Azure. I’ve tested it first on a local IIS environment connected to the Azure databases, which works. The next step is moving Indicium + Universal GUI to Azure App Services. I’ve created an App Service for Indicium 2020.1.8, which works out of the box. The Universal GUI (RC1) needs some more attention: It's not possible to add mime types via the Azure Portal GUI, so you have to configure a web.config to ensure the config.json file can be read and the .woff font works. I've added the following web.config file in the root directory (not sure if the mime types are ok):  <configuration><system.webServer> <staticContent> <mimeMap fileExtension=".woff" mimeType="application/font-woff" /> <mimeMap fileExtension=".woff2" mimeType="application/x-font-woff2" /> <mimeMap fileExtension=".json" mimeType="application/json" /> </staticContent></system.webServer></configuration> Then I have

Hello, Not realizing that Universal doesn't support Process Flows yet, I created a Process Flow that sent an email to our customer service. Later I understood this was not supported, then I removed the Process Flow and wanted to handle it by SQL Server database mailer using "msdb.dbo.sp_send_dbmail". All I had to do was adjust the task, create SQL Server mail profile and add it in the Stored Procedure via Functionality. The rest of the parameters were already present like body, subject, recipients. I modified 2 tasks which now both give an exception within Universal. Via the Windows GUI/Web it works fine. One task gives the message [Unknown error], but mails. The other task gives the exception [Stage task commit failed. Error: validation_failed] and does not mail. - Application Pool identity has SA rights within the SQL Server instance Does anyone have any idea what might be the reason? Thanks in advance.

The documentation tells me the action bar contains buttons to add, copy, edit and delete rows, to refresh the data and, when applicable, to execute tasks   In this case, I only need the tasks. In the table variant, I disabled navigation, copy, filter, all those check boxes on the permissions tab. Is the above supposed to make any impression on the look and feel of Universal? The goal is to have four buttons for four different tasks available to quickly execute one or another action.