Questions & Conversations

Using dbo.tsf_user() in a default value expression gives errors during execution of the source code.     Cannot DROP FUNCTION 'tsf_user' because it is being referenced by object 'DF_prd_insert_user'./* Drop function tsf_user first. */if exists (select 1 from sysobjects where name = 'tsf_user' and (type = 'FN' or type = 'TF' or type = 'IF')) drop function tsf_user Any workaround ideas?

We are busy developing a Thinkwise application in Universal GUI. The users are Windows Users, which are created in Active Directory. The password policy makes passwords strong, meaning that users must use letters, numbers, and special characters.Entering the username and strong password on a mobile device is difficult because of the emulated keyboard.Does anyone have experience with a way in which users can (more) easily log in to the Universal interface on a mobile device?We are already testing with barcodes and QR codes, and for the username this could possibly be a workable solution. But having passwords printed in code form available is undesirable from a security point of view.We'd love to hear your experiences and tips!

Is there a screen type in which we can realize the following?The user wants to be able to scroll from left to right in the overview.

Hey guys, I noticed that there is a slight difference in a way the reports display in the preview (web).Slight difference such as lines not being shown and fonts not being bold, etc.In the preview screen when i export as pdf the report is being shown correctly.Is there a way to correct this or does this have to do with the fact that the previewer in web is different than the local previewer? Regards

In one of our TW applications we have a large stock table and we created prefilters to filter for specific warehouses. We would like to use roles to assign which prefilters are visible and used.So pickers form warehouse A do not see the warehouse B entries and vice versa. And some people need to be able to see all..We couldn't find a way to do it.

 I would like to develop something similar (with the SF) as the Thinkwise Platform badges so we can award badges to our colleagues.Everyone wants to badges  - What would be the best datamodel design for this?  New badges (icon) must be able to be created at all times; An employee can earn zero or more badges; A badge can be assigned to zero or more colleagues;   ​​​​​​- Is there already a way to realize a second layer over the employee image with a general badge based on the condition an employee have one or more badges?    - What is technically and performance-wise the best way of presenting the badges (all images stored in the database) in the context of an employee.   

Hi, I want to dynamically add images to the email body which will be sent bij dbmail.Because of more departments en several marks the logo’s added to the email body need to be added dynamically base on user en department.If now added a table with a link to the path, that works fine in the application but when sending it out the logo’s are empty, because of the pointer to the local path.For one html table cell for example <td><img src="G:\Thinkwise\logo1.png” I have stored the images in the database as well on department level, let’s say the field [department].logoI’ve created an email-template with the tekst [handtekening] When creating the email I replace the [handtekening] tekst with the complete email signature of the user.When I put the logo directly in my email template, the logo is embedded in the template and that works, but that is not dynamic. So the challenge is to add the code of the image stored in the [department].logo field (or the code of the image stored on the

I’ve maganged to setup the connection to the Exact Online API from postman.Now I try to setup the connection from the SF but we running into an invalid_request error as a result.I’ve used the same input variables and keys, so at the moment I’ve not a clue why this result is happening:      Has anybody in the community succesfully connected to the Exact Online API. 

How to set up an API connection using the OAuth 2.0 with Exact Online?This resource was a good starting point.I can’t find a way to use a valid “redirect URI” in the SF.Any suggestions? 

I like to work out a scenario of reading user data from an Office365 account. Like upcoming agenda events or outstanding tasks.Is there any step-by-step explanation available of a working example, using the Oauth 2.0 connector? 

When creating a deployment package of the customer's end application, the system keeps hanging on "Synchronize: refereence columns (i_sync_ref_col)". Does anyone have experience with this and/or a solution for it?(I also made a ticket in TCP with backups of the databases)

We have a report that is callable from different detail pages as well as from the master page. The names in the Saveas field differ from page to page. How are they composed?

Hi all,I currently have the following set-up, which is just not working great. It's slow, complex, and it needs a kick every day to get going. The current set-up. Task on 'origin’-table does an insert on the rpt_queue (table).  Thinkwise reporting service picks this up, generates the PDF and places this in an output-folder  NOTE: the .rdl file is not withing SF, but from a repo (so an outside party can create the rdl files!) Our home-made Service polls the output-folder. If a file is found, it is uploaded to our Azure File storage.  It's final location is given back to the rpt_queue and 'origin’ table, so the file_previewer can display the file. Upside = it's what I needDownside = it's slow and never works well What I now want to try is this; Create the PDF through a task (with the .rdl from the repo)  Save the directly to Azure file storage  Get the final uri from the file and show in the File PreviewerAnd - this all must be faster than ..say… 10 seconds max?  First of all, i'm not s

I’m getting a “Scheduled process flow requires user input” validation. I started the process flow with a task but I will schedule this flow.So I deleted the task from the process flow, and there are only decisions and http connectors left.But the validation still gives this message.We’re on 2021.2 with SF. What can I do?

I have started a new project in the SF 2021.3 and created a task. When I try to generate a control procedure I receive the following error: I am unable to find the cause of this error. Any help?

I often run into the issue that the project folder is set to a folder on the customers network which I cannot access from my dev environment.I can change it thru Full Model to a folder I can access but I noticed that when I do a sync to IAM the path in my SF overrides the path in IAM.I would love to see a way to set different path for DEV, ACC/TEST and PROD as I don't want my test data to interfere with production data and vice versa ;)Is there a way to do that? Currently I need to be very carefull that I do not forget to correct it in IAM after a new deploy.

When I switch from Work Week view to Full week view, I lose the time scale (see below). How could I prevent this? 

I’ve noticed some unique behaviour with the universal date picker.The datetime field shows the previous date after having input a date into the field. It does seem to store the correct value and even portrays the right value when not in edit mode.Here you can see I’ve selected the 10th of May, and it does seem to show the right value in the hover text. This is the same field after saving, portraying the right date. 

To be precise, I have other application which generates a script. This script I would like the Software Factory to run during the 'Execute source code' step of another application. How can I make this work? My idea is that the Software Factory reads from a certain file path, looking for the SQL file and then attaching it to the 'Execute source code' step, but if there's another/better way I would love to hear it. (It is not an option to generate the code inside the application where I would like the script to be run on)

Hi, is there currently any way to allow a user to upload multiple files or images at once?I have a customer asking for this but can't seem to find a way to accomplish it.I've seen this topic mentioned a couple times on this forum, but many answers are over a year old and non-definitive. Is anyone able to tell me what is currently possible in this regard?I'm curious about the possibilities in every GUI.Thanks in advance.

Perhaps my train of thought is off, so perhaps I need a completely different approach… but for now Hi,With the dynamic model i've written a script that creates a task 'delete_row’. I want this task to 'delete’ the row by updating the row column ‘is_deleted’ from 0 to 1. With a hidden prefilter I filter these deleted-values out. This preserves the records, and makes them easier to restore than a true deleted record from a sql system version table. I want to show this task 'Delete row’ on all tables, instead of the SF native delete button. So far, ok. However, I can't grasp on how to set the [table]_id parameter. Do I need to create X parameter, one per table? Or can this also be done dynamically? Something like @[table_id] instead of @account_idWith the Sf native delete button, a record is removed from the table, and only available in the history table. I have used this but these history views are not available in other ways currently. If you delete an 'account’ you cannot see this row

I am trying to connect to an outside API using the HTTP-connector. I need to call different procedures, using different content-types (application/json, multipart/form-date). I want to build the process variable ‘content’ within a template and feed it to the http-connector. This fails.When I select the content from a table-field with datatype nvarchar(4000) and multiline control it works fine. I can select the content from the column and feed it to the http connector. It also works when  I use a taskparameter to paste the content into the process variable.So far I figured out that it has something to do with the CR / linefeed. But when I simply remove all CR's, this still won't work. Since I need to compose the content from some static text and a few variables (pdf-data for example) I do need the template.Example of what I am trying to build (which works fine when using the task-parameter): Content-type:multipart/form-data;boundary=abcde12345Content:--abcde12345Content-Disposition: for

Hi, I have set up an Indicium and a Universal GUI. I want this to start directly against SF. I can login and run the model, but on all screens, in all projects I get no data and it says 'Unknown Error’. Why? And where can I debug this? I can't remember it well, but I have a feeling it did work last week for a day. I can't make sense from the indicium log… Are there any other logs to check on this?   

Hi,i setup a cube with 2 cube views, but i want to display it simultaneously in 2 separate charts.  Currently it’s visible in a single chart with a toggle button.

Hi,I’m hiding a fair set of columns in a subject through IAM and now I’m wondering 2 things:Can you help me understand why are the selected columns in the sql query not matched with the logic behind a subject?How can I achieve a matching column set query with only the visible columns and the possible logic behind the subject so this can hit the performance drastically (sometimes for the bad, but most for the good of it) rgds Ricky