Daniel Krüger (Cosmo Consult)

Hi Roman, comments: The query is passed as it is, -- and /**/ are part of it. Even so single line comments seldom cause problems, it happens. If you enable the diagnostic mode, you can search the trace for a line from your query and see the executed one. That's far easier than my previous app

Hi, @Radek I'm sorry too. After coming back from vacation there was just not enough time. If you still have the issue you could check the following: No match found for: Xxx Is probably for a choose field which value does not exist in your source or is not unique. @Maksymilian Congrats

I would be fine with an overview which WEBCON BPS versions support which compatibility level. Since SQL Server 2014 will be supported for one more year, I doubt that the default setting will be changed. After all not all customers use the latest version. Of course it would be nice, if the late

Hi Andree, I would either do it directly in Excel or add a check whenever an instance is saved/the save path is executed. The validate form action would be something like this: select case when (Select Count(*) from WFElements where WFD_DTYPEID = XYZ and WFD_ID CurrentInstanceId and W

Hi Damian, as Maksymilian already mentioned, as of some version WEBCON uses a dedicated database user without login 'bps_user'. It has has limited read permissions in the database. I have seen that this is only added to "new" installations not updates. Maybe your DEV server already existed a whil

There are reasons why established ERP systems don’t come with an app with few fields and two buttons. :)

Edit: Somehow I missed the answers…

Hi Roman, regarding the data source issue. If I get it right the error is from a cyclical action. In this case it's executed by the WEBCON Workflow service. Maybe it doesn't have permissions to read the data source? You could activate "Access to data in the context of system account", if everyo

Hi AndreeLi, it really depends on your use case which of the suggested alternatives you are using. A little more information: Subworkflows Here’s a more complex example which should point you in the right direction if the default options are not sufficient https://community.webcon.com/post

Hi Karol, thanks for the clarification. I have forgotten about the description. I have only a few fixed value list in use and neither needs a description. Best regards, Daniel

Hi Mario, it seems as it doesn't work. When defining a mapping, you can't select a data table but you can select a data row. This will return the first row, and as you noticed it doesn't work with a range formatted as a table. My best /stupid idea to circumvent this problem would be to pop

Hi Roman, the "Fixed values" are stored in the data source table itself in column WF_StaticValues. Choice fields don't require a GUID. A GUID is used by WEBCON to allow entering values which are not in the data source. In this case WEBCON will add a GUID itself. This would return the valu

Hi Iuis, the simplest option would be to use a Timeout, with operation mode "only action execution" and send the mail in the automation like it is displayed in the attached picture. This will work just fine, if the workflow itself doesn't to other steps during this time. Otherwise you would ne

Hi Martin, Maksymilians answer will work. We did something similar in the past but with a "normal" field not from an item list. Since the global action or path transition you are calling will generate a new version/execute actions you can clear the technical field in it. I'm wondering though

Hi Gerd, yes, the history table contains all path which have been used. In your case you can probably use the Current Path Id from the left side of my screenshot. That’s the path which triggered the transition from one step to another. The only exception would be if you have for example a flow

Hi Gerd, welcome to the community. :) I'm not sure that I understand what you mean with "calling" action. First of all a little naming clarification which: - We have paths which lead from on step to another. - Each path has a automation which can execute other automations. - An automations

Hi Przemyslaw, in case you want to use the suggested "API" approach. You can find here a detailed description: https://daniels-notes.de/posts/2023/copy-attachment-to-other-workflow It's using BPS 2023 but the approach itself would work in other versions too. Best regards, Daniel

Hi Andreia, first of all, why are you entering ids? This will break as soon as you transport the workflow. Take a look at the screenshot what I had in mind. You can either do it with the normal filter or in advanced mode. In either case this would be the generated filter in my case. Depending

Hi Nik, you could try to start the Designer Studio from the portal itself. If it does start, you can open the task manager, display the command line column and take a look at the parameters. In my Designer Studio shortcuts I use "C:\Install\DesignerStudio\2022.1.4.155\app-20221.4.155\WEBCON

Hi Andreia, you could do something like this where ((StartStepID = CURRENTSTEPID) and (Filter1)) or ((SecondStepId = CURRENTSTEPID) and (Filter2)) This way only the filter for the current step would be applied. Best regards, Daniel