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.
Hi Daniel. Transferring attachments to another or a new database is a straightforward process. Here are the steps to achieve this: 1. Create a new database specifically for storing attachments associated with the process. 2. Update the DEF_AttachmentsDatabase entry in the WFDefinitions table fo
HI, use 'AND' instead 'IS IN'
Hi The reason is probably completely different. You haven't set any message that is returned if the request returns 0, so a system message is returned. that the validation returned 0. And it returned 0 because your query is missing the current element exclusion. The action is performed in the
Hi Use cast as datetime
Hi, you should also add an appropriate rule for the behavior when loading the page Regards.
HI I guess it's something like this. In the back_all path, you can add common actions Regards.
If you add an execution condition, as I described, the action will only be executed if the specified paths are used Regards
HI The set connection only indicates the context in which the query is to operate, but in From you must provide a specific table in which the CompanyID and GroupID columns are located.