Karol Częczek

Hi, You can extract this data from table WFD_EnterToCurrentStepDate SELECT WFD_EnterToCurrentStepDate, DATEDIFF(DAY, WFD_EnterToCurrentStepDate, GETDATE()) AS DaysElapsed FROM wfelements WHERE wfd_id = 102711 Regards.

Hi A useful option would be to add the ability to set the horizontal layout of attributes directly in the tab. The same as now it is possible in the group of form fields. Regards.

Hi, You probably don't have a free license anymore, check in Studio > Reports > licenses > license usage. The only quick option is to deactivate the license service in bps studio and activate it again (you must have authorization data for activation). Then assign a new user to the license when

Hi, WFD_Att Choose columns have size nvarchar(1000). When using the 'allow multiple values' mode and having translations in the source into 3-4 languages, additionally if the ID is e.g. guid, this value is exceeded very quickly. Is it possible to increase the database size of this type of colu

Hi. In version 2023, the method of handling company selection when starting from a tile has been changed. Previously, if the remaining parameters were defined in the button configuration, a form was immediately displayed and the company could be changed directly there. Currently, a popup always

HI DECLARE @TodayDate AS DATE = GETDATE(); SELECT UPPER(FORMAT(@TodayDate, 'MMM')) + '.' + FORMAT(@TodayDate, 'dd') + '.' + FORMAT(@TodayDate, 'yyyy') AS FormattedDate; --Another format DECLARE @TodayDate AS DATE = GETDATE(); SELECT CONCAT( FORMAT(@TodayDat

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