Daniel Krüger (Cosmo Consult)

Hi jp, you are right. The parameter {ATT_NAME} is still a placeholder when the business rule is executed, unfortunately. I verified this using the SQL profiler. I also noticed, that this is only executed once for all attachments. So this isn't an option anyway. If you don't want to resort to a cus

Hi Darek, the action 'Update related workflow instance' with 'Element selection mode' SQL query should do what you want: https://community.webcon.com/posts/post/the-update-related-workflow-instance-action/81 Best regards, Daniel

Hi Fabian, I wasn't even aware that you had the option to select business rules. :) If only those with SQL Commands are not displayed you could test whether data rows/data tables are an option in your case. Sometimes I create an own field group "WordFields" which consists of data tables specifica

I just noticed, that the preview doesn't reflect the user language. It just uses the language of the current designer. If the language of the Designer Studio is en-Us and I provide a translation value for this language, it is ignored. Maybe this could be taken into account, too. :) Maybe the Design

Hi Nik, the OnTimeout is created when a workflow enters a step with the current configuration. If you change the interval this will only apply to workflows which entered the step afterwards. If you want to repeat something for all workflows you need to create a cycling action. I think it's on the t

Hi Tim, I have no better idea than creating a CustomAction. The parameter type 'RunCustomActionParams' has a 'CurrentDocument' which has an UpdateDocumentCompany function: RunCustomActionParams.Context.CurrentDocument.UpdateDocumentCompany Unfortunately the type returned by DocumentsManager does

Hi Andrea, this well get a little difficult, especially when you have nested business rules. I don't have a direct solution for you but I can provide you with a starting point. I've a few procedures which search the whole database. You can find a screenshot of the result here and a description of

Hi Michał, I also would recommend to change your approach. Even if you would increase the timeout you may run into it again at a later point in time. Another alternative could be to execute a PS Script, which spawns a new session and executes your script. You could use the invoke-sqlcmd for this.

Hi Kamil, at least in version 2021.1.3.205 there's still a problem. I've added a picker field, target field and a sorting field. Changed the sorting of the item list to the field and saved a workflow instance with three rows. I cleared the target fields (1), and added three rows. When I populate

Hi Kamil, which version are you running? If it's a new one you should create a support ticket if you encounter something as weird as this. If it's an older one someone here may test it in a newer version. We are running 2021.1.3.205 and I will test it tomorrow morning. Best regards, Daniel

Hi Christian, maybe removing the attachment section could be an option: We have a similar use case and we are hiding the Attachment section all together. As you noticed you can not really delete an attachment via the item list. So deleting/detaching them would leave an attachment which can not be

Hi Christian, you are right, in most cases returning a true/false directly would be better. In my case I'm reusing the SQL command (business rule) inside the action. Since I don't want to duplicate the command , I prefer having a single point of failure, I've used this approach. Best regards, Dan

Hi Michał, if put the SQL command inside an own business rule and used this in the check. This worked fine. Best regards, Daniel

Hi Fabian, I may haven't read it correctly in the beginning, so the users don't have edit privileges at all? If they don't have these privileges I don't see an option. At least if you don't want to create some kind of "shadow" workflow, which I won't recommend. Wouldn't it be possible, to grant th

Hi Fabian, did you set the Edit permission in the field matrix in all steps? If the field is in a group or tab, they must be editable too. From the info icon: If the option to display the form field as ‘Read-only’ or ‘Read-only (editable by JavaScript)’ is selected in the Field Matrix, any define

Hi Jacek, you could use a custom Portal translation file: Explanation: https://community.webcon.com/posts/post/translation-of-webcon-bps-portal-user-interface-content/102 Website: https://bpstranslator.webcon.com/ I wasn't aware that there are so many controls which have 'Business Entity' in the

Hi Maxi, this refers to the config of the BPS Portal, but I would suggest to redesign your approach. - Maybe a timeout won't occured if you execute is inside a BPS OnTimeout action. - Maybe you can cache the result to a database/file which you can update periodically via Task Scheduler. - If you do

Hi Michał, interesting question and I hope someone can shed some light on it. I once asked a similar question during a training and my only memory on it is, that there are multiple tables involved which would be need to be modified. So my take away was: Don't try to change it, a signature ones us

Hi Fabian, I'm not aware of a dedicated documentation but I found two knowledge base entries: https://community.webcon.com/posts/post/javascript-basic-functions-in-the-html-form-fields/163 https://community.webcon.com/posts/post/javascript-functions-in-the-html-form-fields-part-3/179 The JavaScrip

Hi Sebastian, you are right, the attachments are not immediately available. I've a JavaScript stub for these kind of rules. Here's an example for the current case using a boolean field to toggle the attachments. JavaScript to be used in the value change: if (#{BRP:33}# == 1) { $("[data-ty