Daniel Krüger (Cosmo Consult)

Hi Flo, do you want to use the for each row function in a form rule or the for each operator in an automation: The later one is documented here: https://community.webcon.com/posts/post/for-each-operator/319/3 If it's in the form rule you can use the get row value function. Select values w

A complete check would be when the chosen signature would check against the signature definition as well as against the existing instances. In case a signature was changed over time. Of course this would only work for „static“ signatures which don’t rely on business rules /field values.

Hi Björn, in this case I would create an "intermediate" workflow, which has a "start as Subworkflow action" there you can overwrite the Author with the system account. I once had to implement an "innovations/ideas" application where all ideas should be public but the author should not be visib

Hi MIchal, there are also the Admin* logs like AdminWFEventLogs https://community.webcon.com/posts/post/the-adminwfeventlogs-table/137 Unfortunately I can't remember which information are stored where and whether they are stored in CONFIG or CONTENT database. You could also take a look at

Hi Björn, I was wondering whether you already had a solution for this, but it slipped my mind. There's no other way than doing it with a custom SDK action. If you want you could take this option: https://daniels-notes.de/posts/2022/remove-item-list-rows Best regards, Daniel

Hi Björn, the column of foreign key (DET_WFCONID) often is a abbreviation of the table. WFCON refers to WFConfigurations So you get the name in the designer using: SELECT [WFCON_ID] ,WFCON_Prompt FROM [dbo].[WFConfigurations] where WFCON_ID = 4687 If you want to take translations i

Duplicate message , "Send message" seemed to be stuck without posting the message.

Duplicate message , "Send message" seemed to be stuck without posting the message.

Just after writing the thread, it came to me that I should just use the SQL Profiler to see, why it doesn't work anymore. There's a default where condition which would only return those dictionary entries which are active. /*SUBSTITUTIONSFILTER*/ AND WFD_AttBool1 = ''True'' /*ADVANCEDSEARC

Hi everyone, does anyone has an idea, why a data source dictionary would not return all data, also "access data in the context of system account" is checked? I was banking my head on the wall, why the form validation stopped working until I noticed that the lastest workflow instances are not

Hi Nik, we don't have this version and I can't check it. The only idea I have is to, modify the process and export it to use the Export/Import mechanism of designer studio to import the documents. If it's a new report though you should check first, whether a "Report table" was accidently sel

Hi Jacek, there was a time before the connection existed. It was introduced at some point and than the bps_user was introduced. It's more secure but adds a little problem like the one you found. I encountered the same message when trying to read data from a separate attachment database. Sinc

Hi Mateusz, I'm sorry I should have checked it, and not assumed how this is intended to work. Seems to be related to the type of picker and/or data source. It's good, that you found an easy alternative. Best regards, Daniel

Hi Mateusz, while this is an option, if you are using BPS Portal, there is an option to deactivate showing Links, for choose/picker fields. Best regards, Daniel

Hi Mark, executing a SQL statement with declare doesn't work in the Designer studio, but it does work anyway. But you don't need it in this case, you can return the WFD_Description from a query inside the dbo.SplitToTable() At least if you want to do it for a single workflow. select * fr

Hi Mark, using your example, the below could be an option declare @comment varchar(max) = '[03/16/2023 07:05:23] Katarina Pisek|#The new product looks great! |;[03/16/2023 07:45:16] Andrej Susek|#Thanks! |;[03/17/2023 08:23:16] Katarina Pisek|#You''re welcome.|;' For some reason I can't co

Hi Marek, I don’t have an example for the classic form. Could you post a sample value? I assume it’s still stored in the WFD_Description column? Best regards, Daniel

Hi Mark, you can find an example for: - Getting the comments with OPENJSON, available as of SQL Server 2016 and without - A sample for using a data table in an HTML template to generate a pdf https://daniels-notes.de/posts/2023/comments-to-data-table-and-pdf Best regards, Daniel

Hi Mark, I'm only aware of this topic, but it's related to upgrading the database compatibility level to 2019. https://community.webcon.com/posts/post/webcon-bps-databases-in-the-sql-2019-compatibility-level/320 So it should be fine to update to 2016, at least I hope so, as I've just done it

Hi Mark, I'm not aware of this kind of option, but you could create a data table field which lists the comments. Here are different examples on how to retrieve the comments. Your best bet is the first one at least if you are running SQL Server 2016 and can change to database compatibility to