Daniel Krüger (Cosmo Consult)

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

Hi everyone, does anyone has an idea /have a hack to move the attachments / comments option to a tab? I'm currently trying to create a form, which should: - look good or at least ok - be usable with a big multi line text box - while using the task "view" and displayed info panel - has to

Hi Serpa, if you referenced Azure.Core yourself, instead of it being used inside a package, I would suggest, to use the version which is actually used by WEBCON BPS. If it's the same version, you don't need to put it inside the .zip. If it's part of some package there may be a similar problem

Hi Nik, I have in mind, that moving the action to the OnEntry trigger of the step would help instead of executing it on the path. Of course, this may cause other issues, so you may need to have an option to "toggle" this with a technical field which is set during the path. If not, the only o