Daniel Krüger (Cosmo Consult)

Hi, if you have two databases and want to display all applications in one application you will require a custom MSSQL database connection. This database connection will use a user, who can access both databases. Then you could create you SQL query like: SELECT 'Main db' as DatabaseName, [AP

As it happens, I just stumbled about such a case and it made me realize one thing. If the history is displayed in admin mode, the hover should display the value as it is. The line is choose column in the item list with a GUID as a the id and a number as the display name. As you can see it's di

Hi Michał, in the audit trail / version history and there at least in the admin mode. Whenever we have a choose field / column, it would be great to have any kind of option to display the id. At the moment we have only the display name but I can think of a few cases, where the display name i

Hi Björn, the string replace uses a regular expression in the background. You can simply escape the dot with a \ so that the regular expression looks for the dot character and not for any character. It looks a little strange int eh designer studio though. @Michał I hope they are not chang

Hi Michał, do you want to transfer only the data of the workflow instances or the database as mentioned in your question? In the later case, you could take a look at this post: https://daniels-notes.de/posts/2023/copy-a-database Best regards, Daniel

Hi Maria, when you read the following keep in mind, that I have no real experience with Hot mail box. Form rules and style and behavior actions are only executed in the browser. Since the instance is updated through the hot mailbox feature, there's no browser involved. Instead the service user

Hi Raluca, as far as I can tell the display name is not always resolved and in the DB only the ID is stored. I don't know when it happens but there are some cases. When the workflow instance is then displayed in the form, the fields are "recalculated" and if you hit save, the data may be update

Hi Björn, while using Unicode for formatting text my be suitable for LinkedIn, I would advice against it in the community. Even if the search get's improved, it won't be able to find unicode text. After all I'm using a regular keyboard and the characters are mapped to a code which differs fro

Hi Maks, I suggested the same to a customer, the reply I got was: This doesn't work on an iPad. Best regards, Daniel

Hi Matthias, I'm sorry I have no further idea. I have only iOS and can't do any tests with android. Best regards, Daniel

Hi Björn, the short answer is, no it's not and I have no idea how change it. If I remember correctly, there's also a User Voice regarding this, that there should be a switch to change the default behavior of the link and the icon. Best regards, Daniel

Hi Matthias, did you activate the notifications in your user profile? That's the only remaining setting I can think of. Best regards, Daniel

HI Wojtek, the easiest way is to care a local automation parameter. You can use this parameter to store the sub-workflow id. Afterwards you can use a change value action to store the value in the parameter in the item list column. Best regards, Daniel

Hi Maks, your case is similar to ours I just modified it slightly for the blog post. We have a parent with child workflows, and in each child workflow we have also an overview of the other child workflows with their comments. Best regards, Daniel

Hi Mihai, thanks for the information. These type of things are always good to know. Best regards, Daniel

Hi, There's not necessarily a need to use the API. You can remove workflow instances using the archive action with retention mode: Remove from content database https://docs.webcon.com/docs/2023R3/Studio/Action/DBRetention/Action_ArchiveElements I'm using this quite a lot. Cyclical action

Hi Mihail, maybe there are other means, but the only way I know of is to use a "Create a task" action. There is a little information here about how it can be used: https://docs.webcon.com/docs/2023R3/Studio/Action/TaskAssign/Action_TaskCreation If you use this, then you don't necessarily ne

Hi, could we have an option to define global HTML fields? This would allow us to define the HTML field ones instead of multiple times in multiple process. Best regards, Daniel

Hi Paweł, as you noticed, a report can only display process fields, if a single process is selected. One exception to this are global fields. You have the option to add a calculated column to retrieve other information. Depending on the number of calculated columns and the complexity of the SQL

Hi, I have no idea, which information you mean, but if you are interested in the group members SELECT users.COS_BpsID FROM [dbo].[CacheOrganizationStructure] as users join [dbo].CacheOrganizationStructureGroupRelations as groupMebers on users.COS_ID = groupMebers.COSGR_UserID