Questions & Conversations

Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community

  • 1,919 Topics
  • 6,652 Replies

1919 Topics

R
Apprentice
RonyApprentice
asked in Questions & Conversations

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

4
R
Apprentice
3 years ago
A
Captain
Andre te RaaCaptain
asked in Questions & Conversations

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]

2
Anne Buit
Community Manager
3 years ago
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations

Calendar Scheduler

We have to create an event schedular in which we get dates entries from database. How do we create event schedular in software ?

19
A
Vanguard
3 years ago
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations

Screen Type

We have to create detailed grid so how can we bind multiple values in that ?

14
Mark Jongeling
Administrator
3 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
asked in Questions & Conversations

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]

8
Mark Jongeling
Administrator
3 years ago
Eric Franken
Sidekick
Eric FrankenSidekick
asked in Questions & Conversations

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

6
T
Moderator
3 years ago
E
Moderator
Erwin EkkelModerator
asked in Questions & Conversations

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?

3
E
Moderator
3 years ago
John Sangers
Apprentice
John SangersApprentice
asked in Questions & Conversations

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

4
John Sangers
Apprentice
3 years ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

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?

4
Robert Jan de Nie
Thinkwise blogger
3 years ago
Hugo Nienhuis
Hero
Hugo NienhuisHero
asked in Questions & Conversations

Error: Invalid object name 'project_vrs'.

I created a new project, generated it, executed it. I want to start the application but keep getting this error: Invalid object name 'project_vrs'. I am using the SF, not IAM. Help is appreciated, since I have no clue...

5
Hugo Nienhuis
Hero
3 years ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

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?

1
Anne Buit
Community Manager
3 years ago
poonam
Moderator
poonamModerator
asked in Questions & Conversations

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

3
poonam
Moderator
3 years ago
R
Hero
RolandHero
asked in Questions & Conversations

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?

8
R
Hero
3 years ago
Hugo Nienhuis
Hero
Hugo NienhuisHero
asked in Questions & Conversations

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?

11
Hugo Nienhuis
Hero
3 years ago
Harm Horstman
Hero
Harm HorstmanHero
asked in Questions & Conversations

'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]

4
V
Moderator
3 years ago
Harm Horstman
Hero
Harm HorstmanHero
asked in Questions & Conversations

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?

6
Harm Horstman
Hero
3 years ago
Harm Horstman
Hero
Harm HorstmanHero
asked in Questions & Conversations

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]

1
Erik Brink
Moderator
3 years ago
Eric Franken
Sidekick
Eric FrankenSidekick
asked in Questions & Conversations

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.

1
Jasper
Administrator
3 years ago
Harm Horstman
Hero
Harm HorstmanHero
asked in Questions & Conversations

Fields locked in combination with columns groups in grids, possible?

The grid property 'Fields Locked' seems to be ignored in case column groups exist in a grid. Is this a bug or desired behavior?

2
Harm Horstman
Hero
3 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
asked in Questions & Conversations

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?

1
Erik Brink
Moderator
4 years ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

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?

4
Tom van Druten
Warrior
4 years ago
Raj Rozendaal
Sidekick
Raj RozendaalSidekick
asked in Questions & Conversations

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?

8
Erik Brink
Moderator
4 years ago
G
Vanguard
gariensVanguard
asked in Questions & Conversations

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]

2
G
Vanguard
4 years ago
R
Hero
RolandHero
asked in Questions & Conversations

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?

2
R
Hero
4 years ago
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
asked in Questions & Conversations

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.

2
Arjan Sollie
Thinkwise blogger
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings