WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > User profile Karol Częczek > Forum messages

Karol Częczek

User

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.

WEBCON Raport
13.11.2023 09:05

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

ITEM list row coloring
27.10.2023 19:45

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

Visibility Button
25.10.2023 18:29

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.

Send file by Rest API
20.10.2023 09:07

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

dynamic text field
12.10.2023 10:38

Hi, you should also add an appropriate rule for the behavior when loading the page Regards.

Same Action, many Paths
09.10.2023 18:20

HI I guess it's something like this. In the back_all path, you can add common actions Regards.

Same Action, many Paths
09.10.2023 11:35

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.