Daniel Krüger (Cosmo Consult)

Hi Ondrej, whenever I have to return "true" in a SQL statement I return 1. That's safer in most cases. Quote from the blue info icon: " If query returns 1 or 'true' timeout will be associated with instance. Otherwise timeout will be ignored. " It's probably an problem with the spelling o

Another alternative is to use the visibility restriction of the field. You can read up on it in the blue info icon.

Hi, if you only need to hide/show fields based in steps and there's nothing more involved, than there's a simpler option. It's called field matrix and you can read up on it here: https://docs.webcon.com/docs/2023R2/Studio/Workflow/Forms/ Field matrix – the tab provides options to define

Hi piotrusx, could you share what the wrong setting was? It could help someone in the future. Best regards, Daniel

Hi Mark, you can only activate/deactivate a license using the designer studio. I don't remember since when it is possible but at some point in time an option was added to download the Designer Studio from the portal. I don't know when the option was added to use it remotely and I have to admin

Hi Andreia, there are Hyperlink functions which will allow you to do this. Take a look at the attached screenshot. Best regards, Daniel

HI Koral, just to make it clear for everyone who reads this. If I'm not mistaken, all the steps are handled directly on the database level. Therefore, this is not really a supported operation but achievable. Did I understand this correctly? Best regards, Daniel

Hi Marcin, right now I have no idea, but I would take a look at the usage tab of one column. Maybe there's some hint where the field is used and which could cause the deletion. It's great that this option was added in some version. :) Best regards, Daniel

Hi Rafal, I'm assuming that the small workflow uses either the "move workflow" action or the "big workflow" is waiting for completing the workflow. In either case you should be able to identify which workflow triggered the movement. If you are moving the big workflow, you could also store the el

I'm not aware of the changes in the "older" versions, as we need to keep up. Even so I should have remembered, that these versions also receive updates. Database sizes are not my area of expertise. So I can offer only general tips. Some of which no longer are an option. 1. Separate attachmen

Hi Robert, are you running BPS 2023 R2? If this is not the case it may help you to some degree. From the change log: Resolved the issue of the AutomationSessionExecutions table growing more than expected. Introduced a series of improvements which aim to limit the size of this table, e.

As a side effect the Change Log is also no longer available. In case someone needs it: It can be downloaded from the official news site: https://webcon.com/news/webcon-bps-2023-the-new-platform-release-is-officially-here/ https://webcon.com/wp-content/uploads/2023/05/Changelog_2023_1_1_39_EN.pd

Hi Adam, yes, COM_ID is used but not COM_GUID which is used for the transport. I didn't update the COM_GUID but I had to synchronize the IDs of global constants/fields which had been created manually on other environments. Best regards, Daniel

Let's argue high/pro code + no-code = low-code. high/pro code: JavaScript which you can put into a global form rule. No-code Using the global form rule. :)

Hi everyone, if you are using BPS 2023 and the option to translate labels via Excel, make sure to save all reports again. The following numbers are referring to the second attachment. After importing the translation the report configuration will look like (1) in the database. There's nothin

Hi Adam, there is/was not much documentation available. Im not sure about the current situation, but since I have gathered enough experience I don't look for it any more. Here are some information which may help you: https://developer.webcon.com/docs/external-form-field/ At the bottom ther

Hi Roman, do you need the functionality to export/import the dictionary entries? If this is not necessary, you can do the following: 1. Create a BPS Internal view for the Country dictionary. 2. Use the view for the Country field in the City dictionary 3. Make sure to use the workflow instan

Hi Adam, based on your ideas I'm guessing you know how to work with JS and CSS. You can use WEBCON internal endpoints to access the data. While the endpoint for a form /single workflow instance is quite simple the one for reports seem to require some more complex body, which I won't copy her

Damn, I didn't notice the and between the ifs. :)

Hi, if you click on the condition inside the if and press the 'Enter' key, you can use AND /OR operators. In addition, you can nest Ifs. In the next major version 2024 it's intended to have a "Case" operator. Best regards, Daniel