Questions & Conversations
Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community
- 1,919 Topics
- 6,652 Replies
Resource Scheduler & Extender
This is going to be a lengthy post about the Resource Scheduler extender. Instead of making a couple of threads, I’ve bundled all questions we have regarding the resource scheduler into one. [h3][b]Extender properties[/b][/h3] Let’s start with the extender properties of the resource scheduler. In addition to the extensive amount of properties you’re presented with, the description of said properties leaves a lot to be desired. Most of the time there’s little to nothing added to make clear what a certain property really does or how to properly set up one. For example: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/9f645efa-a3f3-4f1f-a866-6a58824adeff.jpg[/img] As you can see the value type of the ‘Days’ property is Int. But if I, let’s say, enter 5 as a value and refresh my model I get the following warning. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/8a8acf96-7e1f-46e1-9e58-9ff821e3cef5.jpg[/img] That leaves me with a lot of questions as
How to select items in a tree with a checkbox?
In the Software Factory it is possible to select items in a tree view (see below). As far as I know, you can define a display column and an image, but not a column for selection. If I use a column 'selected' as in the example below, it will not be shown. Is this a custom screen? How can we achieve this? It should work the same. If I select the 'parent', all 'childs' should be selected. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/2d494bf0-2ac0-4425-b4f6-00a9fb1819eb.png[/img]
Ability to order the fields in 'Update'
EDIT: [b]The order of the fields in the can be changed in Subjects-->Components-->Form.[/b] As commented by Henri Timmermans Topic can be closed/changed to question. Then his answer as Best Answer. ---Original Currently I don't think it's possible to change the order of the field in the 'Update' screen. It is possible that fields are ordered almost randomly. It doesn't use the List order so for an user it's very confusing. Here an example of a confusing order. I would like to be able to order this Update screen or at least it to be equal to the List. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/9362e47a-717e-458a-8936-b8b25414bafd.jpg[/img]
Parameter papersource when using the reporting service
When printing a report using the reporting service there's a parameter for the number of copies to print. I'm missing a parameter to select the paper source (tray). I want to print some document on blanc paper and others on letterhead paper on the same printer. Is there a way to do this? Thanks Eric
Information panel reload makes all tasks disappear from the tasks bar
When you have an information panel on your screen the reload of this information panel makes all tasks disappear from the tasks/reports bar, probably due to the row loosing it's focus. Is there a way to prevent this from happening without creating a process flow to retain the focus?
Error message using FILESTREAM to save documents
I am trying to use FILESTREAM for saving documents in the database. I have a table containing these columns: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/21ec255c-73a0-4ce0-9a42-68589a664298.jpg[/img] The domains are defined as folows: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/3e914ab9-c492-4168-9108-c680e175eebf.jpg[/img] When I insert a document using T-SQL in SQL Mangement Studio in the GUI I see the documents as expected and can also open them using the lookup button. When I try to upload a new document I get the folowing error message: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/b33cf9da-9772-49a1-86b5-f4d5374d85f9.jpg[/img] This makes sense because the filestream_id is inserted with a null value, running the same command in SQL management studio without the field filestream_id and the null value works because the field has a default value (newsequentialid()). What should I change to make the GUI surpress the f
Bad performance on inserting. 2nd insert is way faster
I have a problem with performance. The thing is there is a huge insert trigger which does all kinds of things when inserting an order. The insert trigger also inserts in a lot of other tables, causing a lot of insert triggers to go off. The strange thing is. The first time I insert something, the performance is just awful. The 2nd time I insert in the table, the performance is way better. I bet this has something to do with the SQL server caching stuff. An example is inserting an order based on a huge calculation took 13 seconds. The second time i did this it only took 2.8 seconds. We know this big 'trigger party' is a problem, but this is the way it works; the 3 seconds is acceptable, but 13 is not! I'd love to know if there's a way to see what is increasing this performance this much (like a cache) and is there a way to always achieve this? Like force caching stuff? Who can help me with this issue?
Combined filter searching like '%string with spaces%'
Right now you can make cool lookups which works with the 'Suggestion contains" control working as follow: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/a9e1abe6-5c9d-43a4-acca-a83cdfdaf763.jpg[/img] The thing I'm looking for right now is to achieve the same thing in the combined filter of that table, if you hit the lookup, but when i look search for "4022 635 9" in the combined filter, it will search as: [code]where (((((t1.[artikel_en_oms] like '%4022%'))) and (((t1.[artikel_en_oms] like '%635%'))) and (((t1.[artikel_en_oms] like '%9%'))))) [/code] I want to achieve: [code]where (((((t1.[artikel_en_oms] like '%4022 635 9%'))) [/code] Changing the filter condition in subjects -> data -> filter does not work. Is there a way to achieve this?
Any ideas/tricks to running tasks from different parts of the same screen?
Hi! I have a screen, and it looks like this one below. As you see, I have 2 taskbars on the same screen. [b]What I'm attempting to do here is to activate a detail tab (via a processflow) by allowing a user to click on a huge button on the bottom right of the screen, while keeping most of the tasks on the left side of the screen .[/b] [b][/b] My first attempt to solve this was via a dummy task which would direct the user to the detail tab. That's where I found myself building this screentype, trying to place 9 out of 10 of my table tasks on the left and one huge one on the bottom right. If you have tried this before, you know that it doesn't work that way and now [b]all[/b] of the 10 table tasks are in both places :sweat_smile: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/d7662395-887b-406c-99f5-928fe6c8bd80.png[/img] A couple of solutions I've already tried to achieve my separated tasks objective: 1 . Adding the task as a detail tile. This doesn't work
Control procedure parameter - default value
First I created a control procedure with a parameter. Then I filled in a default value for the parameter in the task parameter tab. However the produced SQL code that actually creates the procedure does not set this default value on the database. Is this the correct behavior? The generated code in the software factory includes this part: [code]create procedure task_procedure_name ( @from_date date ) as begin [/code] However I would expect something like this: [code]create procedure task_procedure_name ( @from_date date = '1970-01-01' ) as begin [/code] My goal is to create a procedure which includes a parameter with a default value which I can override if necessary when calling the procedure using the execute command. Can this be accomplished?
http connector status code -1
I am trying to use the http-connector to connect to a website/webshop (http://webshop.coffeefresh.nl). The http connector is returning error code -1. When I do the same request to http://bol.com for instance I receive status code 0 / http 200 OK. I can reach the URL without any problems using a browser or insomnia. Just not with the http connector. What can be the cause of the -1 error code, or, where do I look for the problem?
'proc_application_startup' generated an error while deriving the parameters
What causes this error message during startup? [b][i]Stored procedure 'proc_application_startup' generated an error while deriving the parameters.[/i][/b] [b][i]Information:[/i][/b] [b][i]Parameter 0 - project_id (project_id):[/i][/b] [b][i]An SqlParameter with ParameterName '@project_id' is not contained by this SqlParameterCollection.[/i][/b] [b][i]Parameter 1 - message (message):[/i][/b] [b][i]An SqlParameter with ParameterName '@message' is not contained by this SqlParameterCollection.[/i][/b]
How to use extended property 'ShowLoginInfo'
I tried to not show database details to end users in the production environment by adding the extended property 'ShowLoginInfo' with a value 'No' to a Runtime Configuration called 'PROD'. In the INI file the setting 'Configuration' with value 'PROD' was also added. Finally it did not work in the Windows GUI. Any ideas, how to solve this?
Run WebGUI over SF (2019.1)
For developent purposes I like to run the WebGUI over SF. Is it still possible in SF version 2019.1? Are any additional settings needed, compared to 2018.3? Following message appears: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/741ba373-8a3c-40f0-97c7-a81f0bd7aab9.png[/img]
Export to xlsx in reporting service (crystal report)
We created a report in Crystal Reports which we want to export to xlsx format and not to xls format. Is this possible? We want to do this because after generating several Excel files using the Thinkwise reporting Service we want to combine them as separate worksheets in one excel file. The component we use for this needs to have xlsx and not xls.
List pages in the Windows GUI
I know that with the Web GUI we have pages in Lists, capping the amount of rows you see to a certain amount. Now I'm trying to do that too in the Windows GUI for the project I'm working on because we sometimes have a huge list of maybe above 6000 rows. In the Software Factory we can set a limit to how many rows are displayed, and even the page sizes. But it looks like the page size doesn't work for the Windows GUI. How can I introduce list pages in the Windows GUI or is this not possible and can we only set a maximum?
Rename Template task failed because of related 'program object item parameters'
We're still on 2018.2. When i rename a Template, which has been assigned AND has parameters in the assignment, the rename task fails, because it has related parameters. Apparently the task is not working with these. Is this fixed yet in a later version of the SF?
Automatically download files in a task
We generate XML files in our system. These files currently can be approached by using a task. We have chosen for a task because we want to log all persons approaching the XML. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/57d23ca9-0754-412b-8a16-d8da771659b0.png[/img] In this task we see the file name and the option to download this file. After pressing the green download button we have to exit the task by pressing 'uitvoeren'. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/20948a7d-4022-4c27-9fa0-5f3558d34fcf.png[/img] Is it possible to start the downloading of the document the path is referring to automatically instead of pressing the green download button after we opened the task?
conditions of buttons in a remote folder control
What are the conditions under which the buttons in the remote folder control are available? In my case I have the exact same rights in two different folders, however in one of two folders the remote folder control will let me use the buttons and in one folder it doesn't. I can use the functionality if I first move the folder with the move folder connector in a process flow and then open the location using the remote folder control. Still, the rights are completely the same. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/f8d67711-cbd8-4e26-ab1c-ecad44a6ee3e.png[/img]
Invalid value 'POST' for http method
For a process flow which processes both POST and PUT api calls it is necessary to use a variable for the HTTP method. However the HTTP connector produces this error: [quote]The process action with id 'http_connector' was provided with the invalid value 'POST' for its 'Http method' parameter.[/quote] What are the correct values for PUT and POST in case a variable is used?
Configure task, report and prefilter bars
In our current Graphical User Interface it is not possible to configure task, report and prefilter bars. Meaning that either all objects within the bar are being displayed or non at all. I have been told, that there is an extender, which allow you to configure these bars. I was wondering if the option to configure bars will be introduced within the Universal Graphical User Interface? Instead of having to set up an extender outside the Software Factory.
Login to the Thinkwise Software Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.