Daniel Krüger (Cosmo Consult)

Hi Ingo. you are right these changed with version 2022. I know I've read somewhere about this change but I couldn't couldn't find it again. The only thing I remember is that applications registered with prior 2022 will work as before but new ones have to be configured using the new options. I

Hi Nik, it seems that idea 2 would have worked, but won't do so in the future: From the change log of 2021.1.5, and this will probably be included in the next 2022 version too. Added a mechanism for checking the integrity of data set in the choice fields with data source values configured f

Hi Ingo, more information about starting a workflow via REST can be found here: https://developer.webcon.com/docs/bps-rest-api/ This page has also a link to this sample: https://github.com/WEBCON-BPS/develop-docs/tree/ver/2021.1.1/HelloWorlds/WebCon.BPS.HelloWorld.RestAPI Best regards, D

Hi Nik, can you switch the mode of the field from dropdown to autocomplete or popup search? Then you could set the value of the field to the workflow id and it will work just fine. I blogged about the same approach here: https://daniels-notes.de/posts/2022/add-new-choice-field-value-without-lea

Hi Adam, thanks for the update. I tend to forget to look at the installation guide, sometimes there are worthwhile information. :) I'm cross linking this thread in case someone stumbles about the "dynamic compression module" BPS 2022: Enable IIS feature "Dynamic Component" https://community.

Linking this thread which has the same topic with a slightly different query: Form field count report of an application https://community.webcon.com/forum/thread/1239?page=1#m1240

Hi Fabian, ROW_Number is not allowed, this has also been added to the info tooltip in BPS 2022: Quote Because of this mechanism, there are certain limitations to the query syntax, such as: 1. The query should return the data in the following format: SELECT column1, column2, ... FROM table_n

Hi kaluser, default values are only set when they are empty. Since the default value is executed when the Form is opened it automatically assigns value 2. At least if the workflow population I'd hasn't been set in a previous step. You could change the business rule and some other properties to

Hi Radek, that's the correct behavior as you have not specified that after the 11 digits nothing else should follow. Actually even a string like a12345678901asd would be a match. You can easily test the regex using the online tool which is linked in the designer studio. If you want that only 11

Hi Darek, the simplest way for your case could be the following: Add an html field where you define the css style. #SEL_SQLGrid_728 td[data-column="WFD_Signature"] { font-weight: bold; } #SEL_SQLGrid_728 tr:nth-child(odd) { background: yellow; } Replace the ID 728 with a reference o

There's always something new to learn. :) For example a documentation, the blue info icon, was added which sql functions can not be used in a sql query. :)

Hi Michał, I added the item lists definitions and a sample of the action which grants "Read-only" privilieges. If you are wondering, why I used three item lists. I struggled till I came up with a working version which I can also "debug". :) Best regards, Daniel

Hi Michał, I can confirm that it works with the Add Privilegs action. Also I haven't used it with thousands of workflow instances. My use case: There are three workflow instances which determine the current Privilegs of the first workflow. Under specific circumstances a 'privilege maintenanc

Hi, there's also an option without storing the value in a technical field: If you don't mind using undocumented features, you could try to use the {R:} variable to access an URL parameter https://alterpaths.com/usage-of-url-parameters-in-webcon-bps/ Alternatively you could use the previ

Hi kaluser, it seems that I can't help without seeing the data. This would be my approach in your case check... which data is returned by the inner select statement? Which data is returned without the AttChoose conditions? when does the statement fail Include the WFD_ID as well as the DT

Hi Bo, you can use the below script as a starting point. I ignored all privileges which are directly assigned on the workflow instance level and I didn't resolve group memberships. It also ignores the privileges on application level, but than these are not relevant for accessing workflows.

Hi kaluser, if I understand it correctly the workflow can only be saved if the combination of all three columns hasn't been used in another workflow. But in this case I don't understand why is a problem. Scenario7: Form2 Subform1(value exists) step1- not able to save - It is an issue Or sho

Hi Marcin, I'm aware this won't help you in your situation, but the new "Substitutions on behalf" feature of BPS 2022 would help you. An admin could simply setup a substitution for the primary person and it's applications and define the current substitute. https://community.webcon.com/posts/p

Hi kaluser, it think you would see the issue, if you would display the results of the inner select without the AttChoose conditions. These four values would be part of the selected columns. I just noticed another potential issue. What you want to do is: Check whether another workflow, usin

Hi kaluser, the choose value in the database contains the id as well as the name. Therefore the where condition will always be false if you compare only the name. The functions are below, but you can also select the correct one from the objects tab in the expression editor. dbo.ClearWFElemIDAd