Karol Częczek

Hi, in version 2023 table dbo.WFElementTasks has been replaced by tables dbo.ActiveTasks and dbo.HistoryTasks. dbo.WFElementTasks is currently a database view. Performing updates directly on webcon tables is not something that should be practiced :) Regards.

Hi, I don't remember exactly how long it takes to release the license who is inactive, probably after 90 days of inactivity. But if you set his account as inactive in AD (you probably need to synchronize after that), you will be able to release the license in the studio immediately. Regards.

It would be very useful from the users' point of view to add the ability to change the order/position rows of the item list by dragging. Regards

HI, There is probably no great solution to this. For example, I try to add all reports in the documentation section, whether on attributes, shares, etc. Of course, not all, only those that are important in the context of changes. This is very helpful when searching. But you also need to rem

Hi, Maybe it would be a good idea for a new automation to be created by default to receive the name of the element for which it was created. This would help keep the system tidy, reduce the workload for each time you assign a name,. And for people who prefer other names, nothing will change becau

Hi I don't know which version of the system you have, but in 2023 you can add global automation and use it in all processes in the older version, you can add a global business rule and use it in an action, but you will have to create actions for each process separately

Hi, If you want to actually remove all permissions for users, it doesn't matter how they got them (SEC_REASON) But remember that if the user has a task in the elements for which you will delete the user's permissions, he will lose the ability to execute it, because the task assignment action g

Hi, I checked it but on the 2023 version and it works properly, from what I remember, I also used it on the 2021 version. Check if you really have the column set as required in the matrix, because the rule acts as a requirement limit. Or check with the console running (F12) whether any errors

Hi, There is no ready-made solution, but you can build a simple application and use automation to achieve what you want. As you noticed, in the WFSecurities table you have login information. You can join the dbo.CacheOrganizationStructure table and filter by the COS_AccountType = 1 column,

Hi In the configuration database dbo.Substitutions dbo.SubstitutionDetails Regards

Hi, You can set up a linked server between SQL servers. It is also possible to create a custom data source using the SDK Regards.

Hi, Turning on the debug mode as Rafał wrote, the SQL query generating the report data can be found in the section as in the screenshot I am attaching. But if the query takes a long time and returns timout, then you can use SQL Studio and, for example, using Activity Monitor, 'catch' the query

HI Use if try_cast('' as int) > 20 select .... Regards

Hi, Add actions to change the value of a field or multiple fields, add an appropriate query that will correctly calculate what you need. You can create a technical path and add actions to it and then perform a mass shift along this path from the report level. Pay attention to protect yourself

Hi The data in the list does not include the attachment itself. Attachments need to be added with the appropriate action, copying attachments. Additionally, the relations in the list of attachments will correspond to the 'original element', so this will need to be updated after adding attachmen

Hi, During import, if you select the import permissions option, they will be set as in the environment from which you created the package. Regards

Hi, Adding a configuration option to the process for the selected environment, e.g. TEST, "Always import in deployment mode" This will eliminate the mistake of not selecting this option during import and will facilitate the import without searching for and selecting this option. Regards.

Hi, I am attaching an example of how I have it set up, it should be helpful, as for Postman, if you insert the binary part, it should also be sent. Regards

HI yes, these are operations performed directly on the database. Regards.

HI, check [dbo].[ContentDatabases] Regards.