Daniel Krüger (Cosmo Consult)

Hi Andreia, in your case I would use this sql statement: select DET_ID from WFElementDetails where DET_WFFID = {WFD_ID} and DET_WFCONID = ItemListId -- Condition to define which rows should be deleted. and FIELDDatabaseName > 0 If you use the DET_ID for the unique value, all rows wil

That's a question I've yet to answer for myself. Which kind of "code" is SQL. Most of the time it is "low code" for me but not "no code". :) There's also the option to use the "Advanced search", where you could return the WFD_ID of the latest workflow instance. Best regards, Daniel

Hi Andreia, which version are you using? Depending on the answer the SDK will either not work and may be obsolete anyway. With 2023 R1 or R2 an option was provided in the update item list action to remove rows. https://webcon.com/docs/2024R1/Studio/Action/Form/Action_UpdateItemListValues

I don't mind where, but I ___need___ the raw value. :)

Hi, there's no need to look for any information. This feature is removed/will be removed in later versions. Unfortunately, I don't find the document where I read it. Edit: In 2024.1.1.48 it is already removed. Best regards, Daniel

Regarding different behaviors of item list actions I can recommend reading this: https://daniels-notes.de/posts/2024/importing-applications-using-an-application#empty-and-null-handling-depends-on-the-item-list-action

Hi Paweł, when a workflow instance uses follows a path all tasks will always be completed. If the path is set to "wait for completion" the workflow instance will not be using the path. It will only be saved. Therefore I see only two option. 1) If you only need to update fields, you could us

Hi, I have to admit, I have never seen the benefit of the filter condition and always applied the filter in the SQL statement itself. So, I'm not sure whether there can be an actual issue with business rules and parameters in this action. Besides this, did you activate the diagnostic mode and

Hi, could you copy the configuration of the timeout? If the timeout executes a path, the insert condition is evaluated again. If this is false then the timeout should no longer be created and once all timeouts are removed from the database, you should be able to remove it from Designer Studio

Hi Mario, I have never faced a similar use case, the only 100% solution would be to: - Create the tasks with an action - Set completion mode of the path to "any" and not parallel - Move the workflow to a flow control, which verifies the requirements - If the requirements are not met, move bac

Hi, this error typically indicates, that the WEBCON BPS server can not connect to the SQL server (instance). This may be due to different reasons. - Wrong SQL server instance - Firewall prevents the communication - SQL Server Configuration manager: The protocol is disabled used for connect

Hi Andreia, I'm sorry but for some reason I don't receive any notifications and so I have to check any updates manually. If you don't delete rows, than it would be fine to just compare the number of rows. I haven't tested this in WEBCON but the below query could work when used in the OnEntry

I would also opt for the dictionary approach. The most important think here is to actually create a dictionary report and not a table report. Otherwise you could activate the export option but you wouldn't be able to us the import. Besides this the exported file differs also depending on the type.

Hi Maks, did you test this or did you run into issues with this? __ Also your environments DEV/PROD are now divergent - on DEV field is using WFD_AttText5, and on prod the same field uses WFD_AttText6. In case of any complex reports that require column names you'll have remember at every singl

Hi Lukasz, thanks for the update. :) For the moment I added an additional check, whether the group contains the expected members. This will of course fail, when someone modified the group via the BPS Portal instead of the process, but it made me realize, that I add some "maximum wait time" che

Hi everyone, I have a process which updates the group members. This is done in async mode because the synchronization takes a while. I'm trying to prevent updates by moving the workflow to a step which checks whether the synchronization is finished. As far as I found out so far a job get's ad

Hi Andreia, I sometimes face a situation, where I want to access the data via SQL and the values are not yet written / available for different reasons. In these cases I move those "read" actions from the path to the OnEntry and everything works fine. I'm not sure whether this would apply in

Hi, I would implement it in another way. As far as I understand it, this would always set a technical field which in turn invokes the menu action. This would always save the instance, which may not be so good for the use experience. I see two options, one with a technical field as suggested a

Thanks, I just noticed it myself. :) Unfortunately I don't receive any notifications, also everything is activated. :(

Hi Andreia, the issue is, that the field is marked as technical. If a field is a technical field, it is not part of the DOM and therefore doesn't exist for the browser. Therefore, setting an HTML field to technical makes no sense. :) Best regards, Daniel